Galera Cluster Best Practices

Replication and High Availability Strategies
23 April 1:20pm - 2:10pm @ Ballroom E

Galera Cluster for MySQL is a revolutionary step forward in MySQL high-availability. It provides synchronous, multi-maste, active-active clustering for InnoDB. No longer do you have to make tradeoffs between data integrity/durability and failover time, nor do you have to accept a performance hit because you need high-availability.

In this session we learn:

  • What is synchronous multi-master replication?
  • Configuring and starting a Galera cluster.
  • Automatic node provisioning and database state transfers.
  • Migrating from existing MySQL installations.

Different HA use cases are covered:

  • Synchronous master-slave replication
  • Synchronous multi-master
  • Split-brain and quorum
  • Load balancing vs failover clustering
  • Using Galera over WAN
  • Using Galera in the cloud well as some basic administrative tasks and tuning:

  • Monitoring
  • Backups
  • Version upgrades
  • Online schema upgrades
  • Cluster-wide consistent reads
  • Living with optimistic locking and deadlocks
  • Multi-threaded slave


Seppo Jaakola
CEO, Codership
Database replication specialist, with long track record of developing various replication and clustering solutions for MySQL and PostgreSQL databases. Currently holding CEO position at Codership, working for Galera open source project with the target of developing a universally applicable synchronous multi-master replication solution.