Haproxy 为 mysql 做负载均衡

sonyet

tar zxvf haproxy-1.4.21.tar.gz
cd haproxy-1.4.21
uname -r
vim /etc/haproxy.cfg

global
#日志
log 127.0.0.1    local0
maxconn 4096
chroot /tmp
uid  0
gid  0
daemon
nbproc 2
pidfile logs/haproxy.pid
#debug   
#quiet   
defaults
log     127.0.0.1       local3
mode    http
#option  httplog   
#option  httpclose   
option  dontlognull
  #option  forwardfor   
option  redispatch
retries 2
maxconn 2000
contimeout 3000
clitimeout 30000
srvtimeout 30000
balance roundrobin
bind-process 1
#监控状态页配置
listen stats
mode http
bind 0.0.0.0:8080
stats enable
stats   uri     /dbstat
stats   realm Global\ statistics
#身份验证
stats auth admin:hello123

listen  mysql_proxy
#代理端口
bind 0.0.0.0:33060
#模式 TCP
mode tcp
#调度算法
balance roundrobin
#mysql健康检查
option mysql-check
#健康检查加上check
server  s1 192.168.1.42:3306 weight 3 check port 3306 inter 1s rise 2 fall 2
server  s3 192.168.1.43:3306 weight 3 check port 3306 inter 1s rise 2 fall 2
#启动服务
/usr/local/haproxy/sbin/haproxy -f /etc/haproxy.cfg
#杀掉服务
pkill haproxy
#启动脚本
vim /etc/init.d/haproxy
========================================
#! /bin/sh
set -e
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/haproxy/sbin
PROGDIR=/usr/local/haproxy
PROGNAME=haproxy
DAEMON=$PROGDIR/sbin/$PROGNAME
CONFIG=/etc/haproxy.cfg
PIDFILE=$PROGDIR/logs/$PROGNAME.pid
DESC="HAProxy daemon"
SCRIPTNAME=/etc/init.d/$PROGNAME
# Gracefully exit if the package has been removed.
test -x $DAEMON || exit 0
start()
{
echo -n "Starting $DESC: $PROGNAME"
$DAEMON -f $CONFIG
echo "."
}
stop()
{
echo -n "Stopping $DESC: $PROGNAME"
haproxy_pid=cat $PIDFILE
kill $haproxy_pid
echo "."
}
restart()
{
echo -n "Restarting $DESC: $PROGNAME"
$DAEMON -f $CONFIG -p $PIDFILE -sf $(cat $PIDFILE)
echo "."
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
restart
;;
*)
echo "Usage: $SCRIPTNAME {start|stop|restart}" >&2
exit 1
;;
esac
exit 0
=================================================
chmod +x /etc/init.d/haproxy
#启动服务
/etc/init.d/haproxy start
　　
　　参考：
　　http://www.iyunv.com/database/201412/357835.html
　　http://blog.sina.com.cn/s/blog_5f66526e0100om1x.html