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?
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
