Percona XtraDB Cluster

Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync

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

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!)

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

Percona XtraDB Cluster: Setting up a simple cluster

Percona XtraDB Cluster (PXC) is different enough from async replication that it can be a bit of a puzzle how to do things the Galera way.  This post will attempt to illustrate the basics of setting up 2 node PXC cluster from scratch.
Requirements
Two servers (could be VMs) that can talk to each other.  I’m […]

Read more

OSS4B – Presenting in Italy on MySQL and 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 and don’t […]

Read more

Switching between versions using yum

One type of question we get very often (even in the form of filed bugs!) is how to switch from stock MySQL to Percona Server or switch from Percona Server 5.5 to Percona XtraDB Cluster using yum, but à la apt-get, i.e. having yum handle the replace.
In its simplest form, yum cannot replace a […]

Read more

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

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 […]

Read more

Percona XtraDB Cluster operations MySQL Webinar follow-up questions anwsered

Thanks to all who attended my PXC Operations webinar last week.  If you missed it you can watch the video here.
I wanted to take some time to answer the questions I didn’t get to during the broadcast.
Is there an easy way to leverage the xtrabackup SST and IST in an xtradb cluster to take […]

Read more

2 new features added to Percona XtraDB Cluster (PXC) since 5.5.31

With the last Percona XtraDB Cluster (PXC) release, two major features were added:
* a new command to bootstrap the cluster was added to the init script
* SST via Xtrabackup now supports Xtrabackup 2.1 features
In this post, I want to explain the benefits of these added features and how to use them.
If you follow the […]

Read more

Changing an async slave of a PXC cluster to a new Master

Async and PXC
A common question I get about Percona XtraDB Cluster is if you can mix it with asynchronous replication, and the answer is yes!  You can pick any node in your cluster and it can either be either a slave or a master just like any other regular MySQL standalone server (Just be […]

Read more