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