Toolserver:Admin:Haproxy

From mediawiki.org

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

haproxy is a TCP load-balancing daemon; it accepts connections and routes them to an appropriate server. It is used to distribute MySQL connections to an appropriate database.

haproxy runs on the HA cluster in /global/misc/haproxy. The cluster resource group and resource are both called haproxy-sql. To configure it, edit /global/misc/haproxy/haproxy.conf, then do clrs disable haproxy-sql; clrs enable haproxy-sql. Note that at the moment, this will disconnect all MySQL clients; there should be a nicer way to do this soon.