MHA: Introducing automated MySQL Master Failover solution
October 25th, 2:30 PM
In this talk Yoshinori will introduce a newly announced MySQL master failover tool: MHA (http://code.google.com/p/mysql-master-ha/). 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.
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.