<div dir="ltr">James, <div><br></div><div>My configuration is as follows: <br><br>3 locations, each with 1 master + 3 slaves. The masters use the postgresql backend located on a single DB in our primary location. The slaves use the bind backend and store the received zone files locally. <br><br>The pdns configs are correct and this system's been running for more than a year. <br><br>I'm not using supermasters as we deploy new slaves manually and have only added one new slave in each location in the year+ we've been running this configuration. </div><div><br></div><div>The one thing I don't have is the master IPs in the domains table for each zone. I'd need to figure out if I can have multiple ips in that list since I have three masters serving the same zones. <br><br>Scott<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Aug 17, 2015 at 12:26 PM, James Sumners <span dir="ltr"><<a href="mailto:james.sumners@gmail.com" target="_blank">james.sumners@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">What is your configuration like? For example, I have a "master" and a couple "slave" systems. When a change is made on the master system it sends out a notification to the slaves that they need to pickup the update. My slave systems, according to my logs, are checking in with the master systems every so often to verify their data. Since no changes have occurred, they report "Domain '<a href="http://example.com" target="_blank">example.com</a>' is fresh..." and do not initiate an AXFR.<div><br></div><div>It took me a while to wrap my head around how to configure the PDNS master/slave setup. But here's a short rundown:</div><div><br></div><div>Master Server</div><div>1) pdns.conf has `master=yes`, `disable-axfr=no`, and `allow-axfr-ips=...`</div><div>2) zones to be replicated to slaves must have "master" in their "type" column in the database (assuming you're using the manual's schema)</div><div><br></div><div>Slave Server</div><div>1) pdns.conf has `slave=yes`</div><div>2) the "supermasters" table must include a record for the supermaster server. e.g. ip_col = 'ip.address.of.master', nameserver_col = 'local server fqdn', account_col = 'whatever'</div><div><br></div><div>Here's a special note from my internal wiki: "each zone in the "domains" table on the slave systems has an entry in its "master" column with the value set to the IP address of the master server. This is set automatically on the initial transfer. If you change the configuration of the master, remember to update this column."</div><div><br></div><div>Which is to say, if you change the IP address of the master server then you need to remember to update your slave tables.</div></div><div class="gmail_extra"><br><div class="gmail_quote"><span class="">On Mon, Aug 17, 2015 at 11:28 AM, Scott Bragg <span dir="ltr"><<a href="mailto:walkingbear@gmail.com" target="_blank">walkingbear@gmail.com</a>></span> wrote:<br></span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""><div dir="ltr">I have a couple of questions on how PowerDNS authoritative servers pull zones from a PostgreSQL backend. Is it normal for them to do a full zone transfer every X minutes when the SOA TTL is set to X, even if the serial for that zone hasn't changed? <span><font color="#888888"><div><br>Scott</div><div><br></div></font></span></div>
<br></span>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org" target="_blank">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><span class=""><br><br clear="all"><div><br></div>-- <br><div><div dir="ltr"><div><div dir="ltr"><div>James Sumners<br><a href="http://james.sumners.info/" target="_blank">http://james.sumners.info/</a> (technical profile)</div><div><a href="http://jrfom.com/" target="_blank">http://jrfom.com/</a> (personal site)</div><div><a href="http://haplo.bandcamp.com/" target="_blank">http://haplo.bandcamp.com/</a> (band page)</div></div></div></div></div>
</span></div>
<br>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><br></div>