安装keepalived

  1. yum -y install  keepalived

Keepalived主从配置文件修改

主配置文件

vim /etc/keepalived/keepalived.conf

  1. global_defs {
  2.    router_id mysql-master
  3. } 
  5. vrrp_script check_mysql {
  6.     script "/data/scripts/check_mysql.sh"
  7.     interval 3
  8. }
  10. vrrp_sync_group VG1 {
  11.     group {
  12.         VI_1
  13.     }
  14. }
  16. vrrp_instance VI_1 {
  17.     state BACKUP
  18.     interface ens33
  19.     virtual_router_id 51
  20.     priority 100  
  21.     advert_int 1
  22.     nopreempt
  23.     authentication {
  24.         auth_type PASS
  25.         auth_pass thisIsPassword
  26.     }
  28.     virtual_ipaddress {
  29.         192.168.0.70
  30.     }
  31.     track_script {
  32.         check_mysql
  33.     }
  34. }

从配置文件

vim /etc/keepalived/keepalived.conf

  1. global_defs {
  2.    router_id mysql-slave
  3. } 
  5. vrrp_script check_mysql {
  6.     script "/data/scripts/check_mysql.sh"
  7.     interval 3
  8. }
  10. vrrp_sync_group VG1 {
  11.     group {
  12.         VI_1
  13.     }
  14. }
  16. vrrp_instance VI_1 {
  17.     state BACKUP
  18.     interface ens33
  19.     virtual_router_id 51
  20.     priority 99
  21.     advert_int 1
  22.     nopreempt
  23.     authentication {
  24.         auth_type PASS
  25.         auth_pass thisIsPassword
  26.     }
  28.     virtual_ipaddress {
  29.         192.168.0.70
  30.     }
  31.     track_script {
  32.         check_mysql
  33.     }
  34. }

定义监控脚本

vim /data/scripts/check_mysql.sh

  1. #!/bin/bash
  2. mysqldState=$(ps -C mysqld --no-header | wc -l)
  3. if [ $mysqldState -eq 0 ];then
  4.   systemctl stop keepalived
  5. fi