MySQL5.7双机热备及keepalived高可用

最新推荐文章于 2024-08-05 13:51:14 发布

StrugglingBean

最新推荐文章于 2024-08-05 13:51:14 发布

阅读量1.1k

点赞数 1

分类专栏： MySQL 文章标签： mysql5.7 双机热备 keepalived 高可用

本文链接：https://blog.csdn.net/lihongdou/article/details/103382555

版权

本文介绍了在CentOS7环境下，如何配置MySQL5.7的双机热备，并结合keepalived实现高可用。详细步骤包括：通过wget或yum安装keepalived，配置并修改keepalived.conf文件，编写检测脚本，测试故障切换，以及解决相关问题如关闭SELINUX。

摘要由CSDN通过智能技术生成

前言

环境:centos7,MySQL5.7,keepalived2.0.19
事前准备:MySQl完成双主热备或主从复制
Master1 192.168.137.128 server_id=1 +keepalived
Master2 192.168.137.129 server_id=2 +keepalived
VIP 192.168.137.130

一.下载及安装keepalived

master1 和master2都需要安装及配置keepalived
安装前准备:

yum -y install gcc gcc-c++ autoconf automake make
yum -y install zlib zlib-devel openssl openssl-devel pcre pcre-devel

1.1 wget方式安装keepalived

wget方式安装编译keepalived,命令如下:

cd /usr/local/src/
wget https://www.keepalived.org/software/keepalived-2.0.19.tar.gz
tar -zxvf keepalived-2.0.19.tar.gz
cd keepalived-2.0.19
./configure --prefix=/usr/local/keepalived
make
make install
cd /usr/local/keepalived/sbin/
cp keepalived /usr/sbin/

设置配置文件夹并拷贝配置文件

mkdir /etc/keepalived
cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

1.2 yum方式安装keepalived

yum -y install keepalived

查看安装的版本信息

/usr/sbin/keepalived -version

1.3查看服务启动状态并设置开机启动

查看keepalived系统启动状态

systemctl list-unit-files|grep keepalived

二.配置文件修改

2.1 keepalived.conf 文件修改

vim /etc/keepalived/keepalived.conf

master1配置及说明


! Configuration File for keepalived

global_defs {
   
   router_id MASTER-1  #标识节点的字符串，通常为hostname  2台keepalived配置不同即可
}

## keepalived 会定时执行脚本并且对脚本的执行结果进行分析，动态调整vrrp_instance的优先级。这里的权重weight 是与下面的优先级priority有关，如果执行了一次检查脚本成功，则权重会-20，也就是由100 - 20 变成了80，Master 的优先级为80 就低于了Backup的优先级90，那么会进行自动的主备切换。
vrrp_script  check_mysql_alive {
   
    script "/etc/keepalived/check_mysql_alive.sh"   ##执行脚本位置
    interval 2               ##检测时间间隔    #调用脚本两次之间的间隔，默认为1秒     
    weight -5                ## 如果条件成立则权重减5（-5）
}
## 定义虚拟路由 VI_1为自定义标识
vrrp_instance V