MySQL Performance Blog
Recover Percona XtraDB Cluster in Kubernetes From Wrong MySQL Config
Data Base
November 23, 2020
Recover Percona XtraDB Cluster in Kubernetes From Wrong MySQL Config
Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster…
Wondering How to Run Percona XtraDB Cluster on Kubernetes? Try Our Operator!
Data Base
November 17, 2020
Wondering How to Run Percona XtraDB Cluster on Kubernetes? Try Our Operator!
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes…
Various Backup Compression Methods Using Mysqlpump
Data Base
November 6, 2020
Various Backup Compression Methods Using Mysqlpump
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a…
ChaosMesh to Create Chaos in Kubernetes
Data Base
November 5, 2020
ChaosMesh to Create Chaos in Kubernetes
In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to…
Understanding MySQL Memory Usage with Performance Schema
Data Base
November 2, 2020
Understanding MySQL Memory Usage with Performance Schema
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected…
CVE-2020-15180 – Affects Percona XtraDB Cluster
Data Base
October 30, 2020
CVE-2020-15180 – Affects Percona XtraDB Cluster
Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been…
Using MySQL 8 Persisted System Variables
Data Base
October 27, 2020
Using MySQL 8 Persisted System Variables
This blog discusses new features about the persisted system variables and how we can use it to make variable changes…
MySQL 8.0.22: Asynchronous Replication Automatic Connection (IO Thread) Failover
Data Base
October 26, 2020
MySQL 8.0.22: Asynchronous Replication Automatic Connection (IO Thread) Failover
MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now,…
Using Volume Snapshot/Clone in Kubernetes
Data Base
October 22, 2020
Using Volume Snapshot/Clone in Kubernetes
One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a…
How to Find Query Slowdowns Using Percona Monitoring and Management
Data Base
October 7, 2020
How to Find Query Slowdowns Using Percona Monitoring and Management
Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the…
How to Use CHECK Constraint in MySQL 8
Data Base
October 2, 2020
How to Use CHECK Constraint in MySQL 8
Hello everyone, in this little post we will review a new feature in MySQL 8. What is “CHECK Constraint”? This…
Rate Limit (Throttle) for MySQL with ProxySQL
Data Base
October 2, 2020
Rate Limit (Throttle) for MySQL with ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control…
MySQL 101: Tuning MySQL After Upgrading Memory
Data Base
September 30, 2020
MySQL 101: Tuning MySQL After Upgrading Memory
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to…
Diagnosing and Fixing “MySQL Server Has Gone Away” Messages
Data Base
September 25, 2020
Diagnosing and Fixing “MySQL Server Has Gone Away” Messages
We all like when error messages are descriptive and give a clear idea about what is happening; however, there are…