Am 25.08.2014 um 11:48 schrieb Florent Bautista:

I am using Dovecot 2.2 with dict SQL.

My config is using :

connect = host=10.111.5.1X host=10.111.5.1Y host=10.111.5.1Z dbname=mail user=quota_updater password=xxxxxxxx

But when an SQL server is down, I have these messages in logs :

dict: Error: mysql(10.111.5.1Y): Connect failed to database (mail): Can't connect to MySQL server on '10.111.5.1Y' (111) - waiting for 125 seconds before retry

Does Dovecot support HA / RR load-balancing in dict SQL, as in passdb/userdb ?

sadly no

postfix does and in case of all-inet it spreads even the usage while a localhost source is preferred and only if that is not available a fallback to a inet sql server happens

in case of postfix "hosts = inet:10.111.5.1X inet:10.111.5.1Y" would work as expected, no idea why you can configure different sql host in dovecot when no failover happens