by Pep Pla | Dec 11, 2025 | Insight for DBAs, MySQL, PostgreSQL
Being a Tale of Databases, Binary Logs, WAL Files, and the Redemption of Ebenezer Scrooge, DBA Part the First — In Which We Meet Ebenezer Scrooge, Database Administrator Extraordinary It was a cold, dark, and CPU-bound night. The wind blew fierce across the datacenter...
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 Sveta Smirnova | Dec 8, 2025 | MySQL, Open Source, Percona Software
In today’s interconnected world, data security is paramount. Protecting sensitive information transmitted between applications and databases is crucial, and SSL/TLS (Secure Sockets Layer/Transport Layer Security) plays a vital role in achieving this. Percona...
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 Dennis Kittrell | Nov 25, 2025 | Insight for DBAs, MySQL, Percona Software
At Percona, our mission has always been to help you succeed with open source databases. We do that by listening to the community, understanding the challenges you face, and building the solutions you need. Now, after a comprehensive review of market trends and direct...
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 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;...
