keepalived健康检查及双主MySQL健康检查脚本

一、http检查

HTTP_GET：工作在第5层，向指定的URL执行http请求，将得到的结果用md5加密并与指定的md5值比较看是否匹配，不匹配则从服务器池中移除；此外还可以指定http返回码来判断检测是否成功。HTTP_GET可以指定多个URL用于检测，这个一台服务器有多个虚拟主机的情况下比较好用。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
real_server 10.21.10.30 80 {

weight 1
HTTP_GET {
url {
path /keeptest/index.html
digest 3b9bc8d36a113971683321ad4fa02daf
}
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
}

}

1
2
#使用命令获取URL的hash
/usr/bin/genhash -s 10.21.10.30 -p 80 -u /keeptest/index.html

二、tcp端口检查

SSL_GET：跟上面的HTTP_GET相似，不同的只是用SSL连接

三、tcp端口检查

TCP_CHECK：工作在第4层，keepalived向后端服务器发起一个tcp连接请求，如果后端服务器没有响应或超时，那么这个后端将从服务器池中移除。

1
2
3
4
5
6
7
8
9
real_server 172.16.0.66 3306 {
weight 1
TCP_CHECK {
connect_timeout 3　
retry 3
delay_before_retry 3　　
connect_port 3306　　　　
}
}

四、脚本检查

MISC_CHECK：用脚本来检测，脚本如果带有参数，需将脚本和参数放入双引号内。脚本的返回值需为： 0） 检测成功 1） 检测失败，将从服务器池中移除 2－255）检测成功；如果有设置misc_dynamic，权重自动调整为 退出码-2，如退出码为200，权重自动调整为198=200-2。

五、邮件检查

SMTP_CHECK：用来检测邮件服务的smtp的。没用过不描述了自己搜吧

keepalive的双主MySQL健康检查

1
2
3
4
5
6
7
8
9
10
11
12
13
real_server 172.16.0.66 3306 {
weight 1
TCP_CHECK {
connect_timeout 3　
retry 3
delay_before_retry 3　　
connect_port 3306　　　　
}
MISC_CHECK {
misc_path “/etc/keepalived/mysql_check.sh 172.16.0.66”
misc_timeout 3
}
}
mysql_check.sh内容如下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
#!/bin/bash
if [ $# -ne 1 ];then
echo “Error: please use $0 172.16.0.66”
exit 1
else
CHECK_IP=$1Slav{e}_{s}tatus=$(mysql -u guoyabin -p’*********’ -h $CHECK_IP -e “show slave status\G” | grep -wE ‘Slave_SQL_Running|Slave_IO_Running’ | awk -F": " ‘{print KaTeX parse error: Expected 'EOF', got '}' at position 2: 2}̲' | wc -l) …(mysql -u guoyabin -p’*********’ -h $CHECK_IP -e “show slave status\G” | grep -w Seconds_Behind_Master | awk -F": " ‘{print $2}’)
if [ ${Slave_status} -eq 2 ] && [ KaTeX parse error: Expected 'EOF', got '#' at position 72: … else #̲异步调用钉钉发送通知。第一次脚…CHECK_IP Slave_status=$Slave_status Seconds_Behind_Master = KaTeX parse error: Undefined control sequence: \ at position 160: …*************" \̲ ̲ …{message}"’"
}
}’
} &

    exit 1
fi

fi
https://github.com/users/hbfs25505/projects/760
https://www.github.com/users/hbfs25505/projects/760
https://github.com/users/hbfs25505/projects/761
https://www.github.com/users/hbfs25505/projects/761
https://github.com/users/hbfs25505/projects/762
https://www.github.com/users/hbfs25505/projects/762
https://github.com/users/hbfs25505/projects/763
https://www.github.com/users/hbfs25505/projects/763
https://github.com/users/hbfs25505/projects/764
https://www.github.com/users/hbfs25505/projects/764
https://github.com/users/hbfs25505/projects/765
https://www.github.com/users/hbfs25505/projects/765
https://github.com/users/hbfs25505/projects/766
https://www.github.com/users/hbfs25505/projects/766
https://github.com/users/hbfs25505/projects/767
https://www.github.com/users/hbfs25505/projects/767
https://github.com/users/hbfs25505/projects/768
https://www.github.com/users/hbfs25505/projects/768
https://github.com/users/hbfs25505/projects/769
https://www.github.com/users/hbfs25505/projects/769
https://github.com/users/hbfs25505/projects/770
https://www.github.com/users/hbfs25505/projects/770
https://github.com/users/hbfs25505/projects/771
https://www.github.com/users/hbfs25505/projects/771
https://github.com/users/hbfs25505/projects/772
https://www.github.com/users/hbfs25505/projects/772
https://github.com/users/hbfs25505/projects/773
https://www.github.com/users/hbfs25505/projects/773
https://github.com/users/hbfs25505/projects/774
https://www.github.com/users/hbfs25505/projects/774
https://github.com/users/hbfs25505/projects/775
https://www.github.com/users/hbfs25505/projects/775
https://github.com/users/hbfs25505/projects/776
https://www.github.com/users/hbfs25505/projects/776
https://github.com/users/hbfs25505/projects/777
https://www.github.com/users/hbfs25505/projects/777
https://github.com/users/hbfs25505/projects/778
https://www.github.com/users/hbfs25505/projects/778
https://github.com/users/hbfs25505/projects/779
https://www.github.com/users/hbfs25505/projects/779
https://github.com/users/hbfs25505/projects/780
https://www.github.com/users/hbfs25505/projects/780
https://github.com/users/hbfs25505/projects/781
https://www.github.com/users/hbfs25505/projects/781
https://github.com/users/hbfs25505/projects/782
https://www.github.com/users/hbfs25505/projects/782
https://github.com/users/hbfs25505/projects/783
https://www.github.com/users/hbfs25505/projects/783
https://github.com/users/hbfs25505/projects/784
https://www.github.com/users/hbfs25505/projects/784
https://github.com/users/hbfs25505/projects/785
https://www.github.com/users/hbfs25505/projects/785
https://github.com/users/hbfs25505/projects/786
https://www.github.com/users/hbfs25505/projects/786
https://github.com/users/hbfs25505/projects/787
https://www.github.com/users/hbfs25505/projects/787
https://github.com/users/hbfs25505/projects/788
https://www.github.com/users/hbfs25505/projects/788
https://github.com/users/hbfs25505/projects/789
https://www.github.com/users/hbfs25505/projects/789
https://github.com/users/hbfs25505/projects/790
https://www.github.com/users/hbfs25505/projects/790
https://github.com/users/hbfs25505/projects/791
https://www.github.com/users/hbfs25505/projects/791
https://github.com/users/hbfs25505/projects/792
https://www.github.com/users/hbfs25505/projects/792
https://github.com/users/hbfs25505/projects/793
https://www.github.com/users/hbfs25505/projects/793
https://github.com/users/hbfs25505/projects/794
https://www.github.com/users/hbfs25505/projects/794
https://github.com/users/hbfs25505/projects/795
https://www.github.com/users/hbfs25505/projects/795
https://github.com/users/hbfs25505/projects/796
https://www.github.com/users/hbfs25505/projects/796
https://github.com/users/hbfs25505/projects/797
https://www.github.com/users/hbfs25505/projects/797
https://github.com/users/hbfs25505/projects/798
https://www.github.com/users/hbfs25505/projects/798
https://github.com/users/hbfs25505/projects/799
https://www.github.com/users/hbfs25505/projects/799
https://github.com/users/hbfs25505/projects/800
https://www.github.com/users/hbfs25505/projects/800
https://github.com/users/hbfs25505/projects/801
https://www.github.com/users/hbfs25505/projects/801
https://github.com/users/hbfs25505/projects/802
https://www.github.com/users/hbfs25505/projects/802
https://github.com/users/hbfs25505/projects/803
https://www.github.com/users/hbfs25505/projects/803
https://github.com/users/hbfs25505/projects/804
https://www.github.com/users/hbfs25505/projects/804
https://github.com/users/hbfs25505/projects/805
https://www.github.com/users/hbfs25505/projects/805
https://github.com/users/hbfs25505/projects/806
https://www.github.com/users/hbfs25505/projects/806
https://github.com/users/hbfs25505/projects/807
https://www.github.com/users/hbfs25505/projects/807
https://github.com/users/hbfs25505/projects/808
https://www.github.com/users/hbfs25505/projects/808
https://github.com/users/hbfs25505/projects/809
https://www.github.com/users/hbfs25505/projects/809
https://github.com/users/hbfs25505/projects/810
https://www.github.com/users/hbfs25505/projects/810
https://github.com/users/hbfs25505/projects/811
https://www.github.com/users/hbfs25505/projects/811
https://github.com/users/hbfs25505/projects/812
https://www.github.com/users/hbfs25505/projects/812
https://github.com/users/hbfs25505/projects/813
https://www.github.com/users/hbfs25505/projects/813
https://github.com/users/hbfs25505/projects/814
https://www.github.com/users/hbfs25505/projects/814
https://github.com/users/hbfs25505/projects/815
https://www.github.com/users/hbfs25505/projects/815
https://github.com/users/hbfs25505/projects/816
https://www.github.com/users/hbfs25505/projects/816
https://github.com/users/hbfs25505/projects/817
https://www.github.com/users/hbfs25505/projects/817
https://github.com/users/hbfs25505/projects/818
https://www.github.com/users/hbfs25505/projects/818
https://github.com/users/hbfs25505/projects/819
https://www.github.com/users/hbfs25505/projects/819
https://github.com/users/hbfs25505/projects/820
https://www.github.com/users/hbfs25505/projects/820
https://github.com/users/hbfs25505/projects/821
https://www.github.com/users/hbfs25505/projects/821
https://github.com/users/hbfs25505/projects/822
https://www.github.com/users/hbfs25505/projects/822
https://github.com/users/hbfs25505/projects/823
https://www.github.com/users/hbfs25505/projects/823
https://github.com/users/hbfs25505/projects/824
https://www.github.com/users/hbfs25505/projects/824
https://github.com/users/hbfs25505/projects/825
https://www.github.com/users/hbfs25505/projects/825
https://github.com/users/hbfs25505/projects/826
https://www.github.com/users/hbfs25505/projects/826
https://github.com/users/hbfs25505/projects/827
https://www.github.com/users/hbfs25505/projects/827
https://github.com/users/hbfs25505/projects/828
https://www.github.com/users/hbfs25505/projects/828
https://github.com/users/hbfs25505/projects/829
https://www.github.com/users/hbfs25505/projects/829
https://github.com/users/hbfs25505/projects/830
https://www.github.com/users/hbfs25505/projects/830
https://github.com/users/hbfs25505/projects/831
https://www.github.com/users/hbfs25505/projects/831
https://github.com/users/hbfs25505/projects/832
https://www.github.com/users/hbfs25505/projects/832
https://github.com/users/hbfs25505/projects/833
https://www.github.com/users/hbfs25505/projects/833
https://github.com/users/hbfs25505/projects/834
https://www.github.com/users/hbfs25505/projects/834
https://github.com/users/hbfs25505/projects/835
https://www.github.com/users/hbfs25505/projects/835
https://github.com/users/hbfs25505/projects/836
https://www.github.com/users/hbfs25505/projects/836
https://github.com/users/hbfs25505/projects/837
https://www.github.com/users/hbfs25505/projects/837
https://github.com/users/hbfs25505/projects/838
https://www.github.com/users/hbfs25505/projects/838
https://github.com/users/hbfs25505/projects/839
https://www.github.com/users/hbfs25505/projects/839
https://github.com/users/hbfs25505/projects/840
https://www.github.com/users/hbfs25505/projects/840
https://github.com/users/hbfs25505/projects/841
https://www.github.com/users/hbfs25505/projects/841
https://github.com/users/hbfs25505/projects/842
https://www.github.com/users/hbfs25505/projects/842
https://github.com/users/hbfs25505/projects/843
https://www.github.com/users/hbfs25505/projects/843
https://github.com/users/hbfs25505/projects/844
https://www.github.com/users/hbfs25505/projects/844
https://github.com/users/hbfs25505/projects/845
https://www.github.com/users/hbfs25505/projects/845
https://github.com/users/hbfs25505/projects/846
https://www.github.com/users/hbfs25505/projects/846
https://github.com/users/hbfs25505/projects/847
https://www.github.com/users/hbfs25505/projects/847
https://github.com/users/hbfs25505/projects/848
https://www.github.com/users/hbfs25505/projects/848
https://github.com/users/hbfs25505/projects/849
https://www.github.com/users/hbfs25505/projects/849
https://github.com/users/hbfs25505/projects/850
https://www.github.com/users/hbfs25505/projects/850
https://github.com/users/hbfs25505/projects/851
https://www.github.com/users/hbfs25505/projects/851
https://github.com/users/hbfs25505/projects/852
https://www.github.com/users/hbfs25505/projects/852
https://github.com/users/hbfs25505/projects/853
https://www.github.com/users/hbfs25505/projects/853
https://github.com/users/hbfs25505/projects/854
https://www.github.com/users/hbfs25505/projects/854
https://github.com/users/hbfs25505/projects/855
https://www.github.com/users/hbfs25505/projects/855
https://github.com/users/hbfs25505/projects/856
https://www.github.com/users/hbfs25505/projects/856
https://github.com/users/hbfs25505/projects/857
https://www.github.com/users/hbfs25505/projects/857
https://github.com/users/hbfs25505/projects/858
https://www.github.com/users/hbfs25505/projects/858
https://github.com/users/hbfs25505/projects/859
https://www.github.com/users/hbfs25505/projects/859
https://github.com/users/hbfs25505/projects/860
https://www.github.com/users/hbfs25505/projects/860
https://github.com/users/hbfs25505/projects/861
https://www.github.com/users/hbfs25505/projects/861
https://github.com/users/hbfs25505/projects/862
https://www.github.com/users/hbfs25505/projects/862
https://github.com/users/hbfs25505/projects/863
https://www.github.com/users/hbfs25505/projects/863
https://github.com/users/hbfs25505/projects/864
https://www.github.com/users/hbfs25505/projects/864
https://github.com/users/hbfs25505/projects/865
https://www.github.com/users/hbfs25505/projects/865
https://github.com/users/hbfs25505/projects/866
https://www.github.com/users/hbfs25505/projects/866
https://github.com/users/hbfs25505/projects/867
https://www.github.com/users/hbfs25505/projects/867
https://github.com/users/hbfs25505/projects/868
https://www.github.com/users/hbfs25505/projects/868
https://github.com/users/hbfs25505/projects/869
https://www.github.com/users/hbfs25505/projects/869
https://github.com/users/hbfs25505/projects/870
https://www.github.com/users/hbfs25505/projects/870
https://github.com/users/hbfs25505/projects/871
https://www.github.com/users/hbfs25505/projects/871
https://github.com/users/hbfs25505/projects/872
https://www.github.com/users/hbfs25505/projects/872
https://github.com/users/hbfs25505/projects/873
https://www.github.com/users/hbfs25505/projects/873
https://github.com/users/hbfs25505/projects/874
https://www.github.com/users/hbfs25505/projects/874
https://github.com/users/hbfs25505/projects/875
https://www.github.com/users/hbfs25505/projects/875
https://github.com/users/hbfs25505/projects/876
https://www.github.com/users/hbfs25505/projects/876
https://github.com/users/hbfs25505/projects/877
https://www.github.com/users/hbfs25505/projects/877
https://github.com/users/hbfs25505/projects/878
https://www.github.com/users/hbfs25505/projects/878
https://github.com/users/hbfs25505/projects/879
https://www.github.com/users/hbfs25505/projects/879
https://github.com/users/hbfs25505/projects/880
https://www.github.com/users/hbfs25505/projects/880
https://github.com/users/hbfs25505/projects/881
https://www.github.com/users/hbfs25505/projects/881
https://github.com/users/hbfs25505/projects/882
https://www.github.com/users/hbfs25505/projects/882
https://github.com/users/hbfs25505/projects/883
https://www.github.com/users/hbfs25505/projects/883
https://github.com/users/hbfs25505/projects/884
https://www.github.com/users/hbfs25505/projects/884
https://github.com/users/hbfs25505/projects/885
https://www.github.com/users/hbfs25505/projects/885
https://github.com/users/hbfs25505/projects/886
https://www.github.com/users/hbfs25505/projects/886
https://github.com/users/hbfs25505/projects/887
https://www.github.com/users/hbfs25505/projects/887
https://github.com/users/hbfs25505/projects/888
https://www.github.com/users/hbfs25505/projects/888
https://github.com/users/hbfs25505/projects/889
https://www.github.com/users/hbfs25505/projects/889
https://github.com/users/hbfs25505/projects/890
https://www.github.com/users/hbfs25505/projects/890
https://github.com/users/hbfs25505/projects/891
https://www.github.com/users/hbfs25505/projects/891
https://github.com/users/hbfs25505/projects/892
https://www.github.com/users/hbfs25505/projects/892
https://github.com/users/hbfs25505/projects/893
https://www.github.com/users/hbfs25505/projects/893
https://github.com/users/hbfs25505/projects/894
https://www.github.com/users/hbfs25505/projects/894
https://github.com/users/hbfs25505/projects/895
https://www.github.com/users/hbfs25505/projects/895
https://github.com/users/hbfs25505/projects/896
https://www.github.com/users/hbfs25505/projects/896
https://github.com/users/hbfs25505/projects/897
https://www.github.com/users/hbfs25505/projects/897
https://github.com/users/hbfs25505/projects/898
https://www.github.com/users/hbfs25505/projects/898
https://github.com/users/hbfs25505/projects/899
https://www.github.com/users/hbfs25505/projects/899
https://github.com/users/hbfs25505/projects/900
https://www.github.com/users/hbfs25505/projects/900
https://github.com/users/hbfs25505/projects/901
https://www.github.com/users/hbfs25505/projects/901
https://github.com/users/hbfs25505/projects/902
https://www.github.com/users/hbfs25505/projects/902
https://github.com/users/hbfs25505/projects/903
https://www.github.com/users/hbfs25505/projects/903
https://github.com/users/hbfs25505/projects/904
https://www.github.com/users/hbfs25505/projects/904
https://github.com/users/hbfs25505/projects/905
https://www.github.com/users/hbfs25505/projects/905
https://github.com/users/hbfs25505/projects/906
https://www.github.com/users/hbfs25505/projects/906
https://github.com/users/hbfs25505/projects/907
https://www.github.com/users/hbfs25505/projects/907
https://github.com/users/hbfs25505/projects/908
https://www.github.com/users/hbfs25505/projects/908
https://github.com/users/hbfs25505/projects/909
https://www.github.com/users/hbfs25505/projects/909
https://github.com/users/hbfs25505/projects/910
https://www.github.com/users/hbfs25505/projects/910
https://github.com/users/hbfs25505/projects/911
https://www.github.com/users/hbfs25505/projects/911
https://github.com/users/hbfs25505/projects/912
https://www.github.com/users/hbfs25505/projects/912
https://github.com/users/hbfs25505/projects/913
https://www.github.com/users/hbfs25505/projects/913
https://github.com/users/hbfs25505/projects/914
https://www.github.com/users/hbfs25505/projects/914
https://github.com/users/hbfs25505/projects/915
https://www.github.com/users/hbfs25505/projects/915
https://github.com/users/hbfs25505/projects/916
https://www.github.com/users/hbfs25505/projects/916
https://github.com/users/hbfs25505/projects/917
https://www.github.com/users/hbfs25505/projects/917
https://github.com/users/hbfs25505/projects/918
https://www.github.com/users/hbfs25505/projects/918
https://github.com/users/hbfs25505/projects/919
https://www.github.com/users/hbfs25505/projects/919
https://github.com/users/hbfs25505/projects/920
https://www.github.com/users/hbfs25505/projects/920
https://github.com/users/hbfs25505/projects/921
https://www.github.com/users/hbfs25505/projects/921
https://github.com/users/hbfs25505/projects/922
https://www.github.com/users/hbfs25505/projects/922
https://github.com/users/hbfs25505/projects/923
https://www.github.com/users/hbfs25505/projects/923
https://github.com/users/hbfs25505/projects/924
https://www.github.com/users/hbfs25505/projects/924
https://github.com/users/hbfs25505/projects/925
https://www.github.com/users/hbfs25505/projects/925
https://github.com/users/hbfs25505/projects/926
https://www.github.com/users/hbfs25505/projects/926
https://github.com/users/hbfs25505/projects/927
https://www.github.com/users/hbfs25505/projects/927