最近用两台主机搭建了一个mysql主从复制的环境,两台机器分别安装了keepalived,用一个虚IP实现mysql服务器的主备自动切换功能;这里主要记录下keepalived的配置,mysql复制的步骤就不写了!
虚IP是192.168.21.36,两个机器的配置中,都要配置为MASTER,否则自动切换不成功!
	主机keepalived.conf
global_defs { 
router_id MYSQL_NODE_1 
} 
vrrp_script chk_mysql_port { 
script "
interval 3 
weight -2 
fail 1 
rise 1 
} 
vrrp_instance V_MYSQLSERVER { 
state MASTER 
interface eth2 
lvs_sync_daemon_inteface eth2 
virtual_router_id 152 
priority 100 
advert_int 2 
authentication { 
auth_type PASS 
auth_pass 4321 
} 
track_script { 
chk_mysql_port 
} 
virtual_ipaddress { 
192.168.21.36 
} 
}
从机keepalived.conf
global_defs { 
router_id MYSQL_NODE_1 
} 
vrrp_script chk_mysql_port { 
script "
interval 3 
weight -2 
fail 1 
rise 1 
} 
vrrp_instance V_MYSQLSERVER { 
state MASTER 
interface eth2 
lvs_sync_daemon_inteface eth2 
virtual_router_id 152 
priority 99 
advert_int 2 
authentication { 
auth_type PASS 
auth_pass 4321 
} 
track_script { 
chk_mysql_port 
} 
virtual_ipaddress { 
192.168.21.36 
} 
}