Il giorno ven, 09/01/2009 alle 10.03 +0000, Jorge Bastos ha scritto: > one dbmail imap in a place, where the users will be around 20 users > accessing just one account. > In this server must exist a tool, so synchronize all email in this > email, with another imap server, for example 5 in 5 minutes. > The sync must be done in two ways, and MUST never create duplicates of > the same message.
If I understood well what you're trying to accomplish, the best solution is enabling mysql (circular) replication between the two sites. You can tell both mysql generate auto-increments' unique keys with steps of two instead of one and with another setting you can specify an offset for the auto_increment. That means that the first site will have everything in the DB indexed as 0, 2, 4, 6, 8 and so on, while the other one will have 1, 3, 5, 7, 9, 11 and so on. This way you can freely mix the two databases with mysql replication without any data colliding. For dbmail everything will be pretty much transparent. There's a very clear explanation of this here: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html The good thing is that as long there's connectivity the two places will be instantly aligned. If there's no connetivity things will just sit there waiting to realing. Magical, isnt'? Let me know if I understood well your problem.
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
