4. keepalived主备高可用

master1 — 192.168.111.5/172.16.0.131
master2 — 192.168.111.6/172.16.0.132
vip — 192.168.111.10/172.16.0.136

//master1和master2分别安装编辑器
yum install wget
yum install gcc
yum install gedit

1. lvs集群

以下三步参考：https://blog.csdn.net/buyueliuying/article/details/78517986

1.1 master1和master2分别安装lvs

yum -y install ipvsadm

1.2 把ipvsadm模块加载进系统

ipvsadm
lsmod|grep ip_vs

2. Keepalived故障转移的高可用

参考：https://www.cnblogs.com/kevingrace/p/6710136.html

2.1 安装keepalived并将其配置成系统服务，master1和master2两台机器上同样进行如下操作

yum install -y openssl-devel
cd /usr/local/src/
wget http://www.keepalived.org/software/keepalived-1.3.5.tar.gz
tar -zvxf keepalived-1.3.5.tar.gz
cd keepalived-1.3.5
yum -y install libnl libnl-devel
yum install -y libnfnetlink-devel
./configure --prefix=/usr/local/keepalived
make && make install
cp /usr/local/src/keepalived-1.3.5/keepalived/etc/init.d/keepalived /etc/rc.d/init.d/
cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
mkdir /etc/keepalived/
cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
cp /usr/local/keepalived/sbin/keepalived /usr/sbin/
echo “/etc/init.d/keepalived start” >> /etc/rc.local

//创建vip
参考：https://www.cnblogs.com/heitaoq/p/8973260.html
登录OpenStack DASHBOARD
管理员 - 系统 - 网络 - 点击admin_internal_net - 点击创建端口
名称设为vip，其他的选择默认，点击创建端口，会看到新创建的端口信息为：
名称 固定IP 连接设备 状态 管理状态
vip 192.168.111.10 分离 Down UP

//使用OpenStack RC文件，控制节点支持neutron 命令
项目 - 计算 - 访问 & 安全 - 访问API - 点击下载OpenStack RC v2，浏览器会下载一个名为admin-openrc.sh的文件，这是一个shell文件，改为如下内容
与其说他是shell脚本不如说它是一个环境变量文件，上边写着对openstack访问的api以及各种环境变量，使用方法如下
将下载的admin-openrc.sh文件复制到fuel_controller控制节点中
mv admin-openrc.sh admin
source admin
提示输入OpenStack DASHBOARD密码，输入admin回车
此时fuel_controller控制节点已经支持neutron命令
#!/usr/bin/env bash
export OS_AUTH_URL=http://172.16.0.3:5000/v2.0
export OS_TENANT_ID=16466dab9dcd417389ec5da094235e58
export OS_TENANT_NAME=“admin”
unset OS_PROJECT_ID
unset OS_PROJECT_NAME
unset OS_USER_DOMAIN_NAME
export OS_USERNAME=“admin”
echo “Please enter your OpenStack Password: "
read -sr OS_PASSWORD_INPUT
export OS_PASSWORD=$O{S}_{P}ASSWOR{D}_{I}NPUTexportO{S}_{R}EGIO{N}_{N}AME="RegionOne"if[-z"$OS_REGION_NAME” ]; then unset OS_REGION_NAME; fi

//用allwed_address_pairs参数关联所创建的ip 192.168.111.10
neutron port-list，查看所有的端口，可知master1和master2对应的端口
192.168.111.5 - a1773fb8-a1f2-4292-aa73-8a96bae38096
192.168.111.6 - ec937051-7aed-427e-af0b-11b0890425e5
192.168.111.7 - 85536012-ed13-4d01-993e-9f11e9877ee7
192.168.111.8 - d5dba18a-ebc3-400d-8270-ce6c3b6eeb53
192.168.111.9 - d9600b06-adbb-4d5e-a10c-f61ac1e08d58
/master1执行/
neutron port-update --allowed-address-pair ip_address=192.168.111.10 a1773fb8-a1f2-4292-aa73-8a96bae38096
/master2执行/
neutron port-update --allowed-address-pair ip_address=192.168.111.10 ec937051-7aed-427e-af0b-11b0890425e5
/查看一下端口master1状态/
neutron port-show a1773fb8-a1f2-4292-aa73-8a96bae38096
/给vip绑定浮点ip/
项目 - 计算 - 访问 & 安全 - 浮动IP - 分配IP给项目
将浮动IP：172.16.0.136和端口vip：192.168.111.10绑定

2.2 master1机器上的keepalived.conf配置

cp /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak
echo > /etc/keepalived/keepalived.conf
vi /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
notification_email {
1685550794@qq.com
}
notification_email_from 1685550794@qq.com
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id MASTER-HA
}

vrrp_instance VI_1 {
state MASTER ＃角色,若都为BACKUP，则表示当其中一台挂掉时，以另一台为MASTER，(即不会主动抢VIP)
interface eth0 ＃主备之间健康检查的网卡
virtual_router_id 51 ＃主备id相同
priority 100
advert_int 1
authentication {
auth_type PASS ＃主备之间通信认证
auth_pass 1111
}
virtual_ipaddress {
192.168.111.10
}
}

//修改配置文件
参考：https://blog.csdn.net/zsg88/article/details/76690847
vi /lib/systemd/system/keepalived.service
PIDFile=/usr/local/program/keepalived/var/run/keepalived.pid 改为：
PIDFile=/var/run/keepalived.pid
修改原因：/usr/local/program/keepalived/var/run/目录不存在
systemctl daemon-reload
当报错：Failed to execute operation: Connection timed out，可无视

//设置开机自启动
systemctl enable keepalived.service

//查看哪些服务开机自启动
systemctl list-unit-files

//启动keepalived服务
/etc/init.d/keepalived start

2.3 master2机器上的keepalived配置。master2机器上的keepalived.conf文件只修改priority为90、nopreempt不设置、real_server设置本地IP

cp /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak
echo > /etc/keepalived/keepalived.conf
vi /etc/keepalived/keepalived.conf
! Configuration File for keepalived

global_defs {
notification_email {
1685550794@qq.com
}
notification_email_from 1685550794@qq.com
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id MASTER-HA
}

vrrp_instance VI_1 {
state BACKUP ＃角色,若都为BACKUP，则表示当其中一台挂掉时，以另一台为MASTER，(即不会主动抢VIP)
interface eth0 ＃主备之间健康检查的网卡
virtual_router_id 51 ＃主备id相同
priority 90
advert_int 1
authentication {
auth_type PASS ＃主备之间通信认证
auth_pass 1111
}
virtual_ipaddress {
192.168.111.10
}
}

//修改配置文件
参考：https://blog.csdn.net/zsg88/article/details/76690847
vi /lib/systemd/system/keepalived.service
PIDFile=/usr/local/program/keepalived/var/run/keepalived.pid 改为：
PIDFile=/var/run/keepalived.pid
修改原因：/usr/local/program/keepalived/var/run/目录不存在
systemctl daemon-reload
当报错：Failed to execute operation: Connection timed out，可无视

//设置开机自启动
systemctl enable keepalived.service

//查看哪些服务开机自启动
systemctl list-unit-files

//启动Keepalived
/etc/init.d/keepalived start

//查看master1的IP
[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 435sec preferred_lft 435sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

//查看master2的IP
[root@master2 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:da:96:6c brd ff:ff:ff:ff:ff:ff
inet 192.168.111.6/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 511sec preferred_lft 511sec
inet6 fe80::f816:3eff:feda:966c/64 scope link
valid_lft forever preferred_lft forever

3. Keepalived故障转移的高可用验证

3.1 通过Mysql客户端通过VIP连接，看是否连接成功。

在Windows安装mysql（下面的连接权限要是在服务端提前授权的）
使用用户名：root 密码：Hust311! 网络IP：172.16.0.135 端口：3306，发现可成功连接数据库
mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test1 |
| test2 |
±-------------------+
6 rows in set (0.05 sec)
mysql> select * from test1.sync1;
±—±---------+
| id | name |
±—±---------+
| 1 | zhangsan |
| 2 | lisi |
| 3 | wangwu |
| 4 | zhaoliu |
±—±---------+
4 rows in set (0.02 sec)

2.2 在master上查看VIP切换情况

[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 435sec preferred_lft 435sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

//停止master1机器上的mysql服务，根据配置中的脚本，mysql服务停了，keepalived也会停，从而vip资源将会切换到master2机器上。（mysql服务没有起来的时候，keepalived服务也无法顺利启动！）
systemctl stop mysqld.service
ps -ef|grep mysql
ps -ef|grep keepalived
ip addr，打印：
[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 575sec preferred_lft 575sec
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

//如上结果，发现32位子网掩码的vip没有了，说明此时vip资源已不在master1机器上了，查看下master1的系统日志，如下，会发现vip资源已经切换走了
cat /var/log/messages
Dec 15 18:17:26 master1 systemd: Stopping MySQL Server…
Dec 15 18:17:26 master1 dhclient[708]: bound to 192.168.111.5 – renewal in 246 seconds.
Dec 15 18:17:28 master1 systemd: Stopping LVS and VRRP High Availability Monitor…
Dec 15 18:17:28 master1 Keepalived[14509]: Stopping
Dec 15 18:17:28 master1 Keepalived_vrrp[14511]: VRRP_Instance(VI_1) sent 0 priority
Dec 15 18:17:28 master1 Keepalived_vrrp[14511]: VRRP_Instance(VI_1) removing protocol VIPs.
Dec 15 18:17:28 master1 Keepalived_healthcheckers[14510]: Stopped
Dec 15 18:17:29 master1 Keepalived_vrrp[14511]: Stopped
Dec 15 18:17:29 master1 systemd: Stopped LVS and VRRP High Availability Monitor.
Dec 15 18:17:29 master1 Keepalived[14509]: Stopped Keepalived v1.3.5 (03/19,2017), git commit v1.3.5-6-g6fa32f2
Dec 15 18:17:39 master1 systemd: Stopped MySQL Server.

//再到master2机器上，发现vip资源的确切换过来了
[root@master2 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:da:96:6c brd ff:ff:ff:ff:ff:ff
inet 192.168.111.6/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 564sec preferred_lft 564sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:feda:966c/64 scope link
valid_lft forever preferred_lft forever

//查看master2的系统日志
cat /var/log/messages
Dec 15 18:18:27 master2 dhclient[708]: DHCPREQUEST on eth0 to 192.168.111.2 port 67 (xid=0x665ff6a5)
Dec 15 18:18:27 master2 dhclient[708]: DHCPACK from 192.168.111.2 (xid=0x665ff6a5)
Dec 15 18:18:31 master2 dhclient[708]: bound to 192.168.111.6 – renewal in 220 seconds.

2.3 再次启动master1的mysql和keepalived服务。（注意：如果restart重启mysql，那么还要启动下keepalived，因为mysql重启，根据脚本会造成keepalived关闭）

注意：一定要先启动mysql服务，然后再启动keepalived服务。如果先启动keepalived服务，按照上面的配置，mysql没有起来，就会自动关闭keepalived。
//启动数据库
systemctl start mysqld.service

//启动Keepalived
systemctl start keepalived.service

//启动成功之后会发现vip资源再次从master2机器上切换回来了，注意要稍等一下等待Keepalived切换
[root@master1 ~]# ip addr
[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 433sec preferred_lft 433sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

cat /var/log/messages
Dec 15 18:21:32 master1 dhclient[708]: DHCPREQUEST on eth0 to 192.168.111.2 port 67 (xid=0xb54de7e)
Dec 15 18:21:32 master1 dhclient[708]: DHCPACK from 192.168.111.2 (xid=0xb54de7e)
Dec 15 18:21:36 master1 dhclient[708]: bound to 192.168.111.5 – renewal in 237 seconds.
Dec 15 18:23:24 master1 systemd: Starting MySQL Server…
Dec 15 18:23:45 master1 systemd: Started MySQL Server.
Dec 15 18:23:49 master1 systemd: Starting LVS and VRRP High Availability Monitor…
Dec 15 18:23:49 master1 Keepalived[14869]: Starting Keepalived v1.3.5 (03/19,2017), git commit v1.3.5-6-g6fa32f2
Dec 15 18:23:49 master1 Keepalived[14869]: Unable to resolve default script username ‘keepalived_script’ - ignoring
Dec 15 18:23:49 master1 Keepalived[14869]: Opening file ‘/etc/keepalived/keepalived.conf’.
Dec 15 18:23:49 master1 Keepalived[14870]: Starting Healthcheck child process, pid=14871
Dec 15 18:23:49 master1 Keepalived[14870]: Starting VRRP child process, pid=14872
Dec 15 18:23:50 master1 systemd: Started LVS and VRRP High Availability Monitor.
Dec 15 18:23:50 master1 Keepalived_vrrp[14872]: Registering Kernel netlink reflector
Dec 15 18:23:50 master1 Keepalived_vrrp[14872]: Registering Kernel netlink command channel
Dec 15 18:23:50 master1 Keepalived_vrrp[14872]: Registering gratuitous ARP shared channel
Dec 15 18:23:50 master1 Keepalived_vrrp[14872]: Opening file ‘/etc/keepalived/keepalived.conf’.
Dec 15 18:23:50 master1 Keepalived_healthcheckers[14871]: Opening file ‘/etc/keepalived/keepalived.conf’.
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: VRRP_Instance(VI_1) removing protocol VIPs.
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: SECURITY VIOLATION - scripts are being executed but script_security not enabled.
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: Using LinkWatch kernel netlink reflector…
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: VRRP sockpool: [ifindex(2), proto(112), unicast(0), fd(10,11)]
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: VRRP_Script(chk_mysql_port) succeeded
Dec 15 18:23:57 master1 Keepalived_vrrp[14872]: VRRP_Instance(VI_1) Transition to MASTER STATE
Dec 15 18:23:58 master1 Keepalived_vrrp[14872]: VRRP_Instance(VI_1) Entering MASTER STATE
Dec 15 18:23:58 master1 Keepalived_vrrp[14872]: VRRP_Instance(VI_1) setting protocol VIPs.
Dec 15 18:23:58 master1 Keepalived_vrrp[14872]: Sending gratuitous ARP on eth0 for 192.168.111.10

//再看看master2机器，发现vip资源又被恢复后的master1抢过去了
[root@master2 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:da:96:6c brd ff:ff:ff:ff:ff:ff
inet 192.168.111.6/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 433sec preferred_lft 433sec
inet6 fe80::f816:3eff:feda:966c/64 scope link
valid_lft forever preferred_lft forever

cat /var/log/messages
Dec 15 18:23:56 master2 Keepalived_vrrp[14784]: VRRP_Instance(VI_1) Received advert with higher priority 100, ours 90
Dec 15 18:23:56 master2 Keepalived_vrrp[14784]: VRRP_Instance(VI_1) Entering BACKUP STATE
Dec 15 18:23:56 master2 Keepalived_vrrp[14784]: VRRP_Instance(VI_1) removing protocol VIPs.

2.4 同样，关闭master1机器的keepalived服务，vip资源会自动切换到master2机器上。当master1的keepalived服务恢复后，会将vip资源再次切回来。

[root@master1 ~]# systemctl stop keepalived.service
ip addr
[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 415sec preferred_lft 415sec
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

//查看master2，发现vip切过来了
[root@master2 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:da:96:6c brd ff:ff:ff:ff:ff:ff
inet 192.168.111.6/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 440sec preferred_lft 440sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:feda:966c/64 scope link
valid_lft forever preferred_lft forever

//再次恢复master1的keepalived服务，发现vip资源很快切回来了
[root@master1 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:a8:38:60 brd ff:ff:ff:ff:ff:ff
inet 192.168.111.5/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 600sec preferred_lft 600sec
inet 192.168.111.10/32 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::f816:3eff:fea8:3860/64 scope link
valid_lft forever preferred_lft forever

//查看master2，发现vip资源被切走了
[root@master2 keepalived-1.3.5]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:da:96:6c brd ff:ff:ff:ff:ff:ff
inet 192.168.111.6/24 brd 192.168.111.255 scope global dynamic eth0
valid_lft 599sec preferred_lft 599sec
inet6 fe80::f816:3eff:feda:966c/64 scope link
valid_lft forever preferred_lft forever

以上在vip资源切换过程中，对于客户端连接mysql（使用vip连接）来说几乎是没有任何影响的。