haproxy for mysql slavers load balance.

haproxy.conf

global
    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

转载于:https://www.cnblogs.com/jmbkeyes/archive/2013/01/21/2869617.html