Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Alan Hodgson
On Tuesday, July 10, 2012 03:15:49 PM Steven Crandell wrote: > or perhaps just partition your data. > http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html > That would be best. I haven't used MySQL in many years, didn't realize it even had partitioning. I suppose I should set one up

Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Andrew Melton
The pdns.records table is currently 520,000,000 rows... Thanks. On Tue, Jul 10, 2012 at 3:12 PM, Alan Hodgson wrote: > On Tuesday, July 10, 2012 02:56:10 PM Andrew Melton wrote: > > Thanks, so adding something like this to the end of pdns.conf: > > > > gmysql-basic-query=select content,ttl,p

Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Steven Crandell
or perhaps just partition your data. http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html On Tue, Jul 10, 2012 at 3:12 PM, Alan Hodgson wrote: > On Tuesday, July 10, 2012 02:56:10 PM Andrew Melton wrote: > > Thanks, so adding something like this to the end of pdns.conf: > > > > gmys

Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Alan Hodgson
On Tuesday, July 10, 2012 02:56:10 PM Andrew Melton wrote: > Thanks, so adding something like this to the end of pdns.conf: > > gmysql-basic-query=select content,ttl,prio,type,domain_id,name from blocks > where type='%s' and name='%s' and name like '%.4.1.domain.com' > gmysql-basic-query=select co

Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Andrew Melton
Thanks, so adding something like this to the end of pdns.conf: gmysql-basic-query=select content,ttl,prio,type,domain_id,name from blocks where type='%s' and name='%s' and name like '%.4.1.domain.com' gmysql-basic-query=select content,ttl,prio,type,domain_id,name from records where type='%s' and n

Re: [Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread k...@rice.edu
On Tue, Jul 10, 2012 at 02:00:45PM -0700, Andrew Melton wrote: > I am wondering whether it is possible to configure the gmysql backend to > pull from more than one table. Currently, we use `pdns`.`records`, but it > is growing large and I would like to split the data. Any suggestions would > be a

[Pdns-users] MySQL Backend - Multiple Tables?

2012-07-10 Thread Andrew Melton
I am wondering whether it is possible to configure the gmysql backend to pull from more than one table. Currently, we use `pdns`.`records`, but it is growing large and I would like to split the data. Any suggestions would be appreciated. Thanks. ___ Pd

Re: [Pdns-users] pdns & nproxy

2012-07-10 Thread Fred Wittekind
On 7/8/2012 8:31 PM, Fred Wittekind wrote: > On 07/05/2012 06:00 PM, bert hubert wrote: >> On Jul 5, 2012, at 8:18 PM, Fred Wittekind wrote: >>> Then I got this error when trying to start nproxy (IP address >>> censored): >>> nproxy: Fatal: Binding socket for incoming packets to 'a.b.c.d:53': >>> A

[Pdns-users] Bind Backend as superslave

2012-07-10 Thread Sebastian Galiano
Hi The documentation for powerdns states that bind as backend and acting as superslave is still rather experimental. But the help menu gives some clues on how to configure it. I would like to know if it is still experimental or if I can use it Regards Sebastián Galiano _