Mmm..
Sounds like it's time to hack away a litle...
Gues a tclscript with mysql would do the trick.. Pseudo code like:
//Update all id's not modulo10=0 assuming 10 servers.
foreach id ['select id from mainTable where id%10!=0'] {
update "all tables" id='local_autoinc' where id=$id
}
Crude, but would probably work, and would make sure that all ID's are
sequential and uniq.
Ques the optimal way would be to make dbmail-imap do something similar
at connectiontime, but
that will have to wait until I have the time.
Now I'm still just considering moving to DBMail from an old exim/courier
installation with maildir.
/Andreas
Paul J Stevens wrote:
Andy wrote:
Hi,
I was wondering if anyone have been using DBMail with MySQL 5.x, and if
so, have anyone tried the
multimaster functionality via autoincrement step + baseoffset
functionality to gain multimaster functionality ?
It would be realy interesting to have a multimaster setup with multiple
smtp & imap servers :)
Sorry to disappoint you, but it won't work. Or rather, it will work for pop3 but
not for imap.
For imap the message ids must be unique *and* ascending. And while uniqueness is
easily achievable in a multi-master setup, strict ascending-ness is not.
http://www.dbmail.org/dokuwiki/doku.php?id=unique_id_guid
