-----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. Cheers and season's greetings, Patrick de Ruiter !DSPAM:476fa9fc1522376806620! _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
