[Dovecot] Dovecot mysql replication

[Nick Edwards]

+1

On 5/30/13, Edwardo Garcia <wdgarc88 at gmail.com> wrote:
> As  oringanal poster, I agree with previouz comment, I too feel thiz
> dovecot responsibile for thiz work handoff, or should delete ability to use
> two host, people twitter I ask all along thought this how it work too!
>
>
> On Wed, May 29, 2013 at 6:29 PM, Reindl Harald
> <h.reindl at thelounge.net>wrote:
>
>> so better remove the option to specify more than one host
>> instead let people run over years in troubles until they
>> find out that a logical behavior like for postfix is not
>> given for dovecot's mysql-connections - yes i was one of
>> the who thought "hey both works the same way" until
>> i realized that dovecot has no fun at reboot the replication
>> slave which was intented only as failover and used regulary
>>
>> *it is* dovecots job if it offers more than one host
>> to handle this in a useful way or not support more than
>> one host, but you can't seriously say "it's not dovecots job"
>> after having a half-baken support implemented
>>
>> Am 29.05.2013 02:52, schrieb 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
>>
>>
>