EmergencyEMERGENCY? Get 24/7 Help Now!

Optimizing Percona XtraDB Cluster for write hotspots

 | June 3, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona XtraDB Cluster

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

Read More

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

 | April 28, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

Read More

Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

 | March 13, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona XtraDB Cluster, Technical Webinars

My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available here for playback along with the slides). I didn’t have time to answer many of the questions during the session and so in this post I answer all of them. Thanks to everyone who attended! Q: […]

Read More

Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

 | December 22, 2014 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster

Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in Xtrabackup. While Xtrabackup can hot-copy Innodb, everything else in MySQL must be locked (usually […]

Read More

HAProxy: Give me some logs on CentOS 6.5!

 | October 3, 2014 |  Posted In: Insight for DBAs, MySQL

HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesn’t work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue. If you look at the top of /etc/haproxy/haproxy.cfg, you will see something like: […]

Read More