The Percona Database Performance Blog

Your Galera cluster’s hardest problem was never the replication library

Ask anyone who runs a multi-node MySQL Galera Cluster in production about their worst night. Almost nobody says write-set replication was wrong. They ...

DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL – Part 1

MySQL is very good at serving application workloads, but things get more complicated when somebody decides to run a large report on the same server. A...

Percona ClusterSync for MongoDB 1.0.0 is Generally Available

On behalf of the entire product and engineering team, I’m pleased to announce that Percona ClusterSync for MongoDB (PCSM) 1.0.0 is now generally avail...

What Is Running on My MongoDB Right Now? Real-Time Analytics in PMM

The Problem The application is slow, the Slack channel is on fire, and somebody asks the oldest question in our job: What is running on the database r...

Thread Pool in Percona Server and MySQL (Part 1)

Thread Pool in Percona Server and MySQL (Part 1) A new version of Community MySQL Server July release contains two versions 26.7.0 and 9.7.2. It is an...

Tuning Percona ClusterSync for MongoDB Performance

Percona ClusterSync for MongoDB (PCSM) synchronizes data from a source MongoDB cluster (including Atlas) to a target MongoDB cluster in two stages. It...

Percona ClusterSync for MongoDB Goes Highly Available: Active-Standby Failover

Editor’s Note: This article was originally authored by Inel Pandzic. Migrating data between MongoDB clusters is rarely a five-minute job. A larg...

Valkey Memory Optimization, Version by Version and Encoding: How Many Bytes Did Each Release Actually Save?

Introduction This RAM/Memory reduction is most useful for Valkey 9.1 environments that are key string heavy. They are used extensively in caching, ses...

PgQ and PgQue: Workflow Engines you might need in PostgreSQL

In many real production databases, we often see some tables receiving high-frequency updates (millions per day) and autovacuum running repeatedly (hun...

When pt-online-schema-change “where” Meets Galera: Understanding Chunk Auto-Resize and Flow Control

Percona Toolkit’s pt-online-schema-change (pt-osc) has long been the preferred solution for performing online schema changes with minimal downti...