Buy Percona ServicesBuy Now!

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

High-availability options for MySQL, October 2013 update

 | October 23, 2013 |  Posted In: High-availability, MySQL, Percona Server for MySQL, Percona XtraDB Cluster

The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a regular basis (hopefully, this is the first), an update on […]

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

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