Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 1, 2022
Data Masking With Percona Server for MySQL – An Enterprise Feature at a Community Price
Data masking is a handy tool to obscure sensitive information. Percona Server for MySQL is a free, fully compatible, enhanced, [...]
November 30, 2022
Upload Ongoing MyDumper Backups to S3
If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to [...]
November 30, 2022
PHP 8.0 Reaches End of Life
While the LAMP stack – Linux/Apache/MySQL/PHP – is not the dominant platform it was a decade ago, there are still [...]
November 29, 2022
MySQL Data Archival With Minimal Disruption
We all know that data is important, and some businesses need historical data to be available all the time. The [...]
November 29, 2022
PMM, Federated Tables, Table Stats, and Lots of Connections!
Earlier in the year, I was working on an issue where one of my clients had reported a massive influx [...]
November 25, 2022
Small Business Saturday: Supercharging Your Database for the Holiday Shopping Surge
Shopping mayhem on the day after Thanksgiving exploded in the 1950s and ’60s, with cops dubbing it Black Friday. Internet [...]
November 25, 2022
Exploring Data Dump and Load Utility With MySQL Shell
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What [...]
November 23, 2022
Online DDL Tools and Metadata Locks
One thing I commonly hear when working with my clients is “I want to change my DDL strategy in order [...]
November 23, 2022
MySQL Dual Passwords – How To Manage Them Programmatically
What is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter in Using [...]
November 22, 2022
Troubleshooting Percona Operators With troubleshoot.sh
Percona loves and embraces Kubernetes. Percona Operators have found their way into the hearts and minds of developers and operations [...]
November 18, 2022
Making Your MySQL Backup Process up to 17X Faster – Introducing Percona XtraBackup Smart Memory Estimation
Taking a MySQL backup using Percona XtraBackup (PXB) consists of basically two steps: 1) take the backup and 2) prepare [...]
November 17, 2022
How To Get Your Backup to Half of Its Size – Introducing ZSTD Support in Percona XtraBackup
Having a backup of your database is like insurance, you have to pay a monthly price to ensure you have [...]
November 14, 2022
Enable innodb_print_all_deadlocks Parameter To Get All Deadlock Information in mysqld Error Log
At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning. We [...]
November 10, 2022
Run MySQL in Kubernetes: Solutions, Pros and Cons
This blog post continues the series of comparisons of solutions to run databases on Kubernetes. Previous blog posts: Run MongoDB [...]
November 10, 2022
ProxySQL Support for MySQL caching_sha2_password
Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step [...]
November 9, 2022
MySQL: Using UNION, INTERSECT, & EXCEPT
MySQL 8.0.31 added INTERSECT and EXCEPT to augment the long-lived UNION operator. That is the good news. The bad news [...]
November 3, 2022
WHAT IF… The User Exists on the Replica and Not in the Primary? (Or Any Other Objects?)
Hey folks, This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of [...]
November 3, 2022
Raspberry on the Rocks: Build Percona Server for MySQL With MyRocks on Your Raspberry Pi
Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny [...]
November 2, 2022
Set Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for [...]
November 1, 2022
How to Generate Test Data for MySQL With Python
For testing purposes, especially if you’re working on a project that uses any database technology to store information, you may [...]