MHA: Introducing automated MySQL Master Failover solution

Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 25th, 2:30 PM
Newgate Suite


In this talk Yoshinori will introduce a newly announced MySQL master failover tool: MHA ( By using MHA, when master is down, one of the new slaves will automatically become new master, and other slaves will automatically replicate from the new master. Consistency issues (in case of the master crash, relay log states on slaves might be different each other) will automatically be fixed, and you can install MHA on existing MySQL replication environments without stopping MySQL. He'll explain the details of MHA, and how to use and how we use MHA on our environments.


Yoshinori Matsunobu

Yoshinori Matsunobu

Principal Infrastructure Architect, DeNA

Yoshinori Matsunobu is a database and infrastructure architect at DeNA, living in Tokyo. Yoshinori's primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.


]]> ]]>