Self-built MySQL mmm (master-master Replication Manager) high-availability architecture can not see the VIP address, after looking for a large number of articles on the Internet and their usual observation finally found a way to find the VIP address, Now share to everyone.
1. View the status of each node in the MMM monitoring server
[Email protected] bin]# Mmm_control Show
DB2 (192.168.56.105) master/online. Roles:writer (192.168.56.100)
Node1 (192.168.56.102) master/online. Roles:reader (192.168.56.200)
[Email protected] bin]#
2. There should be a 192.168.56.100 VIP address in the DB2 node
[[Email protected] bin]# IP A
1:lo: <LOOPBACK,UP,LOWER_UP> 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: <BROADCAST,MULTICAST,UP,LOWER_UP> MTU Qdisc pfifo_fast State up Qlen 1000
Link/ether 08:00:27:e0:ac:97 BRD FF:FF:FF:FF:FF:FF
inet 10.0.2.15/24 BRD 10.0.2.255 Scope Global eth0
Inet6 FE80::A00:27FF:FEE0:AC97/64 Scope link
Valid_lft Forever Preferred_lft Forever
3:eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> MTU Qdisc pfifo_fast State up Qlen 1000
Link/ether 08:00:27:a1:d1:2d BRD FF:FF:FF:FF:FF:FF
inet 192.168.56.105/24 BRD 192.168.56.255 Scope Global eth1
inet 192.168.56.100/32 Scope Global eth1 --This is the VIP write address
Inet6 FE80::A00:27FF:FEA1:D12D/64 Scope link
Valid_lft Forever Preferred_lft Forever
[Email protected] bin]#
3. There should be a 192.168.56.200 VIP address in the Node1 node
[[Email protected] ~]# IP A
1:lo: <LOOPBACK,UP,LOWER_UP> 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: <BROADCAST,MULTICAST,UP,LOWER_UP> MTU Qdisc pfifo_fast State up Qlen 1000
Link/ether 08:00:27:8E:FE:C6 BRD FF:FF:FF:FF:FF:FF
inet 192.168.56.102/24 BRD 192.168.56.255 Scope Global eth0
inet 192.168.56.200/32 Scope Global Eth0 -This is the VIP read address
Inet6 FE80::A00:27FF:FE8E:FEC6/64 Scope link
Valid_lft Forever Preferred_lft Forever
3:eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> MTU Qdisc pfifo_fast State up Qlen 1000
Link/ether 08:00:27:65:75:66 BRD FF:FF:FF:FF:FF:FF
inet 10.0.3.15/24 BRD 10.0.3.255 Scope Global eth1
Inet6 FE80::A00:27FF:FE65:7566/64 Scope link
Valid_lft Forever Preferred_lft Forever
[Email protected] ~]#
This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1562538
MySQL MMM architecture does not see the VIP address