by Edwin Wang | May 20, 2024 | MySQL, Percona Software
If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a...
by Arunjith Aravindan | May 13, 2024 | Insight for DBAs, MySQL, Percona Software
Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted...
by David Quilty | May 9, 2024 | Insight for DBAs, MySQL, Security
Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL...
by David Stokes | May 1, 2024 | Insight for DBAs, MySQL
MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing...
by David Quilty | Apr 23, 2024 | Insight for DBAs, MariaDB, MySQL, Percona Software
Apples or oranges? Tea or coffee? Books or eBooks? Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list? MariaDB or MySQL? It’s time...
by Taras Onishchuk | Apr 19, 2024 | Insight for DBAs, MySQL
Yes, but now it likes them more, and here is why. Intro Using the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don’t get to see the output (i.e., in a non-interactive session)....
by David Quilty | Apr 18, 2024 | Insight for DBAs, MongoDB, MySQL, PostgreSQL
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of experience as a DBA or whether you manage databases for a small or large...
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 Przemysław Malkowski | Apr 15, 2024 | Insight for DBAs, MariaDB, MySQL
If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally. Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge...
by Ninad Shah | Apr 12, 2024 | Insight for DBAs, MySQL, PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this...
by Brijesh Chauhan | Apr 11, 2024 | Insight for DBAs, MariaDB, MySQL
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not...
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...
