Databases

Another day in ProxySQL life: sharing is caring

This post is another part of our list of short posts pinpointing specific cases OVHcloud has dealt with, both preparing for and during the migration. Here, we tell a story of how sometimes, a little unexpected behaviour can lead to a bug fix in a software program used by millions of people around the world. …

Another day in ProxySQL life: sharing is caring Read More »

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 »