keepalivedmysql主主同步mysql高可用(ha)集群

《keepalivedmysql主主同步mysql高可用(ha)集群》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、1.这个环境最大的缺陷在于主机写入速度极慢，主键重复。2.mysql最好采用5.6以上集群版本，5.5以下单线程版本不大适合。博客中的mysql为5.5，实际测试挺差的，换成5.6之后十分完美，请各位运维在意一下。环境：CentOS6.4apache2.4.4PHP5.3.27MYSQL5.5.33机器vip192.168.1.100MASTER:192.168.1.101BACKUP:192.168.1.102高可用部分：yuminstallipvsadmyuminstallkeepalivediptables–F如果不允许禁用iptables请在/e

2、tc/sysconfig/iptables里面加上-A INPUT -d 224.0.0.18/16 -j ACCEPT  (vrrp的组播)-A INPUT  -p vrrp -j ACCEPT-A INPUT-mstate–stateNEW-mtcp-ptcp–dport3306-jACCEPserviceiptablesrestartsetenforce0MASTER:vi/etc/keepalived/keepalived.confglobal_defs{notification_email{        barbytang@hotmail.c

3、om  #邮件地址    }    router_idLVS1}vrrp_sync_groupGLVS{group{    mysqlha                      #组名 }}vrrp_instancemysqlha{    stateMASTER                                                (经过测试这里写MASTER或者BUCKUP对整个系统都没有影响)    interfaceeth0                                                 

4、 （注意看当前工作网卡，我就有过遇到bond0的状况）    lvs_sync_daemon_intefaceeth0    virtual_router_id51    priority180    advert_int1authentication{    auth_typePASS    auth_pass1111}virtual_ipaddress{    192.168.1.100}}virtual_server192.168.1.1003306{          #mysql端口    delay_loop6    lb_algorr   

5、                                                   #LVS    lb_kindDR                                                    #LVS采用DR模式    persistence_timeout20    protocolTCP    sorry_server192.168.1.1023306    real_server192.168.1.1013306{                    #buckup机器也这么写，原因是因为让正常工作

6、时只用101    weight3    TCP_CHECK{    connect_timeout3    nb_get_retry3    delay_before_retry3    connect_port3306}}}BACKUP：vim/etc/keepalived/keepalived.confglobal_defs{notification_email{        barbytang@hotmail.com    }    router_idLVS1}vrrp_sync_grouptest{group{    mysqlha}}vrr

7、p_instancemysqlha{    stateBACKUP    interfaceeth0    lvs_sync_daemon_intefaceeth0    virtual_router_id51    priority150    advert_int1authentication{    auth_typePASS    auth_pass1111}virtual_ipaddress{    192.168.1.100}}virtual_server192.168.1.1003306{    delay_loop6    lb_algo

8、rr    lb_kindDR    persistence_timeout20