Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Best Practices for MySQL High Availability

Best Practices for MySQL High Availability

 3 October 9:00 AM - 12:00 PM @ Matterhorn 2
Experience level: 
3 hours tutorial
Tools and Techniques
High Availability


The MySQL world is full of tradeoffs and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is of course only given to opensource solutions. How do you choose between: MySQL replication, MHA, DRBD, Tungsten, Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager? Is NDB Cluster right for your workload? Do you always run with GTIDs enabled? The cloud brings even more fun as geographical redundancy is rolled into this. There are now even "modern" tools to assist in automation like Orchestrator, Consul, MariaDB MaxScale & MySQL Router. This and more will be covered in a walkthrough of MySQL HA options and when you will apply them.


Colin Charles's picture

Colin Charles

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.

Share this talk