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...
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...
by Arunjith Aravindan | May 12, 2025 | Insight for DBAs, MySQL
by Anil Joshi | May 8, 2025 | Insight for DBAs, MySQL
by Juan Arruti | Apr 21, 2025 | Cloud, MySQL, Percona Software
When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer...
by Arunjith Aravindan | Apr 17, 2025 | MySQL
MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become...
by Yura Sorokin | Apr 15, 2025 | Insight for DBAs, MySQL, Percona Software
In Percona Server for MySQL 8.0.41 / 8.4.4, we significantly re-designed the Data Masking Component. In particular, we made the following changes: Changed the user on behalf of whom we execute internal queries for dictionary operations. Introduced an in-memory...
by Yura Sorokin | Apr 9, 2025 | MySQL, Percona Software, Security
In Percona Server for MySQL 8.0.41 / 8.4.4, we introduced several improvements in Encryption User-Defined Functions. Added support for RSAES-OAEP (OAEP) padding for RSA encrypt / decrypt operations. Added support for RSASSA-PSS (PSS) padding for RSA sign / verify...
by David Quilty | Apr 2, 2025 | Insight for DBAs, MariaDB, MySQL
This post was originally published in May 2024 and was updated in April 2025. MySQL and MariaDB are two major open source database management systems that share a common codebase and history. MariaDB started as a MySQL fork in 2009 to provide an alternate database...
by Satya Bodapati | Mar 24, 2025 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona XtraBackup 8.4 Pro introduces improvements in how DDL (Data Definition Language) locks (aka Backup Locks) are managed,...
by David Quilty | Mar 19, 2025 | Insight for DBAs, MySQL
MySQL databases serve as the foundation of countless applications, powering everything from simple blogs to massive enterprise platforms. But as these applications evolve and user bases expand, MySQL performance issues tend to pop up and ensuring smooth database...
