systemctl start keepalived //啟動keepalived

systemctl enable keepalived //加入開機啟動keepalived

systemctl restart keepalived //重新啟動keepalived

systemctl status keepalived //查看keepalived狀態

! Configuration File for keepalived


#指定mysql服務檢測腳本

vrrp_script chk_mysql {

script "/etc/keepalived/scripts/chk_mysql.sh" #腳本路徑

interval 2 #腳本檢測頻率

weight -5 #腳本執行返回值 =0 ，優先級不變。!=0 時優先級 -5

fall 3 #如果連續三次檢測失敗，認為節點服務不可用

rise 2 #如果連續2次檢查成功則認為節點正常

}

#監測mysql 是否是master

vrrp_script chk_mysql_master {

script "/etc/keepalived/scripts/chk_mysql_master.sh"

interval 2

weight 10 #腳本執行返回值 =0 ，優先級加 10。!=0 時優先級不變。

}


vrrp_instance VI_1 {

state MASTER #指定實例初始狀態，實際的MASTER和BACKUP是選舉決定。

interface eth0 #指定實例綁定的網卡。

virtual_router_id 88 #設置VRID標記(0..255)

priority 100 #設置優先級，優先級高的會被競選為Master

advert_int 1 #檢查的時間間隔，默認1s

authentication { #節點間的認證，所有的必須一致

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

10.xx.xx.24/24

}


track_script { #指定前面腳本的名字

chk_mysql

chk_mysql_master

}

}

#!/bin/bash

counter=`netstat -tulnp |grep -w :::3306 |wc -l`

if [ $counter -eq 0 ]; then

systemctl stop keepalived

fi

#!/bin/bash

source ~/.bash_profile

source /etc/profile



PID1=`mysql -uroot -p1qsx@WAZ -S /home/my3306/run/mysql.sock -e "SELECT * FROM performance_schema.replication_group_members WHERE MEMBER_ID = (SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= group_replication_primary_member)" 2>/dev/null |awk NR==2{print}|awk -F" " {print $2}`

PID2=`mysql -uroot -p1qsx@WAZ  -S /home/my3306/run/mysql.sock -e "select @@global.server_uuid" 2>/dev/null |awk NR==2{print}`



RES=$(echo $PID1 | grep "${PID2}")

if [[ ${RES} != "" ]]; then exit 0; fi

exit 1

chmod +x chk_mysql*