I've been talking about it a lot, but there hasn't been any work on it. The main problem is the requirement of the IMAP protocol to have a unique, persistent, incrementing, 32 bit number for each message in each mailbox. AFAIK, there's no guaranteed way of doing this in multimaster :-[
If you have worked out a method of being RFC compliant and multimaster, you will have many happy and thankful friends on this mailing list :-) Aaron ""David S. Madole"" <[EMAIL PROTECTED]> said: > I have recently installed DBMail and am interested in converting my machines > to it. > > Most of my other applications are based on a multi-master MySQL replication > setup for redundancy. As I know has been discussed here before, the use of > auto_increment poses a real problem for this, with key conflicts between > masters. > > I have done a quick change to db.c to use appliation-generated primary keys > based on the timestamp, a config-file based server id, the process id, and a > serial number. The arrangement works out that key values are steadily > increasing, but not directly sequential. Keys are values in the neighborhood > of 2^62. > > I have found some bugs in other code where assumptions have been made that > primary keys are relatively small numbers and are closely spaced, if not > sequential. I have started working on fixing what I have found but thought > it might be a good time to touch base with the developers and see if there > is other work underway on this and whether my approach is agreed with or if > there are better ideas. > > Also, are there other, bigger issues that I haven't thought of, either with > replication in general or with the key scheme. > > Thanks, > David > > > ____________________________________________________________________________ > This message is spam and virus free. Filtering solutions by http://omd3.com > Expert computer system support and development by http://baysidenetworks.com > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > --
