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。