by Sveta Smirnova | Jun 12, 2024 | MongoDB, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and...
by Kamil Holubicki | Jun 12, 2024 | Insight for DBAs, MySQL, Percona Software
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. In the first part of this blog post, we learned how to enable GCache and Record-Set cache encryption in Percona XtraDB Cluster. This part will explore the details of the...
by Peter Zaitsev | Jun 10, 2024 | Database Trends, MySQL, Open Source
Some 15 years ago, when Oracle acquired Sun, and hence MySQL, there was a lot of talk on the internet over when Oracle was going to “Kill MySQL”. Multiple theories were circled around, ranging from killing MySQL altogether, so there is less competition to proprietary...
by Kamil Holubicki | Jun 7, 2024 | Insight for DBAs, MySQL, Percona Software
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. Data breaches are a major concern today. Whether you’re a business owner or value your privacy, the thought of your sensitive information being exposed is unsettling....
by Smit Arora | Jun 1, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in September 2023 and was updated in June 2024. In simple terms, a join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. Some of...
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...
