Automated MySQL failover with MHA: getting started & moving past its quirks

Replication and High Availability Strategies
2 April 2:20PM - 3:10PM @ Ballroom A

Experience level: 
Intermediate
Duration: 
50 minutes conference
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: * the potential pitfalls of automated failover and their workarounds * how regular MySQL replication (asynchronous or semi-synchronous) can give you high availability with automated failover capabilities * dealing with the semi-sync plugin, and understanding what you can get with enhanced semi-sync * about virtual IP failover & integration with Pacemaker+Corosync * if using the mysql-utilities tool, mysqlfailover, makes any sense * knowing when to choose between PRM and MHA * using MHA with GTID implementations in MySQL 5.6 & MariaDB 10 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 and think about further integration to build their own cloud architectures.


Speakers

Chief Evangelist, MariaDB
Biography: 
Colin Charles works on MariaDB at SkySQL. He has been the Chief Evangelist for MariaDB since 2009, work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He's well known on the conference track having spoken at many of them over the course of his career.