MySQL System design for high availability with MHA and HAproxy 2014/11/26 Takeshi Yako

Servers app1 app2 mysql1 mysql2 mysql3 HAproxy App App HAproxy MySQL Master MySQL Slave MySQL Slave MHA Node MHA Node MHA Node MHA Manager

Read and Write Jeff Kubina Hard Disk

Read HAproxy App App HAproxy MySQL Master MySQL Slave MySQL Slave 127.0.0.1:3307 127.0.0.1:3307 mysql1:3306 mysql2:3306 mysql3:3306

Write HAproxy HAproxy MySQL Master MySQL Slave MySQL Slave 127.0.0.1:3308 127.0.0.1:3308 mysql1:3306 App App

Health Checks opensource.com Open Health: stethoscope

HAproxy HAproxy HAproxy MySQL Master MySQL Slave MySQL Slave HAproxy checks 
 MySQL read

MHA MySQL Master MySQL Slave MySQL Slave MHA Manager MHA checks MySQL Master

Read Failover Simon Cocks Reading a book at the beach

Read Failover step1 HAproxy HAproxy MySQL Master MySQL Slave MySQL Slave Health Check Fail

Read Failover step2 HAproxy App App HAproxy MySQL Master MySQL Slave HAproxy detaches 
 down server 127.0.0.1:3307 127.0.0.1:3307 mysql1:3306 mysql3:3306

Write Failover Erin Kohlenberg writing in the journal

Write Failover step1 MySQL Master MySQL Slave MySQL Slave MHA Manager Health Check Fail

Write Failover step2 MySQL Master MySQL Master MySQL Slave MHA Manager MHA changes MySQL Master

Write Failover step3 MySQL Master MySQL Master MySQL Slave MHA Manager MHA changes HAproxy config HAproxy HAproxy

Write Failover step4 HAproxy HAproxy MySQL Slave MySQL Slave 127.0.0.1:3308 127.0.0.1:3308 App App MySQL Master mysql2:3306 HAproxy detaches 
 down server

Thank you

Bibliography mysql-master-ha MHA for MySQL: Master High Availability Manager and tools for MySQL https://code.google.com/p/mysql-master-ha/ HAproxy The Reliable, High Performance TCP/HTTP Load Balancer http://www.haproxy.org/