[Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

[Jim Richardson]

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:
> https://www.devart.com/dbforge/mysql/datacompare/
>
> Pavel
>
> 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.
>>
>>         -JP
>>
>>
>> _______________________________________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
>> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>