[Dovecot] multiple sql servers - loadbalancing and failover

[Timo Sirainen]

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.

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