mysql 主备自动切换_mysql主备切换[高可用]

到这一步的时候, 是主备部署已经处理好, 请关注:mysql主备部署[高可用]

这次使用的是keepalived-1.2.22.tar.gz版, 官网地址:keeplived官网

笼统知识请自行查询百度下面开始步骤

第一步:安装keepalived-1.2.22

解压

tar -zxvf keepalived-1.2.22.tar.gz

编译

cd keepalived-1.2.22

./configure --prefix=/usr/local/keepalived/(新建文件夹喔)

安装

make && make install

服务脚本

cp /usr/local/etc/rc.d/init.d/keepalived /etc/init.d/keepalived

配置文件

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

服务

cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/keepalived

加入服务

chkconfig --add keepalived

chkconfig keepalived on

service keepalived start #启动服务

service keepalived stop #停止服务

service keepalived restart #重启服务

上面的额操作主备机器都需要安装

第二步:配置文件

master:keepalived.conf

! Configuration File for keepalived

global_defs {

router_id HA_MySQL

}

vrrp_instance VI_1 {

state BACKUP

interface eth0

virtual_router_id 51

priority 100

advert_int 1

nopreempt

authentication {

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

192.168.88.88

}

}

virtual_server 192.168.88.88 3306 {

delay_loop 2

lb_algo wrr

lb_kind DR

persistence_timeout 60

protocol TCP

real_server 192.168.75.61 3306 {

weight 3

notify_down /etc/keepalived/down.sh

TCP_CHECK {

connect_timeout 10

nb_get_retry 3

delay_before_retry 3

connect_port 3306

}

}

}

slave:keepalived.conf

! Configuration File for keepalived

global_defs {

router_id HA_MySQL

}

vrrp_instance VI_1 {

state BACKUP

interface eth0

virtual_router_id 51

priority 90