Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 18, 2024
Partial Data Archiving and Schema Change
Starting from Percona Toolkit 3.6.0, pt-online-schema-change supports the option –where, so you can not only alter your table definition live [...]
June 17, 2024
Can Oracle Save MySQL?
I got quite a response to my article on whether Oracle is Killing MySQL, including a couple of great write-ups [...]
June 14, 2024
Resume Your Failed pt-online-schema-change Job
Starting from Percona Toolkit 3.6.0, you can resume pt-online-schema-change if it was interrupted. This blog describes the prerequisites and usage [...]
June 13, 2024
Sakila, Where Are You Going?
At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version [...]
June 12, 2024
What’s New in Percona Toolkit 3.6.0
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility [...]
June 12, 2024
GCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part Two
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. In the first part of this blog [...]
June 10, 2024
Is Oracle Finally Killing MySQL?
Some 15 years ago, when Oracle acquired Sun, and hence MySQL, there was a lot of talk on the internet [...]
June 7, 2024
GCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part One
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. Data breaches are a major concern today. [...]
June 1, 2024
SQLJoins: A Quick But Comprehensive Guide
This blog was originally published in September 2023 and was updated in June 2024. In simple terms, a join in [...]
May 20, 2024
Can We Set up a Replicate Filter Within the Percona XtraDB Cluster?
If you were to ask me the question, “Would it be possible to set up a replicate filter within the [...]
May 16, 2024
Choosing the Right Database: MariaDB vs. MySQL, PostgreSQL, and MongoDB
Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application [...]
May 13, 2024
Seamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations
Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: [...]
May 9, 2024
Securing Your MySQL Database: Essential Best Practices
Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer [...]
May 1, 2024
MySQL 8.4 First Peek
MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. [...]
April 23, 2024
Why MariaDB Is “Better” Than MySQL
Apples or oranges? Tea or coffee? Books or eBooks? Each of these comparisons has very similar features and serves many [...]
April 19, 2024
Did MyDumper LIKE Triggers?
Yes, but now it likes them more, and here is why. Intro Using the LIKE clause to filter triggers or [...]
April 18, 2024
How to Improve Database Performance: The Ultimate Guide
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and [...]
April 16, 2024
A Guide to Better Understanding MySQL Charset Levels
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and [...]
April 15, 2024
Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB
If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) [...]
April 12, 2024
Partially Rolling Back a Transaction in MySQL or PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to [...]