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-que

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

2012-07-10 Thread Andrew Melton
om records where type='%s' and name='%s' and name not like '%.4.1.domain.com' Ideally, I'd like to resolve www.4.1.domain.com using the `blocks` table and everything else using the records table. On Tue, Jul 10, 2012 at 2:09 PM, k...@rice.edu wrote: >

[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] Per Zone objects limit

2012-07-06 Thread Andrew Melton
We are running PDNS 2.9 with MySQL backend. The records table contains over 265,000,000 rows, averaging 500 queries per second. Response times are hovering <10ms. -Andy On Mon, Jul 2, 2012 at 9:01 AM, Peter van Dijk wrote: > Hello, > > On Jul 2, 2012, at 17:51 , Peter van Dijk wrote: > > >

Re: [Pdns-users] Flood Throttle

2011-09-07 Thread Andrew Melton
gt; Could you add something in iptables for rate limiting? Granted that wont > handle NXDOMAIN/SRVFAIL specifically, but you could probably guess a high > end average and cap it to that. > -Jon > > On Tue, Sep 6, 2011 at 21:36, Andrew Melton wrote: >> >> Following the advic

[Pdns-users] Flood Throttle

2011-09-06 Thread Andrew Melton
Following the advice from the IRC channel, I am looking for throttling support in PDNS. As I understand it, the rescursor currently has the ability to suppress repetitive queries from being forwarded to an authoritative name server. However, there is no mechanism to discourage those requests from