For my personal email, I have a habit of having the sql server down
for one reason or another. I just dump the sql tables to flatfiles on
the email server, and a script runs every 15min and checks for updates
if any exist. Works well.
Another method would be to just keep it sql, but dump the mysql tables
into sqlite tables that postfix/dovecot use.
Quoting Voytek voytek@sbt.net.au:
On Wed, September 28, 2011 6:47 am, Nick Rosier wrote:
My main concern was losing mails if the DB is unavailable but this isn't a problem; if the DB is unavailable Postfix will return a temporarily unavailable and the MTA should retry.
yes, that was also my biggest concern when I 1st looked at the issue, after several years of usage, it still remain my biggest concern
luckily, it's just a concern, never caused a problem, and, mail will queue up if there are issues