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 07:52:47 +0200
Newsgroups gmane.network.dns.powerdns.user
Message-ID <[email protected]>
>> The PowerDNS mysql database schema is currently not compatible with
>> mysql group replication. You will need to disable this feature for
>> PowerDNS to work.
> 
> that's a bummer. may i ask, what you you then recommend for syncing two 
> servers? the docs (I believe) say it's better to rely on the sql server 
> for replication. so do you suggest reverting to mysql's master-slave or 
> master-master replication scheme instead of group? or something else...?

I'm afraid my answer was incorrect. I had the wrong impression that
mysql group replication did not accept tables with not exactly one
primary key (we have a table with two primary keys) but it turns out
it requires _at least_ one primary key, and our schema should work.

There should be a more detailed error in the group replication plugin
logs, can you check what error gets reported there?

> see attached. apologies if you didn't literally mean to attach the file 
> itself and instead wanted something else. please advise.

That's fine. I will have a look at it shortly.

Thanks,
Miod