[Dovecot] Dovecot mysql replication

[Timo Sirainen]

I haven't replied to most of the threads recently. Anyway, after thinking about this, I'm thinking this kind of connection fallback handling isn't really Dovecot's job. A load balancer could be configured to do it just as well (whereas LB couldn't do actual load balancing for multiple sql servers, because Dovecot uses long running TCP connections).

On 29.5.2013, at 2.09, Noel Butler <noel.butler at ausics.net> wrote:

> But each additional link added to the chain, is one more point of
> failure, unless he's replied to OP privately I'm amazed Timo has ignored
> this, since its been brought up from time to time before, if he no
> longer plans on doing it, he should just say so, so people can look at
> complete alternatives, we are a long way passed early 1.2 series.
> 
> 
> On Sun, 2013-05-26 at 17:33 +0200, Daniel Parthey wrote:
> 
>> Edwardo Garcia wrote:
>>> Yes indeed, so it seem it does not do at all.
>>> For now we disable use two hosts, but thiz not optimum for network.
>> 
>> You might try to put mysqlproxy in between dovecot and your mysql cluster
>> and have dovecot connect to the failover proxy (or proxies) instead of
>> connecting the database directly.
>> 
>> mysqlproxy makes use of the lua scripting language, where you might
>> want to implement the failover or filter mechanisms you need.
>> 
>> Regards
>> Daniel
> 
>