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

Fabian Santiago via Pdns-users <[email protected]> Thu, 24 Apr 2025 01:42:00 -0400

Newsgroups	gmane.network.dns.powerdns.user
Message-ID	<[email protected]>

hello,

On 4/24/25 12:44 AM, Miod Vallat via Pdns-users wrote:
> 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...?

is there any plans for group replication being made compatible?

> 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? 

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

-- 
Thank you.

Fabian S.

OpenPGP: 0x643082042DC83E6D94B86C405E3DAA18A1C22D8F

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

drbasura.com.zone (text/plain, 1.6 KB)

$TTL 14400
@       IN  SOA ns1.garden-lan.net. admin.drbasura.com. (
            2025042201 ; Serial
            3600       ; Refresh
            1800       ; Retry
            1209600    ; Expire
            86400 )    ; Minimum TTL

        IN  NS      ns1.garden-lan.net.
        IN  NS      ns2.garden-lan.net.

; A and AAAA Records
@       IN  A       31.220.98.148
@       IN  AAAA    2605:a143:2183:3493:0:0:ffff:2
autoconfig IN A     104.237.144.122
autoconfig IN AAAA  2600:3c03:0:0:f03c:93ff:fe3a:489e
www     IN  A       31.220.98.148
www     IN  AAAA    2605:a143:2183:3493:0:0:ffff:2

; MX Records
@       IN  MX 10   mail.gardenlan.com.
@       IN  MX 20   mxbackup1.junkemailfilter.com.
@       IN  MX 30   mxbackup2.junkemailfilter.com.

; CAA Records
@       IN  CAA 0 issue "letsencrypt.org"
@       IN  CAA 0 issuewild ";"
@       IN  CAA 0 iodef "mailto:[email protected]"

; TXT Records
@       IN  TXT "v=spf1 mx ip4:104.237.144.122 ip6:2600:3c03::f03c:93ff:fe3a:489e ~all"
_dmarc  IN  TXT "v=DMARC1; p=none; sp=none; adkim=r; fo=1; ri=86400; rua=mailto:[email protected]; ruf=mailto:[email protected]"
dkim._domainkey IN TXT (
  "v=DKIM1; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsCeufbAodt+hbCedpZ9UH7p3WNWpam/"
  "FZ4yQjGuRbjuaKIWFICMA3PU6VGN8yGpJxEvTW4KxeZIpd/G7IwsnNMllqS/BfAm6vIgtcGt3+lAcDfFsmJ9Q9"
  "VTqoQlIrKfBHBTDcKe8rJ5sCOiWOMxgUcIrRmBPLvNW9s92lZgrIklfaTROfkXgI0c7Cp9JoRXQto94ywXf1rk"
  "MAHxh7MqEhk3eC9t8b0n3LXHJF+Jz91ptD08k7YyafM4LtpMqnbItBLnZtjhSsVa0LquxaVgKCBiZUJS/C4+AK"
  "QSmgZiaxH/lSgiuH8MQZG1ScEHETGuTzb2VPfyFf1Z4BMMxCGLHFwIDAQAB" )

; SRV Record
_autodiscover._tcp IN SRV 1 1 443 mail.gardenlan.com.

OpenPGP_0x5E3DAA18A1C22D8F.asc (application/pgp-keys, 29.3 KB)

OpenPGP_signature.asc (application/pgp-signature, 840 B)