[Pdns-users] DNS Replication

[Derrik Pates]

Nico van Royen wrote:
> If you would have a large amount of DNS servers (in several remote 
> locations) what would be the preffered method of keeping them all in sync ?
> 
> Our current idea is:
> - To have one mysql server on each location
> - Every pdns server on that location connects to the one mysql server
> - One real 'master' mysql server does mysql replication to all remote 
> mysql servers.

This is the approach that I use (as I believe do most implementations of 
PowerDNS with MySQL and replication). The synchronization overhead, once 
you have it set up, is not as high as you seem to think; unless you have 
an exceedingly *high* rate of change of your records (on the order of 
tens to hundreds a second, I think), the overhead of replicating the 
data from your master nameserver to the replicant systems should be 
negligible. What makes you think this would be such an issue?

Based on your wording, I'm not sure if you're really concerned about the 
CPU overhead for MySQL replication, which would be negligible, as I 
said. If your tables are sanely indexed, you'd need a mighty gust of 
queries to seriously start impacting MySQL. Are instead you concerned 
about replication time? This is, in my experience, well under 1 second 
from New York to California given an operational link.

If it's neither of those, maybe you can clarify further what your 
concerns are.

-- 
Derrik Pates
demon at devrandom.net