* on the Tue, Sep 05, 2006 at 02:13:54PM +0100, Philip Hazel wrote:
>> I nice solution would be for you to be able to do:
>>
>> hide mysql_servers = named_database1=localhost/dbname1/dbuser1/dbpass1: \
>> named_database2=otherhost/dbname2/dbuser2/dbpass2
>>
>> And then name your database in the lookup:
>>
>> ${lookup mysql{named_database1}{THE QUERY}{$value}}
> In MySQL, you can name the database in the query, but you can't name the
> server. Doing something like what you have suggested is actually quite
> complicated because it would impinge on the query caching. More and more
> I feel that the best solution for Exim is to have some kind of SQL proxy
> daemon that takes the complexity out of Exim itself.
Reading that sparked an idea in my head. I've never used the Federated
storage engine for MySQL before, but I have a vague idea of the way it
works and there might be a solution in there. Time to do some reading I
think.
Mike
