[Pdns-users] MySQL Backend - Multiple Tables?

[Andrew Melton]

The pdns.records table is currently 520,000,000 rows...

Thanks.




On Tue, Jul 10, 2012 at 3:12 PM, Alan Hodgson <ahodgson at simkin.ca> 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,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 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.
>
> You'll have to express that in SQL (case/when etc) in a single statement.
> You
> can't have two gmysql-basic-query options, I don't think.
>
> Also, PDNS gets most of it's data from gmysql-any-query.
>
> Also, IMO, unless records is many tens of millions of rows, I doubt it's
> worth
> splitting. And if it is, you might be better served with a pipe backend,
> since
> your records are probably programatically generated anyway.
>
> --
> When the Athenians finally wanted not to give to society but for society to
> give to them, when the freedom they wished for most was freedom from
> responsibility, then Athens ceased to be free and was never free again.” --
> Edward Gibbon
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120710/52e67c60/attachment-0001.html>