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/