mysql lvs作用_MySQL LVS负载均衡

环境： 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

配置完毕。

本文原创发布php中文网，转载请注明出处，感谢您的尊重！

相关文章

相关视频