Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 20, 2022
Finding Differences Between MySQL Servers
When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through [...]
April 19, 2022
PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion
Concurrent access to data within PostgreSQL is managed with the Multiversion Concurrency Control (MVCC) model. Data snapshots are maintained for [...]
April 15, 2022
Correcting MySQL Inaccurate Table Statistics for Better Execution Plan
Abstract: By diving into the details of our case study, we will explain how incorrect table statistics may lead the [...]
April 13, 2022
Overcoming VACUUM WRAPAROUND
Transaction ID Wraparound occurs when the VACUUM process cannot keep up with database activity and the PostgreSQL service is forced [...]
April 6, 2022
Upgrade your Libraries: Authentication Plugin ‘caching_sha2_password’ Cannot be Loaded
For my previous blog post on the topic, I received plenty of questions about why I did not cover the [...]
April 5, 2022
Hidden Cost of Foreign Key Constraints in MySQL
Do you wonder if MySQL tells you the truth about writes to tables that have foreign key constraints? The situation [...]
March 30, 2022
MySQL Shell For VS Code – Your New GUI?
MySQL Shell For VS Code integrates the MySQL Shell directly into VS Code development workflows and was released last week. [...]
March 29, 2022
Migrating to utf8mb4: Things to Consider
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor [...]
March 28, 2022
MariaDB 10.9 Quick Peek
MariaDB 10.9 is a preview release of the popular open source database server and is considered alpha level code (pronounced: [...]
March 25, 2022
Percona Monitoring and Management Security Threat Tool
Percona Monitoring and Management (PMM) is a multi-faceted tool that includes the Security Threat Tool which provides the ability to [...]
March 24, 2022
PostgreSQL From the Perspective of a MySQL DBA
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the [...]
March 24, 2022
A Dive Into MySQL Multi-Threaded Replication
For a very long part of its history, MySQL replication has been limited in terms of performance. Because there was [...]
March 23, 2022
MySQL 8: Multi-Factor Authentication Overview
As part of my ongoing series around MySQL 8 user administration, I’d like to cover one of the new features [...]
March 22, 2022
MySQL 8: Password Verification Policy
In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced [...]
March 22, 2022
Authentication Plugin ‘***’ Cannot Be Loaded: How MySQL Searches Client-Side Plugins
When MySQL client connects to the server it uses one of the authentication plugins. On the server-side, plugins are located [...]
March 16, 2022
MySQL 8.0.28 Quick Peek
Oracle released MySQL 8.0.28 on January 18th with little fanfare, as part of their four times a year release cycle. [...]
March 10, 2022
Using Percona Server for MySQL 8.0 and Percona XtraBackup 8.0 with HashiCorp Vault Enterprise KMIP Secrets Engine
KMIP (Key Management Interoperability Protocol) is an open standard developed by OASIS (Organization for Advancement of Structured Information Standards) for [...]
March 4, 2022
DBaaS in Under 20 Min!
My father always used the expression, “sometimes the juice ain’t worth the squeeze”. What he meant by it was, “what [...]
February 28, 2022
Backup/Restore Performance Conclusion: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup
A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, [...]
February 25, 2022
Logical Replication/Decoding Improvements in PostgreSQL 13 and 14
I recently blogged about how Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster. In [...]