首页 / 负载均衡 / MySQLLVS负载均衡
MySQLLVS负载均衡
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQLLVS负载均衡,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含5439字,纯文字阅读大概需要8分钟。
内容图文
![MySQLLVS负载均衡](/upload/InfoBanner/zyjiaocheng/542/76a174fb9e21408c909c72c413bc21a4.jpg)
环境: 192.168.1.8(DR,REAL SERVER) 192.168.1.88(REAL SERVER) 192.168.1.188(REAL SERVER) 1.DR安装配置: (1)安装IPVSADM yum install ipvsadm (2)绑定VIP: ifconfig eth0:0 192.168.1.200 broadcast 192.168.1.200 netmask 255.255.255.255 u
环境: 192.168.1.8(DR,REAL SERVER) 192.168.1.88(REAL SERVER) 192.168.1.188(REAL SERVER)1.DR安装配置:
(1)安装IPVSADM
yum install ipvsadm
(2)绑定VIP:
ifconfig eth0:0 192.168.1.200 broadcast 192.168.1.200 netmask 255.255.255.255 up
(3)增加路由到ETH0:0
route add -host 192.168.1.200 dev eth0:0
(4)配置转发:
echo "1" >/proc/sys/net/ipv4/ip_forward
(5)增加REAL SERVER
ipvsadm -C
ipvsadm -A -t 192.168.1.200:3306 -s rr -p 600
ipvsadm -a -t 192.168.1.200:3306 -r 192.168.1.8:3306 -g
ipvsadm -a -t 192.168.1.200:3306 -r 192.168.1.88:3306 -g
ipvsadm -a -t 192.168.1.200:3306 -r 192.168.1.188:3306 -g
(6)启动:
ipvsadm
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.1.200:mysql rr persistent 600
-> 192.168.1.188:mysql Route 1 0 0
-> 192.168.1.88:mysql Route 1 0 0
-> 192.168.1.8:mysql Local 1 0 0
以上步骤可写成脚本:
cat /etc/init.d/lvsDR
#dscription: Start LVS of Director server
VIP=192.168.1.200
RIP1=192.168.1.8
RIP2=192.168.1.88
RIP3=192.168.1.188
/etc/rc.d/init.d/functions
case "$1" in
start)
echo " start LVS of Director Server"
# set the Virtual IP Address and sysctl parameter
/sbin/ifconfig eth0:0 $VIP broadcast $VIP netmask 255.255.255.255 up
echo "1" >/proc/sys/net/ipv4/ip_forward
#Clear IPVS table
/sbin/ipvsadm -C
#set LVS
/sbin/ipvsadm -A -t $VIP:3306 -s rr -p 600
/sbin/ipvsadm -a -t $VIP:3306 -r $RIP1:3306 -g
/sbin/ipvsadm -a -t $VIP:3306 -r $RIP2:3306 -g
/sbin/ipvsadm -a -t $VIP:3306 -r $RIP3:3306 -g
#Run LVS
/sbin/ipvsadm
;;
stop)
echo "close LVS Directorserver"
echo "0" >/proc/sys/net/ipv4/ip_forward
/sbin/ipvsadm -C
/sbin/ifconfig eth0:0 down
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac
安装ldirectord
需要安装四个软件包:
heartbeat-1.2.4-1.i386.rpm heartbeat-pils-1.2.4-1.i386.rpm
heartbeat-ldirectord-1.2.4-1.i386.rpm heartbeat-stonith-1.2.4-1.i386.rpm
rpm -ivh *.rpm --nodeps --force
修改配置文件:
cat /etc/ha.d/ldirectord.cf
#Global Directives
checktimeout=20
checkinterval=10
fallback=127.0.0.1:3306
autoreload=yes
logfile="/var/log/ldirectord.log"
quiescent=no
# Sample for an mysql virtual service
virtual=192.168.1.200:3306
real=192.168.1.8:3306 gate
real=192.168.1.88:3306 gate
real=192.168.1.188:3306 gate
fallback=127.0.0.1:3306 gate
service=mysql
checktype=negotiate
login="root"
passwd="123456"
request="show status"
scheduler=rr
2.real server配置: 在三个节点均这样操作:
增加/etc/init.d/lvsrs 脚本:
cat /etc/init.d/lvsrs
#!/bin/bash
#description : Start Real Server
VIP=192.168.1.200
/etc/rc.d/init.d/functions
case "$1" in
start)
echo " Start LVS of Real Server"
/sbin/ifconfig eth0:0 $VIP broadcast $VIP netmask 255.255.255.255 up
echo "1" >/proc/sys/net/ipv4/conf/eth0/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/eth0/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 eth0:0 down
echo "close LVS Director server"
echo "0" >/proc/sys/net/ipv4/conf/eth0:0/arp_ignore
echo "0" >/proc/sys/net/ipv4/conf/eth0:0/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
3.启动LVS集群服务:
(1)启动REAL SERVER: 在三个节点上都操作
/etc/init.d/lvsrs start
(2)启动ldirectord 在DR上
/etc/init.d/ldirectord start
查看输出日志:
[Sat May 19 01:25:33 2012|ldirectord] Removed real server: 192.168.1.8:3306 ( x 192.168.1.200:3306
[Sat May 19 01:25:33 2012|ldirectord] Removed real server: 192.168.1.88:3306 ( x 192.168.1.200:3306
[Sat May 19 01:25:33 2012|ldirectord] Removed real server: 192.168.1.188:3306 ( x 192.168.1.200:3306
[Sat May 19 01:25:33 2012|ldirectord] Removed virtual server: 192.168.1.200:3306
[Sat May 19 01:25:33 2012|ldirectord] Linux Director Daemon terminated on signal: TERM
[Sat May 19 01:25:34 2012|ldirectord] Starting Linux Director v1.77.2.36 as daemon
[Sat May 19 01:25:34 2012|ldirectord] Added virtual server: 192.168.1.200:3306
[Sat May 19 01:25:34 2012|ldirectord] Added fallback server: 127.0.0.1:3306 ( x 192.168.1.200:3306) (Weight set to 1)
[Sat May 19 01:25:34 2012|ldirectord] Added real server: 192.168.1.8:3306 ( x 192.168.1.200:3306) (Weight set to 1)
[Sat May 19 01:25:34 2012|ldirectord] Deleted fallback server: 127.0.0.1:3306 ( x 192.168.1.200:3306)
[Sat May 19 01:25:34 2012|ldirectord] Added real server: 192.168.1.88:3306 ( x 192.168.1.200:3306) (Weight set to 1)
[Sat May 19 01:25:34 2012|ldirectord] Added real server: 192.168.1.188:3306 ( x 192.168.1.200:3306) (Weight set to 1)
配置完成,临控时时状况:
在DR上 ipvsadm
ipvsadm
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.1.200:mysql rr persistent 600
-> 192.168.1.188:mysql Route 1 0 0
-> 192.168.1.88:mysql Route 1 0 0
-> 192.168.1.8:mysql Local 1 0 0
配置完毕。
内容总结
以上是互联网集市为您收集整理的MySQLLVS负载均衡全部内容,希望文章能够帮你解决MySQLLVS负载均衡所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。