by Marco Tusa | Jan 23, 2026 | Benchmarks, MariaDB, MySQL
This article is focused on describing the latest performance benchmarking executed on the latest releases of Community MySQL, Percona Server for MySQL and MariaDB. In this set of tests I have used the machine described here. Assumptions There are many ways to run...
by Julia Vural | Jan 22, 2026 | MySQL, Open Source
Over the past weeks, we have seen renewed discussion/concern in the MySQL community around claims that “Oracle has stopped developing MySQL” or that “MySQL is being abandoned.” These concerns were amplified by graphs showing an apparent halt in GitHub commits after...
by Pep Pla | Dec 9, 2025 | Insight for DBAs, MySQL
A unique constraint specifies, one or more columns as unique it identifies. It is satisfied only when no two rows store the same non-null values at its core. A primary key constraint is a unique one that will say PRIMARY KEY in its defined way. It is satisfied only...
by Edith Puclla | Dec 4, 2025 | Cloud, MySQL
When we run databases in Kubernetes, we quickly learn one important truth: things will fail, and we need to be prepared for this. Pods are ephemeral; nodes can come and go, storage is abstracted behind PersistentVolumes and can be either local to a node or backed by...
by Vadim Tkachenko | Nov 26, 2025 | MySQL, Open Source
Where We Are We can all agree that the MySQL ecosystem isn’t in great shape right now. Take a look at Julia’s blog post [Analyzing the Heartbeat of the MySQL Server: A Look at Repository Statistics], which confirms what many of us have felt: Oracle...
by Julia Vural | Nov 24, 2025 | Insight for DBAs, MySQL
The MySQL database server is a foundational component of the open-source world. While its impact is undeniable, looking at the raw statistics of its core source code repository reveals a dynamic and sometimes surprising development history. By analyzing the total...
by Yves Trudeau | Nov 5, 2025 | Benchmarks, Insight for DBAs, MySQL, Storage Engine
In a recent post, The Quirks of Index Maintenance in Open Source Databases, I compared the IO load generated by open source databases while inserting rows in a table with many secondary indexes. Because of its change buffer, InnoDB was the most efficient solution....
by Corrado Pandiani | Oct 28, 2025 | Insight for DBAs, Insight for Developers, MySQL, Percona Software, Security
Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, or testing. It is particularly useful when you collaborate with external entities and need to share your data for...
by Yunus Uyanik | Sep 17, 2025 | Insight for DBAs, MySQL
When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins —...
by David Ducos | Aug 25, 2025 | Insight for DBAs, MySQL
How do you know if your backup is truly reliable? The last thing you want is to discover your data is corrupted during a critical restore or during a migration. While MyDumper is a powerful tool for logical backups, its -M option takes backup integrity to the next...
by Przemysław Malkowski | Aug 21, 2025 | Insight for DBAs, Insight for Developers, MySQL
by Vinicius Grippa | Jul 22, 2025 | Insight for DBAs, MySQL
When troubleshooting a MySQL crash, having only the error log is rarely enough to pinpoint the exact root cause. To truly understand what happened, we need to go deeper—into the memory state of the process at the moment it crashed. That’s where GDB, the GNU Debugger,...
by Fernando Laudares Camargos | Jul 18, 2025 | Database Trends, Insight for DBAs, MySQL
My first experiments creating an MCP Server to provide AI access to a PostgreSQL database using the FastMCP Python framework and Anthropic’s and OpenAI’s APIs highlighted an important requirement: for now, these two APIs can only communicate with an MCP server through...
by David Ducos | Jul 14, 2025 | Insight for DBAs, MySQL
In my previous blog post, Understanding trx-consistency-only on MyDumper Before Removal, I talked about –trx-consistency-only removal, in which I explained that it acts like a shortcut, reducing the amount of time we have to block the write traffic to the...
by Julia Vural | Jun 26, 2025 | Insight for DBAs, MySQL, Open Source, Percona Software
At Percona, we’ve always been dedicated to providing robust, open source high availability solutions that meet our users’ evolving needs. Percona XtraDB Cluster (PXC) stands as a testament to this commitment, offering a highly available and scalable solution for...
by Anil Joshi | Jun 20, 2025 | Insight for DBAs, MySQL, Storage Engine
Managing farms of MySQL servers under a replication environment is very efficient with the help of a MySQL orchestrator tool. This ensures a smooth transition happens when there is any ad hoc failover or a planned/graceful switchover comes into action. Several...
by Dmitry Lenev | Jun 5, 2025 | MySQL, Open Source, Percona Software
TL;DR Percona Server for MySQL now offers experimental support for stored programs in the JS language. This free and open source alternative to Oracle’s Enterprise/Cloud-only feature enables users to write stored programs in a more modern, convenient, and often...
by Arunjith Aravindan | May 29, 2025 | Insight for DBAs, MySQL
by Arunjith Aravindan | May 20, 2025 | Insight for DBAs, MySQL
by Yura Sorokin | May 19, 2025 | Insight for DBAs, MySQL, Percona Software
In this blog post, we will describe typical usage scenarios for dictionary operations in the Data Masking Component, which is available in Percona Server for MySQL as an open source alternative to Oracle’s enterprise version. In particular, we will consider the...
