Databases

A day in the life of a ProxySQL at OVHcloud

As explained thoroughly in an earlier post, the P19 migration meant we needed to add a new element to our infrastructure… namely the ProxySQL. Life was not easy for it at first, but it soon learned how to handle the diverse range of configurations your websites have, particularly when it comes to making sure the path connecting

A day in the life of a ProxySQL at OVHcloud Read More »

Contributing to Apache HBase: custom data balancing

Contributing to Apache HBase: custom data balancing

In today’s blogpost, we’re going to take a look at our upstream contribution to Apache HBase’s stochastic load balancer, based on our experience of running HBase clusters to support OVHcloud’s monitoring. The context Have you ever wondered how: we generate the graphs for your OVHcloud server or web hosting package? our internal teams monitor their

Contributing to Apache HBase: custom data balancing Read More »

migrate-datacentre --quiet: How do we seamlessly migrate a datacentre?

migrate-datacentre –quiet: How do we seamlessly migrate a datacentre?

In our previous articles, we explained why we had to move 800,000 databases from one datacentre to another, 300 kilometres away. So here we are… We did it!Now we will focus on a very important goal of any migration. From your point of view, as a customer, you must see… Nothing! I understand this completely,

migrate-datacentre –quiet: How do we seamlessly migrate a datacentre? Read More »

Improve your SQL workload with Observability

Improve your SQL workload with observability

Our team of database administrators used to be overwhelmed by our developers’ needs. Picture this: we had only 1.5 database admins per more than 400 tech people (DevOps, developers etc.), with only 24 hours in a day! This was a perfect use-case for observability. But what is observability, apart from a buzzword? To me, observability is

Improve your SQL workload with observability Read More »

How to win at the massive database migration game

In our previous articles, we explained why we had to move 800,000 databases from one datacentre to another, 300 kilometres away. So here we are… My team and I did it! It was a real brain-burner, so I hope our story will help you to address more of the huge technical projects we love to

How to win at the massive database migration game Read More »

Internal database architecture

OVHcloud’s internal databases infrastructure

Today, most applications rely directly or indirectly on databases. I would even take a bet and say that a large portion of those are relational databases. At OVHcloud, we rely on several dozens of clusters hosting hundreds of databases to power thousands of applications. Most of those databases power our API, host billing information and

OVHcloud’s internal databases infrastructure Read More »

Web hosting – How do our databases work?

In our series of articles about migrating web hosting infrastructure from Paris to Gravelines (the first of which is here), we neglected to mention the databases. This is however a very important part, with 800,000 databases to be migrated! In these new series of posts, we will tell you about our experience with web hosting

Web hosting – How do our databases work? Read More »

Conteneuriser des bases de données avec Docker… une idée folle ?

OVH propose deux types de bases de données dans le cadre de ses offres d’hébergement web : les bases de données mutualisées et les bases de données privatives « SQL privées ». S’ajoute à cela un troisième type de bases, proposé dans le cadre de la nouvelle offre « Cloud Database ». Nous vous dévoilons

Conteneuriser des bases de données avec Docker… une idée folle ? Read More »