[Pdns-users] Two R/W DNS servers

[Simon Hitzemann]

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