mysql 主从 keepalived_mysql主从+keepalived实现自动切换

3.1.1配置VIP

在Master-mysql和slave-mysql服务器上执行如下操作

cd   /etc/sysconfig/network-scripts/

cp   ifcfg-lo ifcfg-lo:0

vi   ifcfg-lo:0

DEVICE=lo:0

IPADDR=10.160.31.232

NETMASK=255.255.255.255

ONBOOT=yes

vi   /etc/rc.local

/sbin/route   add -host 10.160.31.232  dev lo:0

#将访问VIP的数据限制在本地避免通讯混乱

配置PROC参数

vi   /etc/sysctl.conf

net.ipv4.conf.all.arp_ignore   = 1

net.ipv4.conf.all.arp_announce   = 2

net.ipv4.conf.default.arp_ignore   = 1

net.ipv4.conf.default.arp_announce   = 2

net.ipv4.conf.lo.arp_ignore   = 1

net.ipv4.conf.lo.arp_announce   = 2

sysctl   -p

#调整LINUX内核ARP响应参数，阻止更新VIP的MAC地址，避免冲突

3.1.2 Master-mysql配置keepalived.conf：

vi /etc/keepalived/keepalived.conf

!   Configuration File for keepalived

global_defs   {

router_id mysql1

}

vrrp_script   chk_mysql {

script   "/etc/keepalived/scripts/mysql_check.sh"

interval 2

weight 2

}

vrrp_instance   mysql {

state MASTER

interface eth0

virtual_router_id 52

advert_int 1

priority 99

authentication {

auth_type PASS

auth_pass mysql

}

track_script   {

chk_mysql

}

virtual_ipaddress {

192.168.10.54

}

}

3.1.3 slave-mysql配置keepalived.conf

vi   /etc/keepalived/keepalived.conf

!   Configuration File for keepalived

global_defs   {

router_id mysql2

}

vrrp_script   chk_mysql {

script   "/etc/keepalived/scripts/mysql_check.sh"

interval 2

weight 2

}

vrrp_instance   mysql {

state BACKUP

interface eth0

virtual_router_id 52

advert_int 1

priority 50

authentication {

auth_type PASS

auth_pass mysql

}

track_script   {

chk_mysql

}

virtual_ipaddress {

192.168.10.54

}

}