I do use persona xtradb with master-master replication but the DNS servers are configured as native and not master/slave.
Regards, Peter > On 19 Sep 2017, at 23:45, Klaus Darilion <[email protected]> wrote: > > Hi Nick! > > I found this old thread. I am not familiar with galera, Percona etc. but > IMO the setup is to complex. Why do you use master-master replication > between the slaves? The slaves get synced from the master, hence every > slave can have its own DB, no clustering needed. > > if both slaves receive updates at the same time, and both slaves write > to the galera-cluster at the same time, this may cause some locking. > > > regards > Klaus > > Am 16.08.2017 um 04:17 schrieb Nick Urbanik: >> Dear Folks, >> >> Thank you for the great software. >> >> BACKGROUND: >> >> We have just set up an authoritative pair of slaves at two different >> locations. The two slaves at each location share an anycast address. >> Both slaves read/write to a galera backend through a unix socket. We >> are using PowerDNS 4.0.4 on RHEL 7. >> >> These slaves use ordinary DNS replication from a master with a mysql >> backend. The slaves are using Percona-XtraDB-Cluster 5.7.17. The >> masters are using Percona-Server 5.7.18 with corosync and pacemaker, >> DRBD. >> >> PROBLEM: >> >> We have PowerDNS failing quite often (about twice daily) with this message: >> Aug 16 04:11:45 dnsslave2 pdns-instance[20433]: Exiting because >> communicator thread died with error: GSQLBackend unable to refresh >> domain_id 18537: Could not >> execute mysql statement: update domains set last_check=? where id=?: >> Deadlock f >> ound when trying to get lock; try restarting transaction >> Aug 16 04:11:46 dnsslave2 pdns-instance[20433]: Got a signal 6, >> attempting to >> print trace: >> >> [stack trace followed by restart by systemd] >> >> I would be grateful for any suggestions on what we could do to remedy this. > _______________________________________________ > Pdns-users mailing list > [email protected] > https://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list [email protected] https://mailman.powerdns.com/mailman/listinfo/pdns-users
