1. centos7 keepalived+mysql互为主从高可用集群
链接>> https://blog.csdn.net/m0_46674735/article/details/112425808
2. keepalived使用脚本监控mysql状态
2.1 在server1上编写监控mysql状态的脚本,脚本内容为:
#!/bin/bash
port_num=$(ss -nltp|grep -wc 3306)
if [ $port_num -eq 0 ];then
pkill keepalived
fi
写完之后给脚本增加执行权限
chmod +x check_mysql.sh
2.2 修改server1的keepalived配置文件,调用脚本
vim /etc/keepalived/keepalived.conf
1)将14行的内容注释掉,注释符为!
2)定义脚本并调用
3)保存退出后重启keepalived服务
systemctl restart keepalived
2.3 在server2上进行相同的操作
3. 验证
3.1 查看server1的VIP地址
命令:ip add
3.2 关掉server1上的mysql服务
systemctl stop mariadb
3.3 VIP成功漂移到server2上
3.4 恢复server1上的mysql服务和keepalived服务
systemctl start mariadb
systemctl start keepalived