Percona's MySQL & InnoDB performance and scalability blog
91k followers 2 articles/semaine
Percona Backup for MongoDB and Disk Snapshots in Google Cloud Platform

Percona Backup for MongoDB (PBM) supports snapshot-based physical backups. This is made possible by the backup cursor functionality present in Percona Server for MongoDB.  The flow of snapshot-based physical backup consists of these stages: Preparing the database – done by PBM Taking the snapshots – done by the user/client app Completing the backup...

Wed Oct 2, 2024 16:25
MongoDB: New Balancer Policy and Automerger

MongoDB provides scalability and high availability at ease. If you already have a sharded cluster, you know for sure what the Balancer does. If you are not an experienced MongoDB user, the Balancer is one of the key components of a sharded cluster, and the main goal is to maintain the cluster balanced, moving chunks […]

Mon Sep 30, 2024 16:17
Dealing with a ‘DatabaseVersion.timestamp’ Error After a MongoDB Upgrade

Recently, one of our customers reported a problem after upgrading a sharded cluster from MongoDB 5.0 to 6.0. The upgrade of data-bearing nodes was fine, but in the final part of the process, where mongos routers needed to be restarted, the new version did not go well. This caused problems for the applications, where suddenly […]

Thu Sep 26, 2024 16:10
How Network Splits/Partitions Impact Group Replication in MySQL

In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for some insight. Topology: [crayon-66f55bf9e3e33244017927/] Scenario 1: One of the GR nodes...

Wed Sep 25, 2024 16:37
Understanding MySQL Indexes: Types, Benefits, and Best Practices

When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL. Without an index, MySQL must perform a...

Tue Sep 24, 2024 00:45
MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?

There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with some important news from Marco Tusa. In one of his blog posts, Marco strongly advised...

Tue Sep 17, 2024 17:30

Construisez votre propre fil d'actualité

Prêt à tenter le coup ?
Commencer un essai de 14 jours, aucune carte de crédit n'est requise.

Créer un compte