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 {
#notific
keepalived 实现mysql主从自动切换
最新推荐文章于 2024-09-01 14:09:22 发布
本文介绍了如何利用KEEPALIVED在192.168.137.3(主)和192.168.137.4(从)上实现MySQL主从切换。详细步骤包括:安装KEEPALIVED,设置开机启动,配置主从库的KEEPALIVED.conf文件,以及设置检测主库DOWN后执行的脚本,确保高可用性。
摘要由CSDN通过智能技术生成