Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
September 13, 2024
All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented
The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, [...]
September 10, 2024
How to Migrate a Production Database to Percona Everest (MySQL) Using Clone
This long article aims to provide you with the instructions and tools to migrate your production database from your current [...]
September 4, 2024
Percona In-Product Telemetry: Updates, Findings, and News
This article is, in fact, two topics merged into one publication. Both are related to anonymous statistical data collection within [...]
August 30, 2024
When Warnings Deceive: The Curious Case of InnoDB’s Row Size Limitation
Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning [...]
August 26, 2024
Percona Server for MySQL Performance Improvements – August 2024
At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed [...]
August 20, 2024
How to Run Percona Toolkit in Kubernetes
Percona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC [...]
August 19, 2024
Why You Should Consider an External Replica for Your Cloud Environment
In current times, there is a high degree of focus on ensuring the availability and recovery of your production data. [...]
August 14, 2024
Effective Strategies for Recovering MySQL Group Replication From Failures
Group replication is a fault-tolerant/highly available replication topology that ensures if the primary node goes down, one of the other [...]
August 8, 2024
MySQL Router and RestAPI – What Do They Have in Common?
The usage of MySQL Router as a Middleware/Proxy/Router has increased along with the rise in MySQL InnoDB Cluster usage. While [...]
July 25, 2024
Severe Instability of MySQL 8.0.38, 8.4.1 and 9.0 Resolved in Upcoming Releases
A couple of weeks ago, my colleague Marco Tusa published an important announcement titled “Do Not Upgrade to Any Version [...]
July 22, 2024
Online Schema Changes on Tables with Foreign Keys in MySQL
pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But [...]
July 19, 2024
MySQL 9.0 Includes a New Option for Explaining Queries
MySQL 9.0 is an Innovation Release, but as you may have read in my Quick Peek, I found little innovation. [...]
July 18, 2024
How to Have a Single MySQL User Account From Specific Hosts
In this article, we will demonstrate how to have a single MySQL database user account that can connect from specific [...]
July 17, 2024
Ultimate Guide to Improving MySQL Query Performance
Have you ever waited far too long for a MySQL query to finish and wondered if there’s a better way? [...]
July 16, 2024
No MySQL 9.x Innovation Releases from Percona
On July 1st, 2024, Oracle launched MySQL 9.0.0, the first release in the 9.x series. This release and the following [...]
July 15, 2024
Using pt-online-schema-change for Purging Rows and Reclaiming Disk Space in a Single Operation
You probably missed the news, but… PT-1751: Adds –where param to pt-online-schema-change This brings the possibility to perform what I [...]
July 15, 2024
Percona Server for MySQL and Percona XtraBackup Now Available for ARM64
We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red [...]
July 12, 2024
Using the Percona Audit Logging Plugin on MySQL Community 8.0.x
At Percona Managed Services, we manage Percona MySQL, Community MySQL, and MariaDB. Sometimes, we might need to enable audit logging [...]
July 11, 2024
Do Not Upgrade to Any Version of MySQL After 8.0.37
Warning! Recently, Jean-François Gagné opened a bug on bug.mysql.com #115517; unfortunately, the bug is now private. However, the bug looks [...]
July 9, 2024
MyLoader Is Now Importing at Full Speed
For a long time, I’ve been thinking about the possibility of importing a single file with multiple connections. Why? Simply [...]