haproxy for mysql slavers load balance.
haproxy.confglobal
maxconn 4096
daemon
pidfile /usr/local/haproxy/haproxy.pid
user haproxy
group haproxy
defaults
log global
mode http
option httplog
option dontlognull
log 127.0.0.1 local0
retries 3
option redispatch
maxconn 2000
contimeout 5000
clitimeout 5000
srvtimeout 5000
listen admin_stats 10.197.60.137:81
mode http
stats uri /dbs
stats realm Global\ statistics
stats auth test:123456
listen proxy-mysql 0.0.0.0:20000
mode tcp
option tcplog
balance roundrobin
option httpchk OPTIONS *HTTP/1.1\r\nHOST:\ www
server db01 10.197.60.137:3307 weight 1 inter 1s rise 2 fall 2
server db02 10.197.60.137:3308 weight 1 inter 1s rise 2 fall 2
option tcpka
and use command (sudo /usr/local/haproxy/sbin/haproxy -f /usr/local/haproxy/conf/haproxy.conf) to start haproxy
页:
[1]