[Pdns-users] need help with pdns authoritative + gmysql backend with mysql group replication-based servers

[Miod Vallat]

> there is an error:
> 
> 2025-04-24T15:27:41.272419Z 1861 [ERROR] [MY-011543] [Repl] Plugin 
> group_replication reported: 'Table records has a foreign key with 
> 'CASCADE', 'SET NULL' or 'SET DEFAULT' clause. This is not compatible 
> with Group Replication.'
> 

Ah, you probably enabled foreign keys, as advised by the documentation.
This is what causes the incompatibility with the group replication.

You might want to drop your PowerDNS database and create it again from
the SQL schema, without applying the "enable foreign keys" script.

HTH,
Miod