[Pdns-users] 4 nodes authoritative installation

[Mark Scholten]

> From: pdns-users-bounces at mailman.powerdns.com [mailto:pdns-users-
> bounces at mailman.powerdns.com] 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