Haproxy 为 mysql 做负载均衡
tar zxvf haproxy-1.4.21.tar.gzcd haproxy-1.4.21
uname -r
vim /etc/haproxy.cfg
global
#日志
log 127.0.0.1 local0
maxconn 4096
chroot /tmp
uid0
gid0
daemon
nbproc 2
pidfile logs/haproxy.pid
#debug
#quiet
defaults
log 127.0.0.1 local3
mode http
#optionhttplog
#optionhttpclose
optiondontlognull
#optionforwardfor
optionredispatch
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
listenmysql_proxy
#代理端口
bind 0.0.0.0:33060
#模式 TCP
mode tcp
#调度算法
balance roundrobin
#mysql健康检查
option mysql-check
#健康检查加上check
servers1 192.168.1.42:3306 weight 3 check port 3306 inter 1s rise 2 fall 2
servers3 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
页:
[1]