EmergencyEMERGENCY? Get 24/7 Help Now!

Followup questions to ‘What’s new in Percona XtraDB Cluster 5.6’ webinar

 | February 7, 2014 |  Posted In: MySQL, Percona XtraDB Cluster, Technical Webinars

Thanks to all who attended my webinar yesterday.  The slides and recording are available on the webinar’s page.  I was a bit overwhelmed with the amount of questions that came in and I’ll try to answer them the best I can here. Q: Does Percona XtraDB Cluster support writing to multiple master? Yes, it does.  However, […]

Read More

Percona XtraDB Cluster/ Galera with Percona Monitoring Plugins

 | October 31, 2013 |  Posted In: MySQL, Percona Monitoring Plugins, Percona XtraDB Cluster, XtraDB Cluster

The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes.  Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes. Graphing An update to the PMP this summer (thanks to our Remote DBA team for supporting this!) added a Galera-specific host template that […]

Read More

Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync

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

Checking throughput with async MySQL replication Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition).  In MySQL async replication this is important to know because the single-threaded apply nature of async replication can be a write performance bottleneck.  In a production system, we can tell […]

Read More

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