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 log-slave-updates auto_increment_increment=10 replicate-do-db=pdns Server 2: log-bin=some name server-id = some number isn't on the other servers replicate-same-server-id = 0 log-slave-updates auto_increment_increment=15 replicate-do-db=pdns 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. -- Thanks, Ed McLain -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon McCartney Sent: Sunday, November 23, 2008 5:49 PM To: Maysara A. Abdulhaq Cc: [email protected] 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. HTH, Simon. -- Simon McCartney E: [EMAIL PROTECTED] M: +44 7710 836 915 IM/MSN: [EMAIL PROTECTED] IM/Y!: simon_mcc _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
