MySQL中怎么实现主主复制-创新互联
今天就跟大家聊聊有关MySQL中怎么实现主主复制 ,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。
创新互联是一家集网站建设,大关企业网站建设,大关品牌网站建设,网站定制,大关网站建设报价,网络营销,网络优化,大关网站推广为一体的创新建站企业,帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿,时刻以成就客户成长自我,坚持不断学习、思考、沉淀、净化自己,让我们为更多的企业打造出实用型网站。1 机器规划
192.168.6.119 keepalive+ipvsadm(Lvs) 192.168.6.121 keepalive+ipvsadm(Lvs) 192.168.6.66 VIP 192.168.6.114 真实机(测试httpd负载均衡),lvs客户端 192.168.6.115 真实机(测试httpd负载均衡),lvs客户端
114.115上都需要
[root@node1 ~]# more /usr/local/bin/lvs_real
#!/bin/bash
#description : start realserver
VIP=192.168.6.66
/etc/rc.d/init.d/functions
case "$1" in
start)
echo " start LVS of REALServer"
/sbin/ifconfig lo:0 $VIP broadcast $VIP netmask 255.255.255.255 up
echo "1" >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/lo/arp_announce
echo "1" >/proc/sys/net/ipv4/conf/all/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/all/arp_announce
;;
stop)
/sbin/ifconfig lo:0 down
echo "close LVS Directorserver"
echo "0" >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo "0" >/proc/sys/net/ipv4/conf/lo/arp_announce
echo "0" >/proc/sys/net/ipv4/conf/all/arp_ignore
echo "0" >/proc/sys/net/ipv4/conf/all/arp_announce
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac启动客户端脚本
[root@node1 ~]# sh /usr/local/bin/lvs_real start
4 服务端keepalive配置文件如下
119 121机器(主备修改关键点即可)
[root@localhost keepalived]# more keepalived.conf
#writed by sery , contact sery@163.com
#guration File for keepalived
#global define
global_defs {
router_id LVS_CNC_1
}
vrrp_sync_group VGM {
group {
VI_CACHE
}
}
################################################################
# vvrp_instance define #
################################################################
vrrp_instance VI_CACHE {
state MASTER
interface eth0
lvs_sync_daemon_inteface eth0
virtual_router_id 51
priority 180
advert_int 5
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.6.66
}
}
##############################################################
# virtual machine setting #
##############################################################
# setting port 80 forwardvirtual_server 192.168.6.66 80 {
delay_loop 6
lb_algo wlc
lb_kind DR
# persistence_timeout 20
protocol TCP
real_server 192.168.6.114 80 {
weight 100
TCP_CHECK {
connect_timeout 3
nb_get_retry 3
delay_before_retry 3
connect_port 80
}
}
real_server 192.168.6.115 80 {
weight 100
TCP_CHECK {
connect_timeout 3
nb_get_retry 3
delay_before_retry 3
connect_port 80
}
}
}启动keepalive
[root@localhost ~]# /etc/init.d/keepalived start
查看ipvsadm情况
[root@localhost keepalived]# ipvsadm -ln
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.6.66:80 wlc
-> 192.168.6.115:80 Route 100 0 0
-> 192.168.6.114:80 Route 100 0 0
看完上述内容,你们对MySQL中怎么实现主主复制 有进一步的了解吗?如果还想了解更多知识或者相关内容,请关注创新互联-成都网站建设公司行业资讯频道,感谢大家的支持。
分享名称:MySQL中怎么实现主主复制-创新互联
URL标题:http://pwwzsj.com/article/dcgjjs.html