haproxy | mysql 연동

listen mysql-primary
    bind *:3306
    mode http
    balance roundrobin
    option dontlog-normal
    server mysrv1 192.168.0.100:3306 check inter 5s on-marked-down shutdown-sessions

 

frontend mariadb.front
        mode tcp
        bind :3306

        acl blacklist src -f /etc/haproxy/blacklist.list
        http-request deny if blacklist

        default_backend mariadb.backend

backend mariadb.backend
        mode tcp
        balance roundrobin
        option tcplog
        option dontlog-normal
        option dontlognull
        option tcp-check
        default-server check maxconn 20
        server mariadb 192.168.0.100:3306 check inter 10s fastinter 2s rise 1 fall 3 weight 1