[Pdns-users] pdns / gmysql / use of change_date

[Harald Kapper]

On Wed, 22 Sep 2004 09:09:21 +0200, Simon Østengaard <SimonO at ascio.com> wrote:

>It was used to auto increment the SOA serial in the old mysql backend. I
>sugested that this feature was added to the gpgsql and gmysql backends in
>ticket http://ds9a.nl/cgi-bin/cvstrac/pdns/tktview?tn=7,4.
>

hi
well that is what is evident ;-)
but actually it is not used in the currently supported gmysql-backend, nor used,
so my suggestion would be to remove this field - if there might be a backend
that supports auto-serialisation again I'd suggest to use eg. a timestamp-field
as basis.

to discuss this feature at all: I think auto-serialisation is a) too high a risk
(some update goes into the table that was not intended to be distributed
automagically to slave-servers or similar) b) is too intensive to work with real
_lots_ of domains and finally I guess c) to set a valid serial in an SOA-record
is not that hard to do - either simply increment it with any changes you'd like
to "commit" to the dns-server or do a little bit of extra-calculation to either
determine a serial on current-date + revision-number or create a "new" serial
for this very day.

just my thoughts here ;)

best
hk