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@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
