133.CDH中MySQL高可用设置

2022-11-09 本文已影响0人大勇任卷舒

133.1 Keepalived安装

在MySQLA和MySQLB安装Keepalived服务

yum -y install keepalived

加入开机自启

systemctl enable keepalived

133.2 MySQL监测脚本

MySQL服务状态监测脚本，主要监控MariaDB服务状态是否正常
- 如果不正常则将该MySQL所在服务的Keepalived服务杀死
监控MySQL服务是否正常的方法有多种可以通过端口号
- 进程ID以及执行MySQL命令
这里使用mysladmin执行命令来监测MariaDB服务是否正常，脚本内容如下(check_mysql.sh)

#!/bin/bash

MYSQL_PING=`mysqladmin -uroot -p123456 ping`
MYSQL_OK="mysqld is alive"
if [[ "$MYSQL_PING" != "$MYSQL_OK" ]]
   then
      echo "mysql is not running"
      killall keepalived
    else
      echo "mysql is running"
fi

check_mysql.sh设置

[root@vm1 ~]# chmod +x /etc/keepalived/check_mysql.sh
[root@vm1 ~]# ll /etc/keepalived/check_mysql.sh 
-rwxr-xr-x 1 root root 233 Dec 29 07:34 /etc/keepalived/check_mysql.sh
[root@vm1 ~]#

133.3 MySQLA上Keepalived配置

/etc/keepalived/keepalived.conf配置文件编辑

[root@vm1 ~]# vim /etc/keepalived/keepalived.conf 
! Configuration File for keepalived
global_defs {
}
vrrp_script check_mysql {
  script "/etc/keepalived/check_mysql.sh"
  interval 2
}
vrrp_instance VI_1 {
  state BACKUP
  interface ens192
  virtual_router_id 51
  priority 100
  advert_int 1
  nopreempt
  authentication {
    auth_type PASS
    auth_pass 1111
  }
  virtual_ipaddress {
    192.168.0.188
  }
  track_script {
    check_mysql
  }
}

Keepalived服务启动

[root@vm1 ~]# systemctl start keepalived

检查网卡绑定
MySQLB服务器上ping
停止Keepalived服务查看是否解绑

133.4 MySQLB上Keepalived配置

/etc/keepalived/keepalived.conf配置编辑

[root@vm2 ~]# vim /etc/keepalived/keepalived.conf 
! Configuration File for keepalived
global_defs {
}
vrrp_script check_mysql {
  script "/etc/keepalived/check_mysql.sh"
  interval 2
}
vrrp_instance VI_1 {
  state BACKUP
  interface eth0
  virtual_router_id 51
  priority 90
  advert_int 1
  authentication {
    auth_type PASS
    auth_pass 1111
  }
  virtual_ipaddress {
    192.168.0.188
  }
  track_script {
    check_mysql
  }
}

Keepalived服务启动

[root@vm2 ~]# systemctl start keepalived

网卡检查
在MySQLA服务上ping

133.CDH中MySQL高可用设置

133.2 MySQL监测脚本

133.3 MySQLA上Keepalived配置

133.4 MySQLB上Keepalived配置

133.5 Keepalived验证服务IP漂移

133.6 MySQL高可用验证

猜你喜欢

热点阅读