dict SQL : HA / RR load-balancing ?

[Reindl Harald]

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>