Hi all, On Fri, December 5, 2008 6:40 pm, Ed McLain wrote: > > 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.
This is a very good idea, but could still hit you in a bad situation. I set auto_increment_increment=2 and and auto_increment_offset=1 on the first and auto_increment_offset=2 on the other machine. This scheme should also work for a larger number of servers (at least from a mathematical perspective). Regards, Simon _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
