In our previous blog post about observability, we explained how to build a comprehensive view of how your SQL workloads behave, and the many reasons why it is important to have this view. In this blog post, we will take a closer look into the four types of SQL query, and how they can impact […]
Explaining slow queries to my manager Read More »
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 »
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 »
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 »
In our tour of OVHcloud’s Internal Databases Infrastructure, we showed you what our infrastructure looks like. This post will be about SQL replication, why it matters, and how we use it at OVHcloud. Nodes are not enough: they have to work together. To do that, we rely on a feature called replication to keep data
Database replication 101 Read More »
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 »
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 »
At OVH, our first mission as a cloud service provider is to provide products with high quality of service (QoS). Whether they are dedicated servers, cloud servers or hosted websites, our customers expect our solutions to be very high quality. And that’s exactly what our teams strive to offer you on a daily basis! It’s
Introducing DepC: the OVH platform for computing QoS Read More »
In previous articles, we saw what are the operational and techniques constraints of the migration project of our data center in Paris. If you have not followed everything on our technical constraints, I invite you to reread the article presenting the infrastructure of our web hosting. We built our migration scenarios by taking these constraints
Web hosting: How to migrate 3 Million web sites? Read More »
In 2018, we launched one of the largest projects in OVH’s history: migrating the 3 million websites hosted in our Paris datacentre. If you want to discover the reasons behind this titanic project, we took a look at them in this post. It is now time to explain how we proceeded with this project. We have
Web hosting: how to host 3 million websites? Read More »
