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