I have two MariaDB servers, db1 and db2, and a HAProxy. The HAProxy should load balance between them two and take one off if slave lag is too large. The setup is mostly taken from here:
with a couple of improvements. So, an agent checks the slave lag, and the regular check should take off the nodes from the cluster (in fact, it is a two-node multi master replication).
I have HAProxy version 1.5.8 and am looking since days here:
for a possibility that HAProxy does never switch back to a failed node. So, if node A fails, all traffic should go to node B, until I manually set node A to be healty (either via socat or with HAProxy's web UI).
Is there an option I am missing, or is HAProxy simply the wrong tool for it? As a side note, load balancing is not really necessary.