mysql主备keepalive_keepalive 实现mysql主从切换

实验准备

两台虚拟机

cenos6 A 192.168.20.11  B192.168.20.115

vip ip 192.168.20.120

两台机子安装好mysql 并且已经做了主从复制

替换成阿里的epel

yum - y install keepalived

安装完成后进行配置

在这个目录下替换 成这个/etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs {

notification_email {

yuwb@zycsy.cn

}

notification_email_from yuwb@zycsy.cn

smtp_server 127.0.0.1

smtp_connect_timeout 30

router_id MySQL-ha

}

vrrp_instance VI_1 {

state master

interface eth0

virtual_router_id 51

priority 100

advert_int 1

nopreempt

authentication {

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

192.168.8.120 #vip地址

}

}

virtual_server 192.168.8.243 3306 {

delay_loop 6

lb_algo wrr

lb_kind DR

persistence_timeout 50

protocol TCP

real_server 192.168.8.11 3306 {#这是对A的3306 进行监控

weight 3

notify_down /var/lib/mysql/killkeepalived.sh  #当检测到服务停止后执行的脚本

TCP_CHECK {

connect_timeout 10

nb_get_retry 3

delay_before_retry 3

connect_port 3306

}

}

}

B从服务器只需要需改

real_server 192.168.8.115 3306 ”

vrrp部分改为：state BACKUP  ,priority 80