On Wed, 24 Nov 2004, Peter Bowyer wrote:
> > No, that doesn't do it. The list in mysql_servers is a backup list; it
> > only uses the second server if it cannot access the first one
>
> Interesting - that's not my experience - if the first query fails
> because of a non-existant db on the connection (as well as because of
> a failed connection), it falls back to the second connection.
Sorry, I wasn't entirely explicit. What I meant by "cannot access" was
supposed to cover that case. It tries another server if there is any
kind of failure with the first one, but NOT if the query succeeds with
the result "no data found".
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
Get the Exim 4 book: http://www.uit.co.uk/exim-book