[Pdns-users] Incrementing SOA serials?

[Drew Linsalata]

We're putting together a small dynamic DNS auto-update system to handle
some customer cloud instances.  This is PDNS using MySQL back end with
MySQL replication between the master node and slave nodes.  Updating a
given resource record in SQL is easy, but what about updating the serial
number in the SOA for the given domain?  Our resource update SQL syntax
looks like this:

"UPDATE records SET CONTENT=\"$1\", CHANGE_DATE=\"`date +%s`\" WHERE
name=\"$2\""

$1 is the new IP of the host
$2 is the host name (i.e. host.domain.com)

Works perfectly, but what about updating the serial number for the zone in
the SOA record?  In an SQL master/slave setup I can't think of a reason
that it would matter.  Any thoughts on that?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120911/4f02caad/attachment.html>