by Fernando Mattera | Nov 3, 2022 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
by Corrado Pandiani | Nov 2, 2022 | Insight for Developers, MySQL
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for a long time. In case you are not familiar with UNION, don’t worry, I’m going to show you how it works with simple examples. Considering...
by Zsolt Parragi | Jul 6, 2022 | Cloud, MySQL, Percona Software
Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this...
by Yura Sorokin | Jun 30, 2022 | Insight for DBAs, MySQL, Percona Software, Security
Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners. In Percona Server for MySQL...
by Carlos Tutte | Oct 16, 2020 | Insight for DBAs, MySQL, Percona Software
Changing the default value (3) of log_error_verbosity in MySQL/Percona Server for MySQL 5.7 can have a hidden unintended effect! What does log_error_verbosity do exactly? As per the documentation: “The log_error_verbosity system variable specifies the verbosity for...
by Carlos Tutte | Aug 12, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of...
by Yura Sorokin | Jul 27, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1? This is the question I have been struggling with for years and it looks like...
by Przemysław Malkowski | Jun 29, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona...
by Patrick Birch | Aug 15, 2019 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 8.0.16-7 on August 15, 2019 (downloads are available here and from the Percona Software Repositories). This release is based on MySQL 8.0.16. It includes all bug fixes in these releases. Percona Server for...
by Borys Belinsky | Oct 31, 2018 | MySQL, Open Source, Percona Software
Following the alpha release announced earlier, Percona announces the release candidate of Percona Server for MySQL 8.0.12-2rc1 on October 31, 2018. Download the latest version from the Percona website or from the Percona Software Repositories. This release is based on...
by Dmitriy Kostiuk | Sep 20, 2018 | MySQL, Percona Events, Percona Software, ProxySQL
ProxySQL 1.4.10, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Dmitriy Kostiuk | Jul 16, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Dmitriy Kostiuk | May 31, 2018 | MySQL, Percona Events, Percona Live, Percona Software, Security, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....
by Dmitriy Kostiuk | Apr 24, 2018 | MySQL, Percona Events, Percona Live, Percona Software, Security, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.21-21 on on April 24, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....
by Dmitriy Kostiuk | Mar 12, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.6, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Robert Golebiowski | Mar 8, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Security
In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between...
by Dmitriy Kostiuk | Feb 19, 2018 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.21-20 on February 19, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....
by Dmitriy Kostiuk | Jan 8, 2018 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.20-19 on January 3, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....
by Hrvoje Matijakovic | Dec 14, 2017 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.20-18 on December 14, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....
by Roel Van de Paar | Dec 12, 2017 | Insight for DBAs, MySQL, Percona Software
Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC. On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate. I tested the MySQL...
