Re: [Pdns-users] database backends without replication?

2010-12-02 Thread Chris Hesselrode
Mark:

We actually faced a similar problem (as far as inability to replicate to a
single machine - for other reasons than the arch). It's kind of a hokey
work-around, but it does work quite well, as long as you don't need it to be
instant.

** This would never be recommended for high-traffic servers, or servers
where updates to the db are taking place consistently.

On the primary nameserver, we dump the database to a SQL file which is made
available in a directory only readable by the IP address of the slave
machine. The file is pulled down from the master via HTTPS, and then
re-imported into the database on the slave - all done with a script.

We currently have our set up pulling the file every 7 minutes, which works
for us - but you may want to shorten or lengthen that timeframe.

Just out of curiosity - any reason you're using postgres instead of MySQL
for the pdns servers? MySQL replication works flawlessly cross-arch.

Chris Hesselrode | Principal / President

Phoenix Knowledge Ventures, LLC
PO Box 342
Maricopa, AZ 85139

-Original Message-
From: pdns-users-boun...@mailman.powerdns.com
[mailto:pdns-users-boun...@mailman.powerdns.com] On Behalf Of Mark Felder
Sent: Thursday, December 02, 2010 11:42 AM
To: pdns-users@mailman.powerdns.com
Subject: [Pdns-users] database backends without replication?

OK, well I have a small personal DNS infrastructure for some friends of mine
and myself and I wanted to use PowerDNS going forward. I have a few
questions though because I've never found clear information on this:

The servers are not the same arch; one is 32bit the other is 64bit. I want
to run a database backend (postgres) on at least one server so I can have
poweradmin. There's another server whichb can't receive the data by
streaming replication because of the arch difference and I'm not going to
screw with Slony or Londiste as a workaround. In our BIND setup at work, if
you have ns1 ns2 and ns3 and you add a domain, you have to actually modify
the config file on the ns2 and ns3 slaves before they will pick up the new
domain and records via AXFR. This is terribly tedious, and we actually rsync
ns2 to ns3 and trigger a reload as a workaround, but still it's lame. If I
use a database backend on each side without database replication, can I use
an AXFR to have it automatically add a domain to the database of the slave,
or is this still an issue with AXFR as a whole?

Simply put, I don't want to have to touch the slaves when a new domain is
added to the master. How does this work without database replication?



Thanks,


Mark
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users

___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] database backends without replication?

2010-12-02 Thread Jeremy Utley

On 12/2/2010 12:42 PM, Mark Felder wrote:
If I use a database backend on each side without database replication, 
can I use an AXFR to have it automatically add a domain to the 
database of the slave, or is this still an issue with AXFR as a whole?


Simply put, I don't want to have to touch the slaves when a new domain 
is added to the master. How does this work without database replication?
Read the PowerDNS documentation on Supermaster setups.  Basically, you 
designate your master DNS server as a supermaster, and when the slaves 
receive the announcement from the master, they automatically add that 
domain into themselves, and initiate a transfer.  Removing domains would 
still require manual intervention, however.


Jeremy
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users