Re: need help with pdns authoritative + gmysql backend with mysql group replication-based servers

Chris Wopat via Pdns-users <[email protected]> Thu, 24 Apr 2025 09:51:31 -0500
Newsgroups gmane.network.dns.powerdns.user
Message-ID <CALsLHcjfPWbBkfZ_Ng04Our5-yXrYtP3pic7Wv69Nh46X4Ovbg@mail.gmail.com>
Also, instead of zone2sql, consider setting the new servers up from scratch
as secondaries to your current production. And set it to AXFR all zones
over. We ran into many issues with zone2sql and this worked better for us.

Not remembering specifics but it was the sanitization of the records as
they came over as we had a bunch of really old records in zones (from the
90s).

In brief the method we used was:

* Create all zones as secondaries in pdns, with your bind as primary:
pdnsutil create-secondary-zone <zone> <bind IP>
* convert to native when ready: pdnsutil set-kind <zone> native

You could also do this in SQL. Don't blindly run these.
* INSERT INTO domains (name,type,master) VALUES ('<zone>', 'SLAVE', '<bind
IP>');
* pdns_control rediscover
* UPDATE domains SET type='NATIVE' WHERE type='SLAVE' ;

--Chris

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users