Automated MySQL Failover With MHA: Getting Started And Moving Past Its Quirks

Colin Charles (Percona)
Operations, Mission City Ballroom B4
Average rating: ***..
(3.33, 3 ratings)

In the third edition (2012) of High Performance MySQL, MHA usage is described as: “anyone other than Yoshinori who is using it in production, and we haven’t used it ourselves.” Little known to the authors, we’ve spent quite a lot of time working on MHA and figuring out its kinks. It has also been deployed in many a production environment over the past year+. Today MHA is in use in places like DeNA (gaming), Facebook (social networking), SK Telecom (telecoms), and DAPA (defense).


  • how regular MySQL replication (asynchronous or semi-synchronous) can give you high availability with automated failover capabilities
  • how to get it running including everything you’ll have to customize
  • about virtual IP failover
  • integrating it with Pacemaker+Heartbeat+Corosync
  • getting it working on the Solaris (10 & greater) environments
  • where does (opensource) Tungsten Replicator fit into all of this

Learn from the experience in deploying and doing further engineering glue around the solution that is MHA. At the end of the talk, the attendee will be able to download MHA, and deploy it in an environment with a minimum of 3-nodes with ease.

Photo of Colin Charles

Colin Charles


Colin Charles works at Monty Program Ab, on MariaDB, and Open Ocean Investments on Web of Trust, and MoSync. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005. Before joining MySQL, he worked actively on the Fedora and projects. He’s spoken at many conferences –, The MySQL Conference & Expo,, to name a few.


Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Gloria Lombardo at (203) 381-9245 or

Media Partner Opportunities

For media partnerships, contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

Contact Us

View a complete list of Velocity contacts