[Pdns-users] MySQL Backend - Multiple Tables?

[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 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, ktm at rice.edu <ktm at rice.edu> wrote:

> 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 appreciated.
> >
> > Thanks.
>
> It is possible to define the SQL queries that are run in the PDNS
> configuration file pdns.conf. You should be able to do what you
> need. See the manual for the default queries being used.
>
> Cheers,
> Ken
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120710/e3dde6b9/attachment-0001.html>