Hi Klaus,
I excluded network issues for a while, so I focused my analysis
on MySQL.
Simply running a 'show processlist' during one of the random timeouts
brought me to the solution: I found a lot of queries in state 'Waiting
for query cache lock', so I completely disabled query_cache in MySQL
conf
I think, first you should find out if there is a problem with PowerDNS
or the network - or inbetween.
If this happens regularly, just use tcpdump to caputre all DNS traffic
to a file (rotate files, keep only X files and choose X to not fill your
complete hard disk).
Or even simpler - just ca
Hi,
we have a PowerDNS cluster of authoritative servers running on 4 nodes:
OS: CentOS 7.6.1810 (fully updated)
Version: pdns-4.1.13-1pdns.el7.x86_64
Backend: mysql - MariaDB-server-10.1.41-1.el7.centos.x86_64
Backend is configured with 1 master and 3 slaves.
We perform recurring checks (every 3