MySQL proxy HA with no need to reconnect after node failure
- by Matthias
I use MySQL with Galera wsrep to get synchronous replication, that part it's up and running
I need to setup a kind of proxy to handle client connections. Since any node in cluster can fail, clients will not connect nodes directly, but only via proxy.
Currently I use Galera Load Balancer which does it work, but with one exception:
if one node fails, all clients connected via proxy to that node get connection error and need to reconnect.
I have no control over server applications connected to proxy and some of them can't reconnect automatically and need manual restart. So the question is how to force proxy automatically redirect already connected applications to new data node, without need to reconnect?
