Lvs+Keepalived+Mysql单点写入主主…

环境:
mysql主主同步
node1:192.168.1.53
node2:192.168.1.54
VIP:192.168.1.55

安装lvs      \\只需要ipvsadm模块
#yum install ipvsadm
安装keepalived
#tar -zxvf keepalived-1.2.7.tar.gz
#./configure --prefix=/usr/local/keepalived
#make && make install
# cp /usr/local/keepalived/sbin/keepalived /usr/sbin/
# cp /usr/local/keepalived/etc/sysconfig/keepalived/etc/sysconfig/
# cp /usr/local/keepalived/etc/rc.d/init.d/keepalived/etc/init.d/
#mkdir /etc/keepalived
#iptables -A INPUT -p vrrp -jACCEPT  //这里不开启vrrp协议的端口,会造成backup服务器检测不到master服务器的是否正常而自动启动backup的应用服务

node1:192.168.1.53
#vim /etc/keepalived/keepalived.conf
global_defs {

notification_email {
              admin@company.com
       }
       notification_email_from alarm@company.com
       smtp_server 127.0.0.1
       smtp_connect_timeout 30
       router_id LVS1
}

vrrp_sync_group test {
group {
       loadbalance
}
}

vrrp_instance loadbalance {
       state MASTER
       interface eth0
       lvs_sync_daemon_inteface eth0
       virtual_router_id 51
       priority 200
       advert_int 1

authentication {
       auth_type PASS
       auth_pass 1111
}

 
virtual_ipaddress {
       192.168.1.55 dev eth0 labeleth0:1     //55为VIP
}

}

virtual_server 192.168.1.55 3306 {
       delay_loop 6
       lb_algo rr
       lb_kind DR
       persistence_timeout 20
       protocol TCP
       sorry_server 192.168.1.54 3306
       real_server 192.168.1.53 3306 {
       weight 3
       TCP_CHECK {
       connect_timeout 3
       nb_get_retry 3
      delay_before_retry 3
       connect_port 3306
}

}

}

node2:192.168.1.54
vim /etc/keepalived/keepalived.conf
global_defs {
notification_email {
              admin@company.com
       }
       notification_email_from alarm@company.com