Skip to content

Instantly share code, notes, and snippets.

View kplawver's full-sized avatar

Kevin Lawver kplawver

View GitHub Profile

The High Availability Switch: from MySQL+MMM to MariaDB+Galera Cluster

INSERT PICTURE Kevin Lawver, President @ Rails Machine, is our guest author for this post.

Few things feel worst than rolling out a High Availability (HA) system, then regularly seeing that system collapse. For our team at Rails Machine, this failing HA system was MySQL Multi-Master Replication (MMM).

We've been searching for a MMM replacement for a while, and a few months ago, we made the switch to MariaDB + Galera Cluster for High Availability MySQL. Here's the full story: the reasons why MMM doesn't work, why Galera Cluster does work, and our production takeaways.

MySQL Multi-Master Replication (MMM) is fundamentally broken