EmergencyEMERGENCY? Get 24/7 Help Now!

Monitoring MySQL flow control in Percona XtraDB Cluster 5.6

 | July 25, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona XtraDB Cluster

Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and wsrep_flow_control_paused_ns. Which one should you use? What is flow control? Flow control does not exist with regular MySQL replication, […]

Read More

Taking backups on Percona XtraDB Cluster (without stalls!)

 | October 8, 2013 |  Posted In: MySQL, Percona Software, Percona XtraDB Cluster

I occasionally see customers who are taking backups from their PXC clusters that complain that the cluster “stalls” during the backup.  As I wrote about in a previous blog post, often these stalls are really just Flow Control.  But why would a backup cause Flow control? Most backups I know of (even Percona XtraBackup) take […]

Read More

MySQL Webinar: Percona XtraDB Cluster Operations, June 26

 | June 18, 2013 |  Posted In: Events and Announcements, Percona XtraDB Cluster, XtraDB Cluster

Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need for more advanced talks […]

Read More