by Edith Puclla | Apr 9, 2024 | Insight for DBAs, MySQL, Percona Services, Percona Software
We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023. In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now...
by Arunjith Aravindan | Apr 2, 2024 | Insight for DBAs, MySQL, Percona Software
This blog was originally published in January 2023 and was updated in April 2024. MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It...
by Ankit Kapoor | Apr 2, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in January 2023 and was updated in April 2024. Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance...
by Kedar Vaijanapurkar | Apr 2, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June of 2023 and updated in April of 2024. As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring...
by Ananias Tsalouchidis | Apr 1, 2024 | Insight for DBAs, MySQL, ProxySQL
ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following: Added support for caching_sha2_password! This is great news for the community! The caching_sha2_password authentication method for frontend connections is now...
by Brian Sumpter | Apr 1, 2024 | Insight for DBAs, MySQL
This blog was published in April of 2021 and updated in April of 2024. In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In some cases a...
by Larry Xia | Mar 29, 2024 | Insight for DBAs, MySQL
At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The...
by Yoann La Cancellera | Mar 28, 2024 | Insight for DBAs, Insight for Developers, MySQL
Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in...
by David Stokes | Mar 26, 2024 | MySQL, Open Source, Percona Software
MySQL is a very popular database and a good choice for new projects. But is it the best choice? Luckily you have several options for this choice. MySQL Community vs. Enterprise Editions Traditionally, the MySQL Community Edition has been a mainstay in the open source...
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 Sergey Pronin | Mar 11, 2024 | Cloud, MySQL, Percona Software
Volume Expansion, a feature that became generally available since Kubernetes version 1.24, allows users to increase the capacity of their Persistent Volumes and underlying storage within Kubernetes. There is no need to use clouds’ UI or APIs to do that anymore. In...
by Bartek Gatz | Mar 5, 2024 | MySQL, Percona Software
What makes a great user experience? There are probably as many answers to this question as there are users because we are talking about very subjective and personal feelings and observations. While there are multiple experts at Percona, we also believe that one should...
by Edith Puclla | Feb 22, 2024 | Cloud, MySQL, Percona Software
In our last post, we looked into the lifecycle of applications in Kubernetes. We see that Kubernetes doesn’t handle database backups itself. This is where Kubernetes Operators come into action. They add additional functions to Kubernetes, enabling it to set up,...
by Edith Puclla | Feb 20, 2024 | Cloud, MySQL, Percona Software
This post was originally published on the Percona Community blog. If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through, from initial...
by Przemysław Malkowski | Feb 9, 2024 | Insight for DBAs, MySQL
Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster...
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 David Stokes | Feb 6, 2024 | Insight for DBAs, MySQL, Security
Are your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security of your data, but there is a way to exclude inappropriate words or phrases from being used. The first step is to compile...
by Ninad Shah | Feb 2, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and was updated in February of 2024. On occasion, DBAs come across segmentation fault issues while executing some queries. However, this is one of the least-explored topics to date. I tried to search for details...
by Peter Zaitsev | Feb 1, 2024 | MySQL, Open Source
FOSDEM is for sure one of the most respected free and open source software-focused conferences in Europe, which is loved by many, myself included. It is from the point of love I am raising concerns about transparency, which seems to be lacking in regard to some...
by David Stokes | Feb 1, 2024 | Database Trends, Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and updated in February of 2024. For more than a quarter of a century, people have been discussing “Which is better, MySQL vs PostgreSQL?” — with no resolution. When people ask me which is better, I have to ask them...
