[Pdns-users] MySQL backend serial update but no notify

[Craig Ward]

Hello,

I'm in the process of migrating from MyDNS to PowerDNS as we're unable to use MySQL replication so I'm hoping to take advantage of pdns's master/slave features.

The problem I'm seeing is that updates to resource records (via a web interface on top of mysql) update the serial ok, but these changes aren't automatically propogated to the slave. Running a pdns monitor I'm not seeing any notify requests unless I trigger one manually.

Whilst writing this email I've actually noticed that the serial number is updating on the zone file very often, as in 2 or 3 times every minute!

Here's the SOA when started this mail:

example.com              SOA     ns1.exmaple.com hostmaster.example (
                        1206657638      ;serial (version)            
                        10800   ;refresh period (3 hours)
                        3600    ;retry interval (1 hour)
                        604800  ;expire time (1 week)
                        3600    ;default ttl (1 hour)
                        )

And here it is now...

example.com               SOA     ns1.example.com hostmaster.example.com (
                        1206657819      ;serial (version)
                        10800   ;refresh period (3 hours)
                        3600    ;retry interval (1 hour)
                        604800  ;expire time (1 week)
                        3600    ;default ttl (1 hour)
                        )

I've not made any changes to the records!

And this is it on the slave:

example.com               SOA     ns1.example.com hostmaster.example.com (
                        1206657238      ;serial (version)
                        10800   ;refresh period (3 hours)
                        3600    ;retry interval (1 hour)
                        604800  ;expire time (1 week)
                        3600    ;default ttl (1 hour)
                        )

Then run a notify example.com on the master:

example.com              SOA     ns1.example.com hostmaster.example.com (
                        1206658172      ;serial (version)
                        10800   ;refresh period (3 hours)
                        3600    ;retry interval (1 hour)
                        604800  ;expire time (1 week)
                        3600    ;default ttl (1 hour)
                        )



Any ideas on what could be causing this? And if notify's should happen automatically or is it based on the refresh time despite being mysql driven? I've noticed that if I update 'notified_serial' (which I know is now how this should work) then that triggers a notify.

This is the entry for 'domains' on the master:

 7 | example.com               | NULL          |       NULL | MASTER |               0 | example

And on the slave:

 16 | example.com   | x.x.x.53 | 1206657171 | SLAVE |            NULL | ns1     |



Many thanks in advance for any help you can give me with this.


Craig.