[Pdns-users] MySQL Backend - Multiple Tables?

[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 <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
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120710/afdc859c/attachment-0001.html>