Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 23, 2021
myloader Stops Causing Data Fragmentation
During the development of the myloader –innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities [...]
August 20, 2021
Storing JSON in Your Databases: Tips and Tricks For MySQL Part Two
JSON Structure, The Next Generation (Performance, Scale, and Fun) Now you know the basic JSON functionality available to you, as [...]
August 19, 2021
Dynamic User Creation with MySQL on Kubernetes and Hashicorp Cloud Platform Vault
You may have already seen this document which describes the integration between HashiCorp Vault and Percona Distribution for MySQL Operator [...]
August 19, 2021
Storing JSON in Your Databases: Tips and Tricks For MySQL Part One
Database architecture and design are becoming an increasingly lost art. With new technologies and the push towards faster development cycles, [...]
August 17, 2021
First Packages for Debian 11 “bullseye” Now Available
Over the weekend, the Debian project announced the availability of their newest major distribution release, Debian 11 (code name “bullseye”). [...]
August 13, 2021
Get an Amazon Gift Card for a Review!
Note: This promotion has ended. The next 10 user reviews for Percona Server for MySQL will receive a $10 Amazon [...]
July 13, 2021
Cluster Statuses in Percona Kubernetes Operators
In Kubernetes, all resources have a status field separated from their spec. The status field is an interface both for [...]
July 12, 2021
How To Recover Percona XtraDB Cluster 5.7 Node Without SST
The Problem State Snapshot Transfer can be a very long and expensive process, depending on the size of your Percona [...]
July 9, 2021
Streaming MySQL Binlogs to S3 (or Any Object Storage)
Problem Statement Having backups of binary logs is fairly normal these days. The more recent binary logs are copied offsite, [...]
July 9, 2021
MySQL/ZFS Performance Update
As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As [...]
July 7, 2021
Migrating Ownership of Your Stored Routines, Views, and Triggers in MySQL
“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW [...]
July 7, 2021
Inspecting MySQL Servers Part 5: Percona Monitoring and Management
In the previous posts of this series, I presented how the Percona Support team approaches the analysis and troubleshooting of [...]
July 6, 2021
MyDumper 0.10.7 is Now Available
The new MyDumper 0.10.7 version, which includes many new features and bug fixes, is now available. You can download the [...]
July 5, 2021
MySQL Shell 101 – System Log
One of the new features introduced in MySQL 8.0.24 was the ability to log all SQL statements that are issued [...]
July 1, 2021
Using MySQL 8 Dual Passwords
MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, [...]
July 1, 2021
Installing Percona Server for MySQL on Rocky Linux 8
With the CentOS project switching its focus to CentOS Stream, one of the alternatives that aim to function as a [...]
July 1, 2021
Percona Monitoring and Management – MySQL Semi-Sync Summary Dashboard
Some of you may use MySQL’s asynchronous replication feature called Semisynchronous Replication (aka semi-sync), and now with the MySQL Semi-Sync [...]
June 30, 2021
Complex Archival with Percona Toolkit’s pt-archiver
The Problem I recently worked on a customer engagement where the customer needed to archive a high amount of rows [...]
June 25, 2021
Percona XtraBackup for Windows
Don’t Try This at Home! Disclaimer: The procedure described in this blog post is not officially supported by Percona XtraBackup. [...]
June 24, 2021
Deploy a Dedicated Percona Server for MySQL 8.0 in Azure
This quickstart shows you how to use the Azure portal to deploy a dedicated Percona Server for MySQL 8.0 drop-in [...]