[Pdns-users] Power DNS & MySQL Versions 5

Sun Jun 25 16:45:55 UTC 2006

Am Mittwoch, 31. Mai 2006 17:37 schrieb bert hubert:
> I'll look into the mysql 5 issue soonest. It is supposed to work
> fine.
>
> Thanks for reporting the problem.
>
> On Tue, May 30, 2006 at 03:57:13PM -0400, Garland, Ken R wrote:
> > Jeremy May wrote:
> > >AJ McKee wrote:
> > >>Hi All,
> > >>
> > >>I am considering updating the database servers to MySQL version
> > >> 5.0 (Or 5.1
> > >>which is in beta now but should be production by the time we get
> > >> around to it.). Currently we use Red Hat Enterprise 4, MySQL 4
> > >> and source built PDNS instances configured with the gmysql
> > >> backend.
> > >>
> > >>Has anyone had any problems running Power DNS with MySQL 5, or
> > >> would you care to share your experience.
> > >>
> > >>Thanks in advance
> > >>AJ
> > >>
> > >>
> > >>_______________________________________________
> > >>Pdns-users mailing list
> > >>Pdns-users at mailman.powerdns.com
> > >>http://mailman.powerdns.com/mailman/listinfo/pdns-users
> > >
> > >i currently use mysql 5 (backports on debian) with powerdns and
> > > the gmysql backend and it works great!.
> >
> > I have this setup as well, but it works poorly. Sorry to hijack the
> > thread here, I recently wrote in but I think it was regected as I
> > was not signed up as a member yet.
> >
> > The problem I am having is:
> >
> > May 30 09:13:53 HOSTNAME pdns[6621]: Backend error: Failed to
> > execute mysql_query, perhaps connection died? Err=1: MySQL server
> > has gone away
> >
> > I've set wait_timeout = 60000 in my.cnf but still getting this
> > error. The last successful query was well over 16 hours (60000,
> > roughly) so it was past the timeout period. However, in production
> > this is just not acceptable. What if there are no queries in that
> > time, do I have to manually reset the server everytime or set the
> > timeout to infinity. How to bypass this timeout feature and what is
> > the point of it. It really makes no sense as you want a service
> > available 24/7, that is the point of running these services. I've
> > never had to deal with this problem, shouldn't the pdns daemon have
> > some sort of refresh rec-connect switch built-in that allows it to
> > establish a connection when needed, or just connect without
> > timeout.
> >
> > I'm running Ubuntu Dapper 6.06 with MySQL 5.
> > _______________________________________________
> > Pdns-users mailing list
> > Pdns-users at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> >
> >
> > !DSPAM:447ca3b0315261635413018!

I got no problems here on dapper 6.06 amd64:

PDNS 2.9.20 Main Page
Uptime: 1.35 hours Queries/second, 1, 5, 10 minute averages: 1.03, 1.37, 
2.07. Max queries/second: 3.38e+03
Cache hitrate, 1, 5, 10 minute averages: 23%, 26%, 52%
Backend query cache hitrate, 1, 5, 10 minute averages: 70%, 70%, 70%
Backend query load, 1, 5, 10 minute averages: 1.84, 2.52, 2.46. Max 
queries/second: 3.75
Total queries: 322686. Question/answer latency: 0.024ms

Top-10 of 7: Log Messages
Reset	Resize: 10 100 500 1000 (10000) 500000
Received a malformed qdomain from 
127.0.0.1, 'www.denali.it&banner_id=26': dropping	560	98%
gmysql Connection succesful	5	0.88%
About to create 3 backend threads for UDP	1	0.18%
Creating backend connection for TCP	1	0.18%
Distributor misses a thread (4<3), spawning new one	1	0.18%
Done launching threads, ready to distribute questions	1	0.18%
Launched webserver on 127.0.0.1:8081	1	0.18%
Total:	570	100%

[...]

Variables
corrupt-packets	560	Number of corrupt packets received
deferred-cache-inserts	0	Amount of cache inserts that were deferred 
because of maintenance
deferred-cache-lookup	0	Amount of cache lookups that were deferred 
because of maintenance
latency	24	Average number of microseconds needed to answer a question
packetcache-hit	319369	
packetcache-miss	3317	
packetcache-size	1017	
qsize-q	1	Number of questions waiting for database attention
query-cache-hit	18780	Number of hits on the query cache
query-cache-miss	8630	Number of misses on the query cache
recursing-answers	2757	Number of recursive answers sent out
recursing-questions	2757	Number of questions sent to recursor
servfail-packets	0	Number of times a server-failed packet was sent out
tcp-answers	0	Number of answers sent out over TCP
tcp-queries	0	Number of TCP queries received
timedout-packets	0	Number of packets which weren't answered within 
timeout set
udp-answers	322126	Number of answers sent out over UDP
udp-queries	322686	Number of UDP queries received
udp4-answers	319369	Number of IPv4 answers sent out over UDP
udp4-queries	322686	Number of IPv4UDP queries received
udp6-answers	0	Number of IPv6 answers sent out over UDP
udp6-queries	0	Number of IPv6 UDP queries received

My Installation:
$ dpkg -l *mysql*|grep ^ii &&  dpkg -l *pdns*|grep ^ii
ii  gda2-mysql           1.2.2-1ubuntu2     MySQL backend plugin for 
GNOME Data Access l
ii  libdbd-mysql-perl    3.0002-2build1     A Perl5 database interface 
to the MySQL data
ii  libmysqlclient10     3.23.56-3          LGPL-licensed client library 
for MySQL datab
ii  libmysqlclient12     4.0.24-10ubuntu2   mysql database client 
library
ii  libmysqlclient14     4.1.15-1ubuntu5    mysql database client 
library
ii  libmysqlclient15off  5.0.22-0ubuntu6.06 mysql database client 
library
ii  mysql-client         5.0.22-0ubuntu6.06 mysql database client 
(current version)
ii  mysql-client-5.0     5.0.22-0ubuntu6.06 mysql database client 
binaries
ii  mysql-common         5.0.22-0ubuntu6.06 mysql database common files 
(e.g. /etc/mysql
ii  mysql-doc            4.0.23-1           mysql database documentation
ii  mysql-server         5.0.22-0ubuntu6.06 mysql database server 
(current version)
ii  mysql-server-5.0     5.0.22-0ubuntu6.06 mysql database server 
binaries
ii  pdns-backend-mysql   2.9.20-1           generic mysql backend for 
PowerDNS
ii  php4-mysql           4.4.2-1build1      MySQL module for php4
ii  python-mysqldb       1.2.1c3-4ubuntu4   A Python interface to MySQL
ii  python2.4-mysqldb    1.2.1c3-4ubuntu4   A Python interface to MySQL
ii  snort-mysql          2.3.3-5ubuntu2     Flexible Network Intrusion 
Detection System
ii  pdns               2.9.19-3build1 meta package for the pdns 
nameserver
ii  pdns-backend-mysql 2.9.20-1       generic mysql backend for PowerDNS
ii  pdns-doc           2.9.19-3build1 PowerDNS manual
ii  pdns-recursor      3.1.1-1        powerdns blah
ii  pdns-server        2.9.20-1       extremely powerful and versatile 
nameserver

$ uname -r
2.6.15-25-amd64-generic