<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">He Atha,<div><br></div><div>We did the name thing Nick did, and I have two recommendation to his (excellent) writeup:</div><div><br></div><div>* we do have one pdns that talks directly to the mysql master. The reason is that we offer backup dns services for some customers that have their own primary dns server. We use the supermaster feature and one of our ns'es is configurered as a axfr-transfer slave</div><div><br></div><div><br></div><div>* the second one is in regard to this:</div><div><br></div><div><div><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>One more thing, which I believe you will find <b>very helpful</b>. The nature of MySQL replication is that it can go down temporarily to account for minor network fluctuations and recover gracefully. However, problems can arise if it's down for long periods of time; say, over 48 hours. What we did is set up a very small, PHP-based Cron job that runs on every worker server every ten minutes, connects to the local MySQL slave backend, and executes the query "SHOW SLAVE STATUS;". It then looks at the columns "Slave_IO_Running" and "Slave_SQL_Running" in the result set. If they aren't BOTH "Yes", it sends us an alert email, and we know there's an issue that needs to be addressed. I highly recommend you do something similar.</div></div></blockquote><div><br></div><div> - there are excellent nagios mysql replication monitoring plugins, BUT an easy one is this, and it tests the entire "chain"</div><div><br></div><div>-- every 2 minutes, update the TXT field of a specific record of a test domain in the master DB. set it to the timestamp at that point</div><div>-- every 5 minutes, check (with dig +short -t TXT specialrecord.specialdomain) the value at all of our pdns auth servers</div><div>-- the timestamp you get back from the dig, can't be different more than a small number of minutes from the current time</div><div><br></div><div>If it does, something in the system is broken: either the pdns uses stale caches, your mysql replication is broken (or slow, which you don't want for your pdns's), or your import into your master db is broken.</div><div><br></div><div>If it works, your entire stack is fine.</div><div><br></div><div>f</div><div><br></div><div><br></div><div><br></div><br><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div><div>Feel free to ask me any questions you may have.</div><div><br></div><div>Nick</div><div><br><div><div>On Nov 10, 2010, at 8:29 AM, Atha Kouroussis wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi all,<br>we are looking to migrate from bind to PowerDNS with MySQL backend. Our initial tests have gone really well and we are now looking into finalizing the architecture for the final deployment and migration. In that respect we have a couple of doubts.<br><br>Since we are going to be using the MySQL backend, and we are going to have multiple PowerDNS servers deployed, is it possible to have several instances of pdns share the same backend? How does that affect slave updates in case a master has more than one slave configured and both slaves use the same backend?<br><br>If its not possible to use the same backend, we are thinking of using MySQL replication, master-slave, and have only one pdns instance listed as slave. What we don't like about this setup is the lack of redundancy since in order to have more than one slave listed we would have to use master-master replication, which we are trying to avoid.<br><br>What are your thoughts on this? Are there any best practices/recommendations for large deployments? Thanks in advance for all your help.<br><br>Cheers,<br>Atha<br>_______________________________________________<br>Pdns-users mailing list<br><a href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a><br><a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br></div></blockquote></div><br></div></div>_______________________________________________<br>Pdns-users mailing list<br><a href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a><br>http://mailman.powerdns.com/mailman/listinfo/pdns-users<br></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Lucida Grande'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><br class="Apple-interchange-newline"><br></div><div>Frank<br><div> </div><div><font class="Apple-style-span" size="1"><span class="Apple-style-span" style="font-size: 9px; "><font class="Apple-style-span" color="#A9A9A9">-- </font></span></font></div><div><br><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Lucida Grande'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div><b><font class="Apple-style-span" color="#006BAB">Frank Louwers</font></b></div><div><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; ">Operations -- Openminds bvba</span></font></font><span class="Apple-tab-span" style="white-space: pre; "><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; "> </span></font></font></span><a href="http://www.openminds.be/"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; ">http://openminds.be</span></font></a></div><div><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; "><a href="mailto:frank@openminds.be">frank@openminds.be</a></span></font></font><span class="Apple-tab-span" style="white-space: pre; "><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; "> </span></font></font></span><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; ">+32.9 225 82 91</span></font></font></div><div><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; "><br></span></font></font></div><div><font class="Apple-style-span" color="#747773"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; ">Schrijf je nu in op onze nieuwsbrief: </span></font></font><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 11px; "><a href="http://www.openminds.be/nieuwsbrief">http://openminds.be/nieuwsbrief</a></span></font></div></div><div><font class="Apple-style-span" size="3"><br></font></div></span></div></div></div></span><br class="Apple-interchange-newline">
</div>
<br></div></body></html>