Centos 6.0系统lvs+keepalived+mysql实现mysql数据库热备主主复制
发布时间:2016-09-18 23:21:39 所属栏目:Linux 来源:站长网
导读:今天这篇文章接着昨天的相关知识,一样是为了前天刚做的mysql热备; 大家知道实现mysql_Ha的方案有很多,常见的heartbeat、keepalived,这里说的就是keepalived
上master的基本一样,只是几个地方修改下而已 global_defs { notification_email { coffee_lanshan@sina.com } notification_email_from admin@example.com smtp_server 127.0.0.1 smtp_connect_timeout 30 router_id Mysql_ha } vrrp_instance VI_1 { state BACKUP interface eth0 virtual_router_id 51 priority 90 advert_int 1 nopreempt authentication { auth_type PASS auth_pass 123456 } virtual_ipaddress { 192.168.135.200 } } virtual_server 192.168.135.200 3306 { delay_loop 2 lb_algo wrr lb_kind DR persistence_timeout 10 protocol TCP real_server 192.168.135.135 3306 { weight 3 notify_down /usr/local/Mysql/bin/mysql.sh TCP_CHECK { connect_timeout 10 nb_get_retry 3 delay_before_retry 3 connect_port 3306 } } } (编辑:滁州站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |