Infrastructure at your Service

Category

Cloud

Franck Pachot

Oracle DB on Azure with Multitenant Option

By | Cloud | 3 Comments

By Franck Pachot . If you want to run an Oracle Database in the Microsoft Azure cloud, you will install it yourself on a VM. And then, you can expect the same as when you install it in your premises, in a virtual environment. Except that Oracle makes it two times more expensive by accepting to license the processor metric on vCPUs at the condition that the Intel core factor is not applied. And in…

Read More
Joël Cattin

AWS EC2 instance deployment with Terraform

By | AWS, Cloud | No Comments

When it comes to quickly provision a server in the Cloud, using an Infrastructure as Code (IaC) tool is a solution to consider. There are many IaC products available and among them, Terraform seems to be the most popular. The following is a non-exhaustive list of Terraform advantages : – Terraform can deploy infrastructure to multiple cloud service providers simultaneously – With Terraform, you can easily preview and validate infrastructure changes before they are applied…

Read More
Franck Pachot

Google Cloud SQL Insights: ASH, plans and statement tagging

By | Cloud, Postgres | No Comments

By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost optimization. When looking at host metrics, you see only the symptoms and blindly guess at some solutions: add more vCPU if CPU usage is high, more memory if I/O wait is high. And this can be…

Read More
Nabil Saoual

JENKINS Quick overview on Jenkins and Jenkins X

By | Cloud, DevOps | No Comments

Hi everybody, During previous blog ,we ever talked about Jenkins , but what about Jenkins X ?What are the differences between the two, which one is fitting the best for your needs? History of Jenkins X As the cloud technology were growing along years Developers were asking for a tool that fit to this new standard, helping them to increase their development and to simplify it especially with containerization and usage of Kubernetes orchestrator ,that…

Read More
Franck Pachot

Google Spanner – SQL compatibility

By | Cloud | No Comments

By Franck Pachot . I have posted, a long time ago, about Google Spanner (inserting data and no decimal numeric data types) but many things have changed in this area. There is now a NUMERIC data type and many things have improved in this distributed SQL database, improving a bit the SQL compatibility. gcloud I can use the Cloud Shell, which is very easy – one click fron the console – but here I’m showing…

Read More
Furkan Suv

Exoscale scaling up and down

By | Cloud | No Comments

In my previous Blog I had wrote about Swiss Cloud Provider: Exoscale. Read the Blog Today we will look little bit deeper in three subjects: Template & Template sharing Scaling up and down instances dbi CentOS 8 & Debian 10 Templates Templating On Exoscale you can create custom Template from you current Instance. Custom Templates can make your daily work easier. We will look also how we can share Templates.  Starting with the GUI: 1….

Read More
Franck Pachot

Amazon Aurora: calling a lambda from a trigger

By | AWS, Cloud | No Comments

By Franck Pachot . You may want your RDS database to interact with other AWS services. For example, send a notification on a business or administration situation, with a “push” method rather than a “pull” one from a Cloud watch alert. You may even design this call to be triggered on database changes. And Amazon Aurora provides this possibility by running a lambda from the database through calling mysql.lambda_async() from a MySQL trigger. This is…

Read More
Franck Pachot

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

By | Cloud, Postgres | One Comment

By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures because there is often confusion, which I tried to clarify in What is a database backup (back to the basics). And the terms used in managed cloud services or documentation is not very clear, not always the same, and sometimes…

Read More