Author: Peter Bowyer Date: To: Exim, Users Subject: Re: [exim] mysql (multiple servers)
On 10/10/06, W B Hacker <wbh@???> wrote: > tlabs wrote:
> > How exactly does the conf of multiple mysql servers work?
> > Is it as failover style thing or a load balanced algorythm?
> >
> > cheers
> >
> >
>
> Wrong list.
>
> This is Exim, an smtp MTA.
>
> MySQL is down the hall.......
Bill's in an uncharitable mood today and clearly needs coffee -
assuming you're referring to the feature of Exim which allows you to
specify multiple MySQL servers... it's kind-of failover; it definitely
isn't load-balancing.
If a query fails on the first server, it will be tried on the next and
then subsequent. The next query will be tried again on the first
server.
'Fails' covers all kinds of MySQL errors returned from the client
library, including connection errors, 'no such table' errors, syntax
errors, etc etc. It specifically excludes a situation where the query
runs successfully but returns no data - you deal with that in your
lookup syntax.
