On Wed, 24 Nov 2004 10:19:39 +0000 (GMT), Philip Hazel
<ph10@???> wrote:
> 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".
Yes - precisely. That should do the job for the OP here.
Peter
