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

Miod Vallat via Pdns-users <[email protected]> Thu, 24 Apr 2025 06:44:13 +0200
Newsgroups gmane.network.dns.powerdns.user
Message-ID <[email protected]>
Hello,

[...]
 > mysql wise, the 2 servers are replicating their data using mysql group
> replication. pdns itself is NOT doing anything primary -vs- secondary; 
> they're just going to host native zones.

> error from attempt 1:
> Apr 23 20:48:38 [bindbackend] Done parsing domains, 0 rejected, 0 new, 0 
> removed
> Creating '<my zone name>'
> Error: Database failed to start transaction for domain '<my zone name>': 
> Could not execute mysql statement: delete from records where 
> domain_id=?: The table does not comply with the requirements by an 
> external plugin.

The PowerDNS mysql database schema is currently not compatible with
mysql group replication. You will need to disable this feature for
PowerDNS to work.

> attempt 2:
> Enter password:
> Fatal error: Error in bind configuration '<my zone file>' on line 41: 
> syntax error

This means that the bind zone file parser in PowerDNS is stricter than
bind's, or lacks support for a particular bind construct. Can you share
the actual zone file you are using (or at least the first 50 lines of
it) so that we can investigate further?

Regards,
Miod