EmergencyEMERGENCY? Get 24/7 Help Now!

Using keepalived for HA on top of Percona XtraDB Cluster

 | October 15, 2013 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster (PXC) itself manages quorum and node failure.  Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity.  Nodes in such a state will be easily detectable via SHOW GLOBAL STATUS variables. It’s common to use HAproxy with PXC for load balancing purposes, but […]

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

Multicast replication in Percona XtraDB Cluster (PXC) and Galera

 | June 5, 2013 |  Posted In: Percona Software, Percona XtraDB Cluster, XtraDB Cluster

Bandwidth multiplication and synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks.  1 Gbps seems like a lot, doesn’t it?  Actually, maybe not as much as you think.  While the theoretical limit of 1Gbps is actually 120MBps, I start to get nervous around 100MBps. By default […]

Read More