Re: [Pdns-users] PowerDNS authoritative, galera

2017-09-19 Thread Keresztes Péter-Zoltán
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 wrote: > > Hi Nick! > > I found this old thread. I am not familiar with galera, Percona etc. but > IMO the setup i

Re: [Pdns-users] PowerDNS authoritative, galera

2017-09-19 Thread Klaus Darilion
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 up

Re: [Pdns-users] PowerDNS authoritative, galera

2017-08-16 Thread Filipe Cifali
Seems like your MySQL is not ok. This parts of the message hints it: *SQLBackend 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 Have you checked MySQL l

[Pdns-users] PowerDNS authoritative, galera

2017-08-15 Thread 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