LVS#MySQL+Keepalived四层负载均衡

MySQL&＃43;Keepalived实验指导

Keepalived&＃43;mysql 自动切换项目环境&＃xff1a;
VIP 192.168.246.100
mysql1 192.168.246.162 keepalived-master
mysql2 192.168.246.163 keepalived-salve一、mysql 主主同步 &＃xff08;不使用共享存储&＃xff0c;数据保存本地存储&＃xff09;
二、安装keepalived
三、keepalived 主备配置文件
四、mysql状态检测脚本/root/bin/keepalived_check_mysql.sh
五、测试及诊断实施步骤&＃xff1a;
一、mysql 主主同步
二、安装keepalived---两台机器都操作
[root&＃64;mysql-keepalived-master ~]# yum -y install keepalived
[root&＃64;mysql-keepalived-slave ~]# yum -y install keepalived
三、keepalived 主备配置文件
192.168.246.162 master配置
[root&＃64;mysql-keepalived-master ~]# cp /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak
[root&＃64;mysql-keepalived-master ~]# vim /etc/keepalived/keepalived.conf
! Configuration File for keepalivedglobal_defs {router_id master
}
vrrp_script check_run {script "/etc/keepalived/keepalived_chech_mysql.sh"interval 5
}vrrp_instance VI_1 {state MASTERinterface ens33virtual_router_id 89priority 100advert_int 1authentication {auth_type PASSauth_pass 1111}virtual_ipaddress {192.168.246.100/24}track_script {check_run}
}slave 192.168.246.163 配置
[root&＃64;mysql-keepalived-slave ~]# cp /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak
[root&＃64;mysql-keepalived-slave ~]# vim /etc/keepalived/keepalived.conf
! Configuration File for keepalivedglobal_defs {router_id backup
}
vrrp_script check_run {script "/etc/keepalived/keepalived_check_mysql.sh"interval 5
}vrrp_instance VI_1 {state BACKUPnopreemptinterface ens33virtual_router_id 89priority 50advert_int 1authentication {auth_type PASSauth_pass 1111}virtual_ipaddress {192.168.246.100/24}track_script {check_run}
}四、mysql状态检测脚本/root/keepalived_check_mysql.sh&＃xff08;两台MySQL同样的脚本&＃xff09;
版本一&＃xff1a;简单使用&＃xff1a;
[root&＃64;mysql-keepalived-master ~]# vim /etc/keepalived/keepalived_check_mysql.sh
#!/bin/bash
/usr/bin/mysql -uroot -p&＃39;QianFeng&＃64;2019!&＃39; -e "show status" &>/dev/null
if [ $? -ne 0 ] ;then
# service keepalived stopsystemctl stop keepalived
fi
[root&＃64;mysql-keepalived-master ~]# chmod &＃43;x /etc/keepalived/keepalived_check_mysql.sh
&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;
两边均启动keepalived
方式一:
[root&＃64;mysql-keepalived-master ~]# systemctl start keepalived
[root&＃64;mysql-keepalived-master ~]# systemctl enable keepalived
方式二:
# /etc/init.d/keepalived start
# /etc/init.d/keepalived start
# chkconfig --add keepalived
# chkconfig keepalived on
注意:在任意一台机器作为客户端。在测试的时候记得检查mysql用户的可不可以远程登录。


MySQL&＃43;Keepalived实验操作