Paul J Stevens пишет:
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.
It's possible to balance users between masters, so one user will always
connect to the same DB (including lmtpd), except when it's BD becomes
failed.
I don't see problems in such case.
Btw, does this break POP3?
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.
But it's possible to have holes, right? like 1,2,5,6,10,11
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.
As I understand, client just will not see new messages, which ids are
lower than the highest message id, until it reconnects?
Any other problems may occur?
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.
I tried to emulate this situation only with TB yet, and I didn't run in
any problem except I described.
So you can do it, but don't come complaining if users fail to retrieve messages
:-)
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
