Script to make a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly. The clustercheck script is distributed under the BSD license.
I run mysql on port 3307 how can make the script work?
/etc/haproxy/haproxy.cfg
I have like:
...
listen percona-cluster 0.0.0.0:3306
balance leastconn
option httpchk
mode tcp
server node1 1.2.3.4:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2
server node2 1.2.3.5:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2
server node3 1.2.3.6:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2 backup
I run mysql on port 3307 how can make the script work?
/etc/haproxy/haproxy.cfg
I have like: ... listen percona-cluster 0.0.0.0:3306 balance leastconn option httpchk mode tcp server node1 1.2.3.4:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2 server node2 1.2.3.5:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2 server node3 1.2.3.6:3307 check port 9200 inter 5000 fastinter 2000 rise 2 fall 2 backup