Buy Percona ServicesBuy Now!

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

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

OSS4B – Presenting in Italy on MySQL and Percona XtraDB Cluster

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

I will be in Prato (Firenze), Italy Thursday and Friday (September 19th and 20th) to deliver 2 presentations at OSS4B: Installing and managing MySQL like a real devops: automation in production Introduction to Percona XtraDB Cluster If you want to learn about these projects or discuss anything related to MySQL and Percona, join the conference […]

Read More

MySQL Webinar: 5 proactive measures to help minimize MySQL downtime, July 17

 | July 10, 2013 |  Posted In: Events and Announcements, MySQL, Percona XtraDB Cluster, Technical Webinars

Failure is an unavoidable part of IT life, but it does not always have to imply MySQL service downtime. In the years I have been working at Percona, I have been involved in many customer emergency cases, and I have seen a good number of problems that could have been avoided or alleviated if relatively […]

Read More