Bokhan Artem wrote: > Answering to myself - with auto_increment_increment, > auto_increment_offset and mysql5 this works
Technically it will work, but you will break IMAP if you do. This has been discussed many times to great length on the list and the wiki: message ids in a mailbox *must* be strictly incremental or else imap clients will fail to retrieve messages. such strict incremental sequences are not guaranteed in a master-master replication setup: a message inserted on hostB can very well have a message id that is lower than the highest message id on hostA. It very much depends on the imap client being used. For some webmail clients it won't be a problem, but for outlook/thunderbird/osx-mail etc you are in for a world of hurt. So you can do it, but don't come complaining if users fail to retrieve messages :-) -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
