Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 21, 2023
Increase the Ability to Securely Replicate Your Data and Restrict Replication To Row-based Events in MySQL
In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data [...]
March 20, 2023
Comparisons of Proxies for MySQL
With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last [...]
March 17, 2023
Percona Monitoring and Management 2 Scaling and Capacity Planning
2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and [...]
March 16, 2023
Percona Labs Presents: Infrastructure Generator for Percona Database as a Service (DBaaS)
Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are [...]
March 13, 2023
How To Set Up MySQL 8 Replica From Existing MySQL 5.7 Server With Percona XtraBackup
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or [...]
March 8, 2023
Dealing With “Too Many Connections” Error in MySQL 8
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One [...]
March 6, 2023
How To Calculate a Good MySQL Redo Log Size in MySQL 8
MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know [...]
March 3, 2023
Using Slow Query Log to Find High Load Spots in MySQL
This post was originally published in October 2018 and was updated in March 2023. pt-query-digest is one of the most [...]
March 3, 2023
Purging Data When the Table Is Big and Has Children Tables
Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, [...]
March 1, 2023
Reduce Your Cloud Costs With Percona Kubernetes Operators
Public cloud spending is slowing down. Quarter-over-quarter growth is no longer hitting 30% gains for AWS, Google, and Microsoft. This [...]
March 1, 2023
MySQL 5.7 End of Life Six Months Away – Switch to Percona Server for MySQL Today!
Oracle’s MySQL 5.7 has had a good, long run, but the official End of Life is October of 2023. The [...]
February 20, 2023
Feedback Wanted: Making EXPLAIN Require Less Privileges for INSERT/UPDATE/DELETE Statements
Introduction/TLDR: We are considering changing EXPLAIN in Percona Server for MySQL to require less privileges for providing execution plans for [...]
February 16, 2023
ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest
ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s [...]
February 15, 2023
Deploying MySQL Group Replication With Terraform
Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL (Percona Server for MySQL: Automatic Cloud Deployment [...]
February 15, 2023
How Bloom Filters Work in MyRocks
Bloom filters are an essential component of an LSM-based database engine like MyRocks. This post will illustrate through a simple [...]
February 13, 2023
Differing MySQL Client Versions Causing Broken Replication and Collations in Aurora
Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a [...]
February 10, 2023
Percona XtraBackup and MySQL 5.7 Queries in Waiting for Table Flush State
Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses [...]
February 10, 2023
Percona XtraBackup Now Supports IAM Instance Profile
Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using [...]
January 26, 2023
Why You Need To Keep Track of Bugs
Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude [...]
January 25, 2023
Identify Active Databases and Users in MySQL
Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods [...]