mysql高可用集群

keepalivedlvs192.168.1.54

读/写

只读

vip192.168.1.101

vip192.168.1.100

抢占

只写

MySql客户端

主从备份binlog

Mysql slave192.168.1.41

应用DAO层

VRRP

Mysql slave192.168.1.40

mysql高可用1、drbd+heartbeat2、mysql+MMM3、mha+keepalive4、mycat

写

MyCatnode2192.168.1.78

主主备份binlog

MyCatnode1192.168.1.77

keepalivedlvs192.168.1.78

MyCat 集群高可用负载均衡

Mysql Slave 集群

主 master192.168.1.54

Mysql Master 集群

keepalivedlvs192.168.1.55

keepalivedlvs192.168.1.77

备 master192.168.1.55