Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
January 18, 2022
Attack No-PK Replication Lag with MySQL/Percona Server 8 Invisible Columns!
The most common issue when using row-based replication (RBR) is replication lag due to the lack of Primary keys. The [...]
January 17, 2022
Comparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 3)
Recently we published the first part (m5, m5a, m6g) and the second part (C5, C5a, C6g) of research regarding comparing [...]
January 11, 2022
Online DDL With Group Replication in MySQL 8.0.27
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with [...]