queries fail when mysql replication consumes CPU on large zones
NameSpot <[email protected]> Sat, 25 Apr 2015 11:44:56 -0700
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <1429987496.2026273.258532505.2A859E4C@webmail.messagingengine.com> |
We've had an installation where the nameserver stopped responding to queries because mysql replication was consuming 100% of the CPU $ named -V BIND 9.9.5 (Extended Support Version) <id:f9b8a50e> built by make with '--prefix=/usr/local/bind-dlz' '--with-openssl' '--with-dlz-mysql=yes' '--with-dlz-stub=yes' '--with-dlz-filesystem=yes' '--disable-openssl-version-check' '--enable-rrl' compiled by GCC 4.4.5 The problem was a large zone updating frequently (40,000+ records at a time) caused the remote mysql slaving replication on the bind-dlz installation to consume 100% of the CPU, having the effect of causing dns queries to that node timing out. Is this more of a mysql optimization issue or is there something to be done within bind-dlz that can mitigate against the possibility of the nameserver itself being crowded out by the mysql daemon for any reason (not just this particular case) Thank you. ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y