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).

Learn:

  • 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

Percona

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 OpenOffice.org projects. He’s spoken at many conferences – linux.conf.au, The MySQL Conference & Expo, foss.in, to name a few.

Sponsors

Sponsorship Opportunities

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

Media Partner Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

Contact Us

View a complete list of Velocity contacts