> From: [email protected] [mailto:pdns-users- > [email protected]] On Behalf Of Ciro Iriarte > Sent: 29 May, 2013 21:51 > > Good afternoon, I'm planning to implement 4 node authoritative servers > working in tandem, using mysql circular replication won't be nice because if > one node fails the replication is broken. > > Though about having a 5th "management server" with mysql running as > master for the other 4, this can be a tiny virtual machine which will be > protected by the virtualization farm. > > Another idea would be to work with pairs, each pair in a multimaster mysql > replication setup, running application level replication between pairs > > Any comments?
Use a single MySQL master and multiple MySQL slaves. You can use a separate MySQL server as management server/MySQL master or combine it with a PowerDNS server. Disable the PowerDNS systems using a MySQL slave to be a master or slave. And limit the MySQL user used by PowerDNS to selects and check that insert/update is disabled for that user. Regards, Mark _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
