Centos7 keepalived安装并监控mysql实现自动切换

?

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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202

安装   下载（https://www.keepalived.org/download.html） wget https://www.keepalived.org/software/keepalived-2.1.5.tar.gz   tar -xvf keepalived-2.1.5.tar.gz -C /usr/local/src cd /usr/local/src/keepalived-2.1.5 ./configure --prefix=/ #安装一般不能一帆风顺，一般会缺少OpenSSL #1.在线安装：yum install -y openssl openssl-devel #2.离线安装：参考离线安装openssl.md   make && make install 修改配置 /etc/keepalived/keepalived.conf   #node117 ! Configuration File for keepalived   global_defs {     router_id lb01 }   vrrp_script chk_msql {     script "/etc/keepalived/check_mysql.sh"     interval 3     timeout 9     fall 2     rise 2     weight -20 }     vrrp_instance VI_1 {     state BACKUP     interface ens192     virtual_router_id 125     mcast_src_ip 192.168.6.117     priority 100     advert_int 1     authentication {         auth_type PASS         auth_pass 1111     }       track_script {         chk_msql     }       virtual_ipaddress {         192.168.6.125     } }   #node118 ! Configuration File for keepalived   global_defs {     router_id lb01 }   vrrp_script chk_msql {     script "/etc/keepalived/check_mysql.sh"     interval 3     timeout 9     fall 2     rise 2     weight -20 }     vrrp_instance VI_1 {     state BACKUP     interface ens192     virtual_router_id 125     mcast_src_ip 192.168.6.118     priority 100     advert_int 1     authentication {         auth_type PASS         auth_pass 1111     }       track_script {         chk_msql     }       virtual_ipaddress {         192.168.6.125     } }   #check_mysql.sh #!/bin/bash #MYSQL=mysql #MYSQL_HOST=localhost #MYSQL_USER=root MYSQL_PASSWORD=xiaoWEI0923!     #$MYSQL -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD -e "show status;" >/dev/null 2>&1 mysql -uroot -p$MYSQL_PASSWORD -e "show status;" >/dev/null 2>&1 #$mysqlclient --host=$host --port=$port --user=$user --password=$password  -e "show databases;" > /dev/null 2>&1 if [ $? == 0 ] then     echo " $host mysql login successfully "     exit 0 else     #echo " $host mysql login faild"     #/etc/init.d/keepalived stop     exit 2 fi   #check_nginx.sh #!/bin/bash A=`ps -C nginx --no-header | wc -l` if [ $A -eq 0 ];then     /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf     sleep 2     if [ `ps -C nginx --no-header | wc -l` -eq 0 ];then         #systemctl stop keepalived         echo "nginx exit"         exit 2     fi fi echo "nginx running..." exit 0   启动   systemctl enable keepalived.service systemctl start keepalived.service   # 可通过status查看相关错误 systemctl status keepalived.service   测试   1.ip addr查看虚拟ip绑定到了哪台机器（假如为A机器） 2.停止A机器keepalived,确认ip绑定到了另一台机器（B机器） 3.启动A机器keealived，停止B机器上keepavlived，ip绑定到A机器 4.同样方式测试mysql，停止A机器mysql，ip绑定到了B 4.恢复A机器mysql，停止B机器mysql，ip绑定到了A 另一种配置方法   #通过端口区分不同业务   ! Configuration File for keepalived global_defs {    router_id 001 }   vrrp_instance VI_1 {     state MASTER     interface ens192     virtual_router_id 125     priority 100     advert_int 1     authentication {         auth_type PASS         auth_pass 1111     }     virtual_ipaddress {         192.168.6.125     }           track_script {     nginx_check     } }   vrrp_script nginx_check {     script "/etc/keepalived/scripts/check_n.sh"     interval 1     weight -20 }   virtual_server 192.168.6.125 80 {     delay_loop 6     lb_algo rr     lb_kind DR     persistence_timeout 50     protocol TCP           real_server 192.168.6.117 80 {         weight 1         TCP_CHECK {             connect_port 80             connect_timeout 3             nb_get_retry 3             delay_before_retry 3         }     }     real_server 192.168.6.118 80 {         weight 1         TCP_CHECK {             connect_port 80             connect_timeout 3             nb_get_retry 3             delay_before_retry 3         }     } }