[Pdns-users] MYSQL Replicated Slave Not Updating

[Peter van Dijk]

Hello Corey,

On Apr 19, 2013, at 11:14 , Corey Touchet wrote:

> After a recent power outage we lost our primary and started fresh.  However we are now having issues with the primary updating the secondary.  We use SolusVM which uses powerDNS to handle DNS and rDNS for customers.  The problem is now that we have redone everything the secondary is not receiving updates and serving them.
> 
> We even reinstalled the secondary to see if that would help it still has issues.  The only real fix for DNS records has been completely deleting them out of the system and re-entering them.  during troubleshooting the replication counters and bin log numbers would stay in sync and update in sync with the master, yet the data would just not be there.

This actually sounds like a MySQL problem - PowerDNS does not "control" MySQL replication in any way.

> So far the DNS issues themselves seem to have been resolved, it's rDNS we keep getting complaints to the point we updated ARIN to not look at the secondary.
> 
> What steps are recommended to isolate what is causing this issue?


1. Make sure you are entirely clear on whether there is AXFR involved.
2. If there is, please post configuration details, hostnames, everything you can.
3. If there is no AXFR involved, post everything you can about your MySQL replication setup; however, for MySQL problems, I would suggest a MySQL-specific forum/mailing list.

In any case posting hostnames and other details (so we can actually see what's wrong) helps.

Kind regards,
-- 
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/