by Kate Obiidykhata | Nov 18, 2025 | Cloud, MySQL, Percona Software
The Percona Cloud Native team is happy to announce the general availability of the Percona Operator for MySQL, based on Percona Server for MySQL. This release introduces an additional Kubernetes-native approach to deploying and managing MySQL clusters with synchronous...
by Pep Pla | Nov 14, 2025 | Insight for DBAs, MySQL, PostgreSQL
I’m lazy when I’m speakin’ I’m lazy when I walk I’m lazy when I’m dancin’ I’m lazy when I talk X-Press 2 Feat. David Byrne – Lazy While preparing a blog post to compare how PostgreSQL and MySQL handle locks,...
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 Hieu Nguyen | Sep 30, 2025 | Insight for DBAs, Insight for Developers, Valkey
by David Quilty | Sep 26, 2025 | Insight for DBAs, MySQL, Percona Services
We’ve mentioned this a few times here on the blog already, but in case you missed it, MySQL 8.0’s end-of-life date is April 2026. This probably sounds forever away, but it’s going to sneak up before you know it. Maybe you’ve been putting off thinking about...
by David Quilty | Sep 18, 2025 | Database Trends, MySQL
AI and machine learning are seemingly everywhere, and that’s forcing every database company to think about vector search. Companies want to build things like smart search that actually understands what you mean, recommendation systems that know what you’ll...
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 Quilty | Sep 9, 2025 | Insight for DBAs, MySQL, Percona Software
Right now, you’re probably hoping someone else will deal with this MySQL 8.0 end-of-life situation. Maybe your team can squeeze another few months out of it. Maybe Oracle will extend support. Maybe it won’t be as bad as everyone says. We get it. ...
by Pep Pla | Sep 8, 2025 | Insight for DBAs, MongoDB, MySQL, PostgreSQL, Security
Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind this tool is to replay a captured sequence of queries that were executed on a different database server. This is very useful to validate if a new version of the...
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 David Quilty | Aug 22, 2025 | Insight for DBAs, MySQL
If you manage a MySQL database, you’ve probably heard the news: MySQL 8.0 is heading for its End of Life (EOL), and taking center stage is MySQL 8.4, the first-ever Long-Term Support (LTS) release. This is great news for all of us who value stability, as it means a...
by David Quilty | Aug 14, 2025 | Insight for DBAs, MySQL, Open Source, Security
Your MySQL database has been running smoothly for years. Your team knows it inside and out. Everything just… works. Why rock the boat with an upgrade? Here’s why: MySQL 8.0 reaches its end-of-life date in April 2026. After this date, there’s no safety net;...
by David Quilty | Aug 6, 2025 | MySQL, Percona Services, Percona Software
If you’re running MySQL 8.0 databases, you need to know this: Oracle will stop supporting them in April 2026. That means no more security patches, bug fixes, or help when things go wrong. Maybe you’re thinking, “But April 2026 feels far away!”....
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 Pep Pla | Jul 3, 2025 | Insight for DBAs, MySQL, PostgreSQL
Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. This post is about how to handle torn pages. As a long-time open source database administrator, I have always been...
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...
