On Mon, 2007-12-24 at 13:48 +0100, Patrick de Ruiter wrote: > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 > > [email protected] > > https://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 [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
