[Pdns-users] MySQL Backend - Multiple Tables?
amelton at gmail.com
Tue Jul 10 21:56:10 UTC 2012
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
> > is growing large and I would like to split the data. Any suggestions
> > 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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pdns-users