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 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 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 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 Dov Endress | Mar 17, 2025 | Insight for DBAs, MySQL, Percona Software
In this blog, we will look at the differences between LTS (Long Term Stable) versions of Percona Server for MySQL. Released in April 2019, MySQL 8.0 represented a major change from the previous version, 5.7, introducing significant changes to the data dictionary and...
by Steve Hoffman | Mar 10, 2025 | MySQL, Percona Software
Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server for MySQL (PS) version 5.7.44-52 and Percona XtraDB Cluster (PXC) version 5.7.44-31.65.5. This release is an accumulation of several...
by Fernando Mattera | Dec 19, 2024 | Insight for DBAs, MySQL, Percona Software
This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying...
by Valeria Bogatyreva | Sep 16, 2024 | MySQL, Percona Software
Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for...
by Julia Vural | Aug 26, 2024 | Benchmarks, MySQL, Percona Software
At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases,...
by Alina Derkach | Jul 15, 2024 | Insight for DBAs, MySQL, Percona Software
We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red Hat Enterprise Linux (RHEL) 8/9 and Oracle Linux (OL) 8/9. The packages with the aarch64.rpm extension can be found on Percona Software...
by Roberto De Bem | Apr 16, 2024 | Insight for DBAs, MariaDB, MySQL
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out...
by Yunus Shaikh | Mar 18, 2024 | MySQL, Percona Software, Security
Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption...
by Marco Tusa | Feb 6, 2024 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base. To my knowledge...
by Dimitri Vanoverbeke | Aug 15, 2023 | Insight for DBAs, MySQL
This blog was originally published in February 2017 and was updated in September 2023. In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works, its benefits and challenges, as well as reviewing some of the MySQL...
by David Stokes | Mar 1, 2023 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 5.7 has had a good, long run, but the official End of Life is October of 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Yup, six months away. So if you are running MySQL, you need to consider upgrading to...
by Dmitry Lenev | Feb 20, 2023 | MySQL, Percona Software, Security
Introduction/TLDR: We are considering changing EXPLAIN in Percona Server for MySQL to require less privileges for providing execution plans for INSERT/UPDATE/DELETE statements (and possibly changing the behavior for EXPLAIN SELECT as well), to make it more convenient...
by David Stokes | Dec 1, 2022 | Insight for DBAs, MySQL, Percona Software
Data masking is a handy tool to obscure sensitive information. Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation including...
