[Pdns-users] Two R/W DNS servers

Ed McLain EMcLain at teklinks.com
Fri Dec 5 17:40:50 UTC 2008

We actually run this same setup (MySQL circular replication) in production with 2+ servers.  The config is quite easy as long as you get all of the options right ;)

Below are some config tips to get it working.

Server 1:
log-bin=some name
server-id = some number isn't on the other servers
replicate-same-server-id = 0

Server 2:
log-bin=some name
server-id = some number isn't on the other servers
replicate-same-server-id = 0

Basically, the auto_increment_increment value should be different on each server in such a way that when an auto_increment value is used by the server that no 2 servers should ever set the same id at the same time.  The replicate-same-server-id=0 disables the server from re-replicating any queries that hit it from it's master, basically breaking the chain for circular replication.

Hope that helps.
Ed McLain

-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com [mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Simon McCartney
Sent: Sunday, November 23, 2008 5:49 PM
To: Maysara A. Abdulhaq
Cc: pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] Two R/W DNS servers

Maysara A. Abdulhaq wrote:
> Hello all,
> I'm wondering if someone has configured PDNS with db(mysql?) backend
> to do native replication but in two ways ... that is, i could
> add/modify records and domains on either one of two servers and have
> it replicated to the other, this maybe involves configuring/setting up
> "database distribution", no ?

You could do this using MySQL as your backend and doing MySQL
replication between your dns/database servers.

MySQL replication is relatively simple in concept, each database can
slave off another, so that any changed made to the master are replicated
out to the slave.  In order to have this work bi-directionally, database
server A is configured as a master, with B slaving off A.  A is then
configured to slave off A, completing the loop.

There's plenty of online documentation on configuring MySQL replication,
and I use MySQL replicated back-ends in our PDNS environment.



Simon McCartney
E: simon at mccartney.ie           M: +44 7710 836 915
IM/MSN: simonmcc at hotmail.com    IM/Y!: simon_mcc
Pdns-users mailing list
Pdns-users at mailman.powerdns.com

More information about the Pdns-users mailing list