Re: [Dovecot] multiple sql servers - loadbalancing and failover

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.