Keepalived架构高可用Mysql(二)
4、配置keepalived 在线视频演示1)编辑配置文件
[*]#guration File for keepalived
[*]#global define
[*]global_defs {
[*] router_id Hadb_1
[*] }
[*]vrrp_sync_group VGM {
[*] group {
[*] VI_HA
[*] }
[*]}
[*]vrrp_script chk_mysql {
[*] script "killall -0 mysqld"
[*] interval 5
[*]}
[*]# vvrp_instance define #
[*]vrrp_instance VI_HA {
[*] state MASTER
[*] interface eth0
[*] virtual_router_id 51
[*] priority 100
[*] advert_int 5
[*] authentication {
[*] auth_type PASS
[*] auth_pass hamysql
[*] }
[*] virtual_ipaddress {
[*] 10.0.0.20
[*] }
[*] track_script {
[*] chk_mysql
[*] }
[*]}
2）启动Keepalived服务
分别启动两台服务器的Keepalived服务并观察其日志，效验高可用是否成功。
[*]# service keepalived start
[*]# tail /var/log/messages
[*]Jun 15 03:06:35 localhost Keepalived_vrrp: VRRP_Script(chk_mysql) succeeded
[*]Jun 15 03:06:36 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Transition to MASTER STATE
[*]Jun 15 03:06:41 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Entering MASTER STATE
[*]Jun 15 03:06:41 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) setting protocol VIPs.
[*]Jun 15 03:06:41 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Sending gratuitous ARPs on eth0 for 10.0.0.20
[*]Jun 15 03:06:41 localhost Keepalived_vrrp: VRRP_Group(VGM) Syncing instances to MASTER state
[*]Jun 15 03:06:41 localhost Keepalived_vrrp: Netlink reflector reports IP 10.0.0.18 added
[*]Jun 15 03:06:41 localhost Keepalived_healthcheckers: Netlink reflector reports IP 10.0.0.18 added
[*]Jun 15 03:06:46 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Sending gratuitous ARPs on eth0 for 10.0.0.20
[*]
5、测试
1）找一台装有mysql客户端的windows或linux机器登陆VIP测试。
[*]# mysql -uroot -p123456 -h10.0.0.20
[*]Welcome to the MySQL monitor.Commands end with ; or \g.
[*]Your MySQL connection id is 7
[*]Server version: 5.0.77-log Source distribution
[*]
[*]Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
2）keepalived故障转移测试
A：在windows或linux客户端一直去pingVIP，然后关闭10.0.0.18上的keepalived，正常情况下VIP就会切换到10.0.0.19上面去
B：开启10.0.0.18上的keepalived，看是否能自动切换
3)MySQL故障转移测试
A：在10.0.0.18上关闭MySQL服务，看VIP是否会切换到10.0.0.19上
[*]# service mysqld stop
[*]# tail /var/log/messages -f
[*]Jun 15 03:20:35 localhost Keepalived_vrrp: VRRP_Script(chk_mysql) failed
[*]Jun 15 03:20:36 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Entering FAULT STATE
[*]Jun 15 03:20:36 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) removing protocol VIPs.
[*]Jun 15 03:20:36 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Now in FAULT state
[*]Jun 15 03:20:36 localhost Keepalived_vrrp: VRRP_Group(VGM) Syncing instances to FAULT state
[*]Jun 15 03:20:36 localhost Keepalived_vrrp: Netlink reflector reports IP 10.0.0.18 removed
[*]Jun 15 03:20:36 localhost Keepalived_healthcheckers: Netlink reflector reports IP 10.0.0.18 removed
[*]
[*]
[*]# tail /var/log/messages -f
[*]Jun 15 03:20:47 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Transition to MASTER STATE
[*]Jun 15 03:20:47 localhost Keepalived_vrrp: VRRP_Group(VGM) Syncing instances to MASTER state
[*]Jun 15 03:20:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Entering MASTER STATE
[*]Jun 15 03:20:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) setting protocol VIPs.
[*]Jun 15 03:20:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Sending gratuitous ARPs on eth0 for 10.0.0.20
[*]Jun 15 03:20:52 localhost Keepalived_vrrp: Netlink reflector reports IP 10.0.0.19 added
[*]Jun 15 03:20:52 localhost Keepalived_healthcheckers: Netlink reflector reports IP 10.0.0.19 added
[*]Jun 15 03:20:57 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Sending gratuitous ARPs on eth0 for 10.0.0.20
B：开启10.0.0.18上的MySQL和keepalived
[*]# service mysqld start
[*]# tail /var/log/messages -f
[*]Jun 15 03:23:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Received higher prio advert
[*]Jun 15 03:23:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) Entering BACKUP STATE
[*]Jun 15 03:23:52 localhost Keepalived_vrrp: VRRP_Instance(VI_HA) removing protocol VIPs.
[*]Jun 15 03:23:52 localhost Keepalived_vrrp: VRRP_Group(VGM) Syncing instances to BACKUP state
[*]Jun 15 03:23:52 localhost Keepalived_vrrp: Netlink reflector reports IP 10.0.0.19 removed
[*]Jun 15 03:23:52 localhost Keepalived_healthcheckers: Netlink reflector reports IP 10.0.0.19 removed
C：下客户端连接的MySQL的VIP，在切换时我执行了一个MySQL查询命令
[*]mysql> show tables;
[*]No connection. Trying to reconnect...
[*]Connection id: 10
[*]Current database: test
[*]+----------------+
[*]| Tables_in_test |
[*]+----------------+
[*]| t2 |
[*]+----------------+
[*]1 row in set (0.00 sec)
页:
[1]