Hi everyone, 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 ? Thank you.
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://dovecot.org/pipermail/dovecot/attachments/20140825/2c0628e3/attachment.sig>