1、Heartbeat+LVS+mm
2、Heartbeat+
Haproxy
+mm
3、Keepalived+LVS
+mm
4、Keepalived+Haproxy
+mm
5、heartbeat +DRBD
6、DNS轮询
8、MMM
9、Cobar
10、Percona XtraDB Cluster
11、MySQL Cluster
12、MySQL Auto-Failover GTID
要保证数据库绝对一致,可以开启
sync_binlog=1
innodb_flush_log_at_trx_commit=1