[Pdns-users] Zone transfers and load balancing PowerDNS.

[Mike Benoit]

On Fri, 2003-08-01 at 16:50, Scott Kamp wrote:
> hrmm mysql doesnt do master - master replication ??? id swear it did....
> check the 4.x versioning, other then that vrrpd might help, if ns1 dies
> just have ns2 take over its assigned ip till it comes back online
> 

Nope, even in v4.x MySQL does not do Master <-> Master replication. It
only does Master -> Slave or Master -> Multi-slave replication.

What your suggesting is strictly fail-over. This would work fine, except
for the fact that we also want load-balancing, as only one name server
can just barely handle our load. 

> On Fri, 2003-08-01 at 18:26, Mike Benoit wrote:
> > We would like to load balance PowerDNS in hopes of getting "true"
> > fail-over, load distribution, and to increase our uptimes even further.
> > I realize DNS has fail-over built in, but there is much room for
> > improvement.
> > 
> > One of the main issues we face is with zone transfers and our replicated
> > MySQL backend. MySQL only supports Master -> Slave replication (Master
> > <-> Master would solve this issue of course), so all zone transfers have
> > to go to NS1 (Master), which will then be replicated to NS2 by MySQL
> > itself. Now in a load balanced system, we can't control, or even force
> > zone transfers to go to NS1. 
> > 
> > I was thinking perhaps adding a new option to PowerDNS similar to how
> > LDAP works. When a request to write to the database comes in to a slave
> > name server, it basically just connects to the master database server
> > and forwards the SQL query off to it. (which then immediately replicates
> > back to the slave database server) 
> > 
> > Has anyone else delt with this issue, or have any bright ideas as to how
> > we could solve it? 
-- 
Best Regards,
 
Mike Benoit
NetNation Communications Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
 ---------------------------------------
 
 Disclaimer: Opinions expressed here are my own and not 
 necessarily those of my employer