by David Ducos | Jan 29, 2026 | Insight for DBAs, MySQL
When a replica fails due to corruption or drift, the standard solution is to rebuild it from a fresh copy of the master when pt-table-sync is not an option. Traditionally, when we need to build a new replica, we use a physical backup for speed, but there are some...
by Anil Joshi | Jan 27, 2026 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Storage Engine
In this second part of the blog post, we will explore how the PXC Replication Manager script handles source and replica failover in a multi-source replication topology. Multi-source replication is commonly used when data from multiple independent sources needs to be...
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 Kamil Holubicki | Jan 20, 2026 | MySQL, Percona Software
Remember when Percona significantly improved query processing time by fixing the optimizer bug? I have described all the details in More Performant Query Processing in Percona Server for MySQL blog post. This time, we dug deeper into all the ideas from Enhanced for...
by Edith Puclla | Jan 16, 2026 | Cloud, MySQL, Percona Software
by Anil Joshi | Jan 12, 2026 | Insight for DBAs, MySQL, Percona Software
In this blog post, we will be discussing the PXC Replication Manager script/tool which basically facilitates both source and replica failover when working with multiple PXC clusters, across different DC/Networks connected via asynchronous replication mechanism. Such...
by Dennis Kittrell | Jan 5, 2026 | Insight for DBAs, MySQL, Percona Software
For decades, we’ve accepted a painful compromise: if you wanted logic inside the database, you had to write SQL/PSM (Persistent Stored Modules). It’s clunky, hard to debug, and declarative by nature, making it terrible for algorithmic tasks. That ends with Percona...
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
