From owner-freebsd-questions@FreeBSD.ORG Tue Jun 22 01:29:41 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4079216A4CE for ; Tue, 22 Jun 2004 01:29:41 +0000 (GMT) Received: from internet.potentialtech.com (h-66-167-251-6.phlapafg.covad.net [66.167.251.6]) by mx1.FreeBSD.org (Postfix) with ESMTP id 195D243D45 for ; Tue, 22 Jun 2004 01:29:41 +0000 (GMT) (envelope-from wmoran@potentialtech.com) Received: from working.potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id 5329269A39; Mon, 21 Jun 2004 21:29:40 -0400 (EDT) Date: Mon, 21 Jun 2004 21:29:39 -0400 From: Bill Moran To: Lucas Holt Message-Id: <20040621212939.6fff7b49.wmoran@potentialtech.com> In-Reply-To: References: <20040621132006.2b1a296f.wmoran@potentialtech.com> <20040621172520.3544d6fe.wmoran@potentialtech.com> <20040621214348.GB63857@happy-idiot-talk.infracaninophile.co.uk> <20040621175626.3e762448.wmoran@potentialtech.com> <40D76DA3.9090809@mac.com> <20040621203245.1f0e7444.wmoran@potentialtech.com> Organization: Potential Technologies X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386-portbld-freebsd4.9) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit cc: questions@freebsd.org Subject: Re: What's the best possible email failover solution X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Jun 2004 01:29:41 -0000 Lucas Holt wrote: > Keep in mind that storing mail in a RDBMS as a backup requires an > efficient method to restore mail into your mail server's format. I'm looking at RDBMS _being_ the native format. Dovecot has this on the TODO list, but it's low priority for that project. If we use SQL as the native storage, then we duplicate the config on both machines (i.e. the Postfix config and the IMAP server config) and in the case of hardware failure, we just switch IP addresses. That can even be automated to happen without manual intervention! > Would it be possible to have a second mail server internal to your > network that would receive copies of the mail from the primary mail > server to store them as a backup? This would be closer to real time > and for the most part would beat the 30 minute interval to do an rsync. > In addition, if the system proved reliable you could rsync the > secondary at night and not have the primary down at all. Doesn't really accomplish the goal. The point is to have the IMAP folders in two places at all times. That way, when a user deletes an email, its deleted in both places, when Postfix delivers an email, it's delivered to both places, if a user moves an email from one folder to another ... you get the idea. -- Bill Moran Potential Technologies http://www.potentialtech.com