[Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)
weaselkeeper at gmail.com
Fri May 8 18:55:21 UTC 2015
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 <pavel.ondrej at gmail.com> wrote:
> Hi, the easist way is this software:
> 2015-05-08 19:31 GMT+02:00 Jan-Piet Mens <jpmens.dns at gmail.com>:
>> > 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.
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
More information about the Pdns-users