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, k...@rice.edu <k...@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 >
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
