On 10/10/06, W B Hacker <[EMAIL PROTECTED]> 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. Does that help? Peter -- Peter Bowyer Email: [EMAIL PROTECTED] -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
