mysql集群 lvs_LVS+Mysql集群负载均衡

一、IP信息列表： 名称 IP LVS-DR-VIP 192.168.50.245 LVS-DR-Master 192.168.50.216 LVS-DR-BACKUP 192.168.50.217 MySQL1-Realserver 192.168.50.212 MySQL2-Realserver 192.168.50.213 GateWay 192.168.50.254 其他(部署LVS过程中无需配置)： MGM管理节

一、IP信息列表：

名称 IP

LVS-DR-VIP 192.168.50.245

LVS-DR-Master 192.168.50.216

LVS-DR-BACKUP 192.168.50.217

MySQL1-Realserver 192.168.50.212

MySQL2-Realserver 192.168.50.213

GateWay 192.168.50.254

其他(部署LVS过程中无需配置)：

MGM管理节点 192.168.50.211

NDBD存储节点1 192.168.50.214

NDBD存储节点2 192.168.50.215

一. 安装LVS和Keepalvied软件包

1. 下载相关软件包

#cd /usr/local/src/tarbag

#wget http://www.linuxvirtualserver.org/software/kernel-2.6/ipvsadm-1.24.tar.gz

#wget http://www.keepalived.org/software/keepalived-1.1.15.tar.gz

2. 安装LVS和Keepalived

#lsmod |grep ip_vs

#uname -r

2.6.18-128.el5

#ln -s /usr/src/kernels/2.6.18-128.el5-i686/ /usr/src/linux

//这步一定要做,否则ipvsadm编译会报错

#tar zxvf ipvsadm-1.24.tar.gz

#cd ipvsadm-1.24

#make && make install

#tar zxvf keepalived-1.1.15.tar.gz

#cd keepalived-1.1.15

#./configure && make && make install

#cp /usr/local/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/

#cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/

#mkdir /etc/keepalived

#cp /usr/local/etc/keepalived/keepalived.conf /etc/keepalived/

#cp /usr/local/sbin/keepalived /usr/sbin/

#chkconfig add keepalived

#chkconfig keepalived on #做成系统服务

#service keepalived start|stop|status

二、配置lvs与RealServer脚本

1.lvs脚本(主备两台LVS上操作)

#vi /usr/local/sbin/lvs-dr.sh

//以下为脚本内容

#!/bin/bash

# description: start LVS of DirectorServer

#Written by :NetSeek http://www.linuxtone.org

GW=192.168.50.254 #当前局域网网关ip

# website director vip.

MySQL_VIP=192.168.50.246 #MySQL虚拟IP地址

MySQL_RIP1=192.168.50.212

MySQL_RIP2=192.168.50.213

/etc/rc.d/init.d/functions

logger $0 called with $1 #记录到系统日志messages

case "$1" in

start)

# set squid vip

/sbin/ipvsadm --set 30 5 60 #分别为协议tcp tcpfin udp 的超时时间

/sbin/ifconfig eth0:0 $MySQL_VIP broadcast $MySQL_VIP netmask 255.255.255.255 broadcast $MySQL_VIP up #新建VIP

/sbin/route add -host $MySQL_VIP dev eth0:0 #为VIP添加路由

/sbin/ipvsadm -A -t $MySQL_VIP:3306 -s wrr -p 3 #添加一个VIP

/sbin/ipvsadm -a -t $MySQL_VIP:3306 -r $MySQL_RIP1:3306 -g -w 1 #将VIP:3306的请求转发到RIP1上,-g表示使用DR模式,-w表示权重为1

/sbin/ipvsadm -a -t $MySQL_VIP:3306 -r $MySQL_RIP2:3306 -g -w 1

touch /var/lock/subsys/ipvsadm >/dev/null 2>&1 #新建文件ipvsadm,主要用来表示服务器已经启动,为status做准备

;;

stop)

/sbin/ipvsadm -C #清空LVS所有规则

/sbin/ipvsadm -Z #所有服务器计数器清零

ifconfig eth0:0 down #禁用虚拟网卡eth0:0

route del $MySQL_VIP #删除VIP的路由

rm -rf /var/lock/subsys/ipvsadm >/dev/null 2>&1

echo "ipvsadm stoped"

;; #相当于C语言中的break,跳出case

status)

if [ ! -e /var/lock/subsys/ipvsadm ];then #如果ipvsadm不存在则输出ipvsadm stoped

echo "ipvsadm stoped"

exit 1

else

echo "ipvsadm OK"

fi

;;

*)

echo "Usage: $0 {start|stop|status}"

exit 1

esac

exit 0

2.RealServer脚本(所有MySQL上操作)

#vi /usr/local/sbin/realserver.sh

#!/bin/bash

# description: Config realserver lo and apply noarp

#Written by :NetSeek http://www.linuxtone.org

MySQL_VIP=192.168.50.245 #虚拟IP

/etc/rc.d/init.d/functions #这个作用暂时不知道,知道的同学帮忙修改一下

case "$1" in

start)

ifconfig lo:0 $MySQL_VIP netmask 255.255.255.255 broadcast $MySQL_VIP #新建虚拟ip,LVS中所有的VIP都一致

/sbin/route add -host $MySQL_VIP dev lo:0

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

sysctl -p >/dev/null 2>&1

echo "RealServer Start OK"

;;

stop)

ifconfig lo:0 down

route del $MySQL_VIP >/dev/null 2>&1

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 "RealServer Stoped"

;;

*)

echo "Usage: $0 {start|stop}"

exit 1

esac

exit 0

三、启动相关服务

1.主备LVS

#chmod 755 /usr/local/sbin/lvs-dr.sh #赋予执行权限

#/usr/local/sbin/lvs-dr.sh #启动lvs

#service keepalived start #启动keepalived服务

2.MySQL Cluster中的2台SQL节点

#cd /usr/local/sbin

#chmod 755 realserver.sh

#./realserver.sh

四、测试

方法1：

#telnet 192.168.50.245 3306

N

5.1.39-ndb-7.0.9-cluster-gpl-log菔1sti5i5+;*^{qFI{OWJ

//出现以上内容说明请求转发成功

方法二：

使用mysql的各种客户端工具连接mysql。

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网