MySQL-MMM架构部署

master1(192.168.4.10) master/HARD_OFFLINE. Roles:

master2(192.168.4.11) master/ONLINE. Roles: writer(192.168.4.200)

slave1(192.168.4.12) slave/ONLINE. Roles: reader(192.168.4.201)

slave2(192.168.4.13) slave/ONLINE. Roles: reader(192.168.4.202)

[root@monitor ~]#

[root@client ~]# mysql -h192.168.4.200 -uroot -ppwd123 -e "show databases"    //访问虚拟IP测试

Warning: Using a password on the command line interface can be insecure.

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| tarena             |

| test               |

+--------------------+