keepalived 实现mysql主从自动切换

最新推荐文章于 2023-08-11 10:30:25 发布

scan724

最新推荐文章于 2023-08-11 10:30:25 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： keepalived

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/46547003

keepalived 专栏收录该内容

10 篇文章 ¥39.90 ¥99.00

订阅专栏

本文介绍了如何利用KEEPALIVED在192.168.137.3（主）和192.168.137.4（从）上实现MySQL主从切换。详细步骤包括：安装KEEPALIVED，设置开机启动，配置主从库的KEEPALIVED.conf文件，以及设置检测主库DOWN后执行的脚本，确保高可用性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

3.1安装KEEPALIVED软件：
wget http://www.keepalived.org/software/keepalived-1.2.7.tar.gz
tar zxvf keepalived-1.2.7.tar.gz 
cd keepalived-1.2.7
./configure --prefix=/usr/local/keepalived --with-kernel-dir=/usr/src/kernels/2.6.18-194.el5-x86_64

  3.2设置KEEPALIVED开机自启动：
cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/ 
 cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/ 
 cp /usr/local/keepalived/sbin/keepalived /usr/sbin/ 
 chkconfig keepalived on

  3.3编写主从库上的配置文件：
mkdir /etc/keepalived
vi /etc/keepalived/keepalived.conf
数据库角色	配置文件内容



192.168.137.212 VIP
 
192.168.137.3  master

192.168.137.4  slave

主	! Configuration File for keepalived
global_defs {
   router_id MySQL-ha
}

#global_defs {
#notification_email {
#xxxx@126.com
}

了解本专栏