The IMAP APPEND command will insert new messages. For example, my mail
client will put messages into my "Sent" folder on the IMAP server once
I've sent them.
-----------------------------------------------
Date: Thu, 16 Dec 2004 08:31:30 -0800
From: Angus Jordan <[EMAIL PROTECTED]>
To: Blake Mitchell <[EMAIL PROTECTED]>
Subject: Re: [Dbmail] DB questions
Blake,
My understanding is that IMAP only does updates on the database. Can
you describe to me a specific situation where there could be
corruption?
From what I can remember of the thread that was on the -dev list a few
months ago, the only issue they brought up and were discussing was the
idea of having two seperate database servers both running MTA software
and inserting into both of the seperate databases with *new messages*.
This was because the inserts are not kept ACID across a multi master
setup in MySql, and the auto_increment on the dbmail_messages table
may not take this into account.
Since the IMAP daemon would not be changing the message_idnr field,
wouldn't running the MTA software on only 1 database solve this issue
partially?
Thanks,
Angus
