You could use a multi master mysql cluster with haproxy as loadbalancer. That way the haproxy would detect if one of the nodes would be down and would route the request only to active nodes.
Regards, > On 08 May 2016, at 22:06, thing <[email protected]> wrote: > > Can pdns can be configured to connect to more than 1 mysql backend (say 3 > mysql servers) and submit requests to them either in a linear hunt or > round-robin distribution. Also, can it detect if a server is not > available and not use it to submit request? Please, reply with > configuration example > > > > -- > View this message in context: > http://powerdns.13854.n7.nabble.com/Multiple-mysql-backend-tp12264.html > Sent from the PowerDNS mailing list archive at Nabble.com. > _______________________________________________ > Pdns-users mailing list > [email protected] > https://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list [email protected] https://mailman.powerdns.com/mailman/listinfo/pdns-users
