MySQL HA
High availability environments provide substantial benefit for databases that must remain available.
MySQL Slave HA
- load balancer: HAProxy, ELB, SQL-aware proxy
MySQL Master HA
- MHA
- MMM
- Cluster
MySQL HA between Datacenter
- DNS
- Semi-sync(if you don’t want to loss any data)
A HA Design demo
(°0°)