Re: [exim] mysql (multiple servers)

On Wed, Oct 11, 2006 at 04:18:51AM +0800, W B Hacker 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.......

um... I assume he means how to configure exim to talk to
(>1) MySQL server. The answer is in §9.18 of the spec:

| For each query, these parameter groups are tried in order until a connection
| and a query succeeds.

-- i.e., it's failover-style rather than load balancing.
If you need load balancing (unlikely in most
configurations, I'd have thought) I think you'd need a
proxy, or to use (say) embedded perl to do your querying.

--
``Computer-simulators, used to stage mock failures in the flight trainer,
weren't working. This was a triumph of accurate simulation, but otherwise
not amusing.'' (Gregg Easterbrook, on space shuttle development)