If it helps, I have a script I wrote to do dns comparisons between resolvers, you can find it in my github repo for misc monitoring scripts. https://github.com/weaselkeeper/misc_monitoring_scripts the script in question is dnscompare.py
It will compare zones as well as host records. If that helps. On Fri, May 8, 2015 at 11:45 AM, Pavel Ondřej <[email protected]> wrote: > Hi, the easist way is this software: > https://www.devart.com/dbforge/mysql/datacompare/ > > Pavel > > 2015-05-08 19:31 GMT+02:00 Jan-Piet Mens <[email protected]>: >> >> > What do you guys think would be the best approach for comparing two >> > PowerDNS MYSQL databases that are supposed to hold the same domains >> > and records? >> >> Instead of mucking about with SQL what I would probably do is configure >> both servers as masters; then, on each, AXFR each of the zones, and use >> Tony Finch's `nsdiff' utility to diff the results. >> >> If I could only go the SQL way, I'd probably write a script which dumps >> the domains and records tables on each (sorted) and diff those; it'll at >> least give you an indication on whether there actually are differences. >> >> -JP >> >> >> _______________________________________________ >> Pdns-users mailing list >> [email protected] >> http://mailman.powerdns.com/mailman/listinfo/pdns-users > > > > _______________________________________________ > Pdns-users mailing list > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users > _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
