Install Mysql MMM On Redhat 6.3 - 数据库编程

back 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000 link/ether 08:00:27:70:d2:ad brd ff:ff:ff:ff:ff:ff inet 192.168.56.171/24 brd 192.168.56.255 scope global eth0 inet 192.168.56.175/32 scope global eth0 inet 192.168.56.173/32 scope global eth0 inet6 fe80::a00:27ff:fe70:d2ad/64 scope link valid_lft forever preferred_lft forever 3: eth1: mtu 1500 qdisc pfifo_fast state UP qlen 1000 link/ether 08:00:27:57:10:81 brd ff:ff:ff:ff:ff:ff inet 192.168.253.111/24 brd 192.168.253.255 scope global eth1 inet6 fe80::a00:27ff:fe57:1081/64 scope link valid_lft forever preferred_lft forever [root@zbdba3 mysql-mmm]# ip a 1: lo: mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000 link/ether 08:00:27:39:b0:e7 brd ff:ff:ff:ff:ff:ff inet 192.168.56.172/24 brd 192.168.56.255 scope global eth0 inet 192.168.56.174/32 scope global eth0 inet6 fe80::a00:27ff:fe39:b0e7/64 scope link valid_lft forever preferred_lft forever 3: eth1: mtu 1500 qdisc pfifo_fast state UP qlen 1000 link/ether 08:00:27:08:3b:71 brd ff:ff:ff:ff:ff:ff inet 192.168.253.112/24 brd 192.168.253.255 scope global eth1 inet6 fe80::a00:27ff:fe08:3b71/64 scope link valid_lft forever preferred_lft forever
发现zbdba2成为读节点，zbdba3为写节点

8、测试
关闭zbdba2 的mysql
[root@zbdba2 default]# service mysql stop
Shutting down MySQL... SUCCESS!

再次查看monitor状态：

[root@zbdba1 mysql-mmm]# mmm_control show
  db1(192.168.56.171) master/HARD_OFFLINE. Roles:
  db2(192.168.56.172) master/ONLINE. Roles: reader(192.168.56.174), reader(192.168.56.175), writer(192.168.56.173)


[root@zbdba3 mysql-mmm]# ip a
1: lo:  mtu 16436 qdisc noqueue state UNKNOWN
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: eth0:  mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:39:b0:e7 brd ff:ff:ff:ff:ff:ff
    inet 192.168.56.172/24 brd 192.168.56.255 scope global eth0
    inet 192.168.56.174/32 scope global eth0
    inet 192.168.56.175/32 scope global eth0
    inet 192.168.56.173/32 scope global eth0
    inet6 fe80::a00:27ff:fe39:b0e7/64 scope link
       valid_lft forever preferred_lft forever
3: eth1:  mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:08:3b:71 brd ff:ff:ff:ff:ff:ff
    inet 192.168.253.112/24 brd 192.168.253.255 scope global eth1
    inet6 fe80::a00:27ff:fe08:3b71/64 scope link
       valid_lft forever preferred_lft forever

发现所有VIP都漂移到zbdba3上了。

Install Mysql MMM On Redhat 6.3(二)