Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 25, 2022
Okta – Percona’s statement
On 22nd March 2022 08:43 UTC, we became aware of the issue affecting Okta, a third-party identity provider that Percona [...]
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 [...]
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 16, 2022
Economical Comparison of AWS CPUs for MySQL (ARM vs Intel vs AMD)
It is always hard to select a CPU for your own purpose. You could waste hours reviewing different benchmarks, reviews, [...]
February 11, 2022
Incremental Backup in MySQL Using Page Tracking
Incremental backups of MySQL, specifically for the InnoDB engine, are taken by copying modified pages from the previous backup. The [...]
February 9, 2022
Percona Utilities That Make Major MySQL Version Upgrades Easier
It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade [...]
February 8, 2022
Introducing xbcloud: Azure Blob Storage Support in Percona XtraBackup
Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers [...]
February 3, 2022
Optimize SST in Percona XtraDB Cluster with ZSTD Compression
Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used [...]
January 27, 2022
Percona Operator for MySQL – Alpha Release
Operators are a software framework that extends Kubernetes API and enables application deployment and management through the control plane. For [...]
January 20, 2022
Percona XtraBackup Changing to Strict by Default
Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in [...]