[Pdns-users] specifying more complex sql queries with gmysql back-end

Peter van Dijk peter.van.dijk at netherlabs.nl
Sat Nov 12 21:03:06 UTC 2011


Hello Tom,

On Nov 11, 2011, at 15:59 , Tom wrote:

> With reference to specifying the queries I want to use for the gmysql back-end - for instance : gmysql-basic-query=
> 
> Am I right in thinking that in the pdns configuration file, I'm not going to be able to specify a query with references the name and query type multiple times?  I've just realised that the first time you use %s you're referencing the type, and the second time, the name.  Is there anything I can do to specify more complex queries (which repeat both type and name more than once)?
> 
> I understand I could be using stored procedures, but due to MySQLs unique implementation, the results of stored procedures are not cached, and nor are the results of queries within the procedures, and that's proving to be a real problem for me!

I do not have a clear-cut answer for you right away, but I'm curious about what you are trying to accomplish. Could you perhaps share some details about your setup, maybe even show us what the queries you have in mind look like?

Kind regards,
Peter van Dijk


More information about the Pdns-users mailing list