RE: enormous DB Traffic using imapsync

-----Oorspronkelijk bericht-----
Van: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] Namens
Aaron Stone
Verzonden: vrijdag 21 december 2007 19:17
Aan: DBMail mailinglist
Onderwerp: Re: [Dbmail] enormous DB Traffic using imapsync


On Fri, 2007-12-21 at 15:42 +0100, Marc Dirix wrote:
> > > Hmm,
> > > Looks like you guys should consider mysql
clustering, this should  
> > > resolve
> > > most of these kind of troubles.
> > >
> >
> > MySQL clustering is like trying to create an
industrial robot with  
> > LEGO mindstorms.
> > 
> > Also the serial problem, of having inserts at
multiple locations is  
> > not solved using clustering.
>
> The serial problem _is_ solved for MySQL with just the
simple hack of
> offsets and increment amounts -- but the IMAP problem
is not. IMAP
> effectively requires an auto increment column of its
own and does not
> support these types of hacks around the message id
number.
>
> Aaron
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Hi Aaron,
There must be a way to solve this issue, however since I'm
not a software
programmer and not a MySQL guru either, I can't come up with
a working
solution but maybe I can suggest some ideas.

Isn't it possible to ad a configuration option to DBMail
that will enable
you to insert a unique identifier in the message ID for each
machine that
run's DBMail, let's say the first two or three digits of the
message id,
this should resolve any issues with message id's even if you
have duplicate
ID's the first digits will always differ cause they were
received by a
different machine.
Maybe I'm completely wrong here, but this sounds like a sane
solution to me.

Cheers and season's greetings,
Patrick de Ruiter







!DSPAM:476fa9fc1522376806620!


_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Mon, 2007-12-24 at 13:48 +0100, Patrick de Ruiter wrote:
> -----Oorspronkelijk bericht-----
> Van: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] Namens
> Aaron Stone
> Verzonden: vrijdag 21 december 2007 19:17
> Aan: DBMail mailinglist
> Onderwerp: Re: [Dbmail] enormous DB Traffic using
imapsync
> 
> 
> On Fri, 2007-12-21 at 15:42 +0100, Marc Dirix wrote:
> > > > Hmm,
> > > > Looks like you guys should consider
mysql clustering, this should  
> > > > resolve
> > > > most of these kind of troubles.
> > > >
> > >
> > > MySQL clustering is like trying to create an
industrial robot with  
> > > LEGO mindstorms.
> > > 
> > > Also the serial problem, of having inserts at
multiple locations is  
> > > not solved using clustering.
> >
> > The serial problem _is_ solved for MySQL with just
the simple hack of
> > offsets and increment amounts -- but the IMAP
problem is not. IMAP
> > effectively requires an auto increment column of
its own and does not
> > support these types of hacks around the message id
number.
> >
> > Aaron
> >
> > _______________________________________________
> > DBmail mailing list
> > DBmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> Hi Aaron,
> There must be a way to solve this issue, however since
I'm not a software
> programmer and not a MySQL guru either, I can't come up
with a working
> solution but maybe I can suggest some ideas.
> 
> Isn't it possible to ad a configuration option to
DBMail that will enable
> you to insert a unique identifier in the message ID for
each machine that
> run's DBMail, let's say the first two or three digits
of the message id,
> this should resolve any issues with message id's even
if you have duplicate
> ID's the first digits will always differ cause they
were received by a
> different machine.
> Maybe I'm completely wrong here, but this sounds like a
sane solution to me.

This issue has been discussed fully and debated to death
several times.
This is a good idea for uniqueness, but it won't work at all
for IMAP
due to protocol restrictions and client behavior. Please
search the
mailing list archives for dbmail and dbmail-dev to find
discussion
threads (there are _many_!) on this topic if you would like
further
details.

Cheers,
Aaron

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail