<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 17/10/2020 20:54, Nicholas Williams
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:A23F1D4E-AB1C-4BBB-BC6F-79880FA05472@nicholaswilliams.net">
<pre class="moz-quote-pre" wrap="">First, the concern. I run MySQL in master/slave replication mode. I have a master MySQL server that I write to, and the PowerDNS servers connect to the slaves, not the master. Is there some way to tell PowerDNS to send updates to the master, or will I have to change one of the servers to connect to the master and explicitly send updates only to that server?</pre>
</blockquote>
<p>For DDNS updates, you'd need a powerDNS server which talks to the
master. It can be hidden from the rest of the Internet, and you
can use <a moz-do-not-send="true"
href="https://docs.powerdns.com/authoritative/dnsupdate.html#dnsupdate-configuration-options">forward-dnsupdate</a>
on the slaves to forward to the master.</p>
<p>There is a howto for the ISC dhcp server here:
<a class="moz-txt-link-freetext" href="https://docs.powerdns.com/authoritative/dnsupdate.html#dns-update-how-to-setup-dyndns-rfc2136-with-dhcpd">https://docs.powerdns.com/authoritative/dnsupdate.html#dns-update-how-to-setup-dyndns-rfc2136-with-dhcpd</a><br>
</p>
<p>It is of course moot if VyOS doesn't support DDNS updates: e.g.
<a class="moz-txt-link-freetext" href="https://forum.vyos.io/t/dhcp-service-and-dns-updates/245">https://forum.vyos.io/t/dhcp-service-and-dns-updates/245</a> (but the
last post was from 2016)<br>
</p>
<blockquote type="cite"
cite="mid:A23F1D4E-AB1C-4BBB-BC6F-79880FA05472@nicholaswilliams.net">
<pre class="moz-quote-pre" wrap="">
Second, my question: Is there anyway to customize the queries that PowerDNS uses to update the records? Specifically, I would like to add a flag to records that were added or updated with Dynamic DNS so that my administrative console can differentiate between those and explicit records.</pre>
</blockquote>
<p>If the master server is *only* handling DDNS updates, then you
should be able to customise the query appropriately.</p>
<p><a class="moz-txt-link-freetext" href="https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries">https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries</a></p>
<p><br>
</p>
</body>
</html>