Best Practices for MySQL High Availability

High Availability
21 September 9:00AM - 12:00PM @ Zürich 2

3 hours tutorial
The MariaDB/MySQL world is full of tradeoffs, and choosing a high availability (HA) solution is no exception. This session aims to look at all the alternatives in an unbiased way. Preference is of course only given to open source solutions. How do you choose between: asynchronous/semi-synchronous/synchronous replication, MHA (MySQL high availability tools), DRBD, Tungsten Replicator, or Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager? The cloud brings even more fun, especially if you are dealing with a hybrid cloud and must think about geographical redundancy. What about newer solutions like using Consul for MySQL HA? When you’ve decided on your solution, how do you provision and monitor these solutions? This and more will be covered in a walkthrough of MySQL HA options and when to apply them.


Chief Evangelist, Percona
Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and projects. He's well known within open source communities in APAC, and has spoken at many conferences.