hiddenmaster setup - how to feed secondarys sql backend

[germebl]

Hey everyone,

actually working on a hiddenmaster setup with 6 secondarys and 2 dnsdist for loadbalancing (educational). I'm using mysql as backend. The databases are within a galera cluster.

The hiddenmaster sql backend uses its own mysql database and i created one for the secondarys sql backend. But when the secondarys getting a notify or trying axfr they all trying to do the changes (e.g. adding a record) and this comes up:

AXFR-in zone: 'domain.rocks', primary: '10.1.201.2', unable to xfr zone (PDNSException): GSQLBackend unable to feed record hiddenmaster.domain.rocks|A: Could not execute mysql statement: insert into records (content,ttl,prio,type,domain_id,disabled,name,ordername,auth) values (?,?,?,?,?,?,?,?,?): Deadlock found when trying to get lock; try restarting transaction

What is the recommended way of feeding the secondarys sql backend? Do they all should get their own database or can they share one database? If they share a database, is there anything I need to be aware of?

Thanks in advance.

Best regards

[germebl]

https://docs.powerdns.com/authoritative/modes-of-operation.html

Solved. Each secondary gets its own database.