[Dovecot] multiple sql servers - loadbalancing and failover

[Arkadiusz Miskiewicz]

On Friday 27 of March 2009, Timo Sirainen wrote:
> On Mar 27, 2009, at 3:20 AM, Arkadiusz Miskiewicz wrote:
> > Is there a way for dovecot to use a pool of sql (mysql) servers and
> > load
> > balance queries between these?
> >
> > Also fallback to next available sql server if connection to previous
> > one
> > fails.
> >
> > Can dovecot do such things currently? (If not this is feature
> > request).
>
> Yes, it can! Just add more multiple host= parameters to connect
> string. It's actually even documented in the dovecot-sql-example.conf:
>
> #   MySQL supports multiple host parameters for load balancing / HA.

Cool! Can load balancing be disabled and HA left, too? :-)

>
> I guess it's not mentioned in the wiki though.

It's not.

-- 
Arkadiusz Miśkiewicz        PLD/Linux Team
arekm / maven.pl            http://ftp.pld-linux.org/