From owner-freebsd-questions@FreeBSD.ORG Tue Jun 22 00:32:49 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 0961516A4CF for ; Tue, 22 Jun 2004 00:32:49 +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 D471843D31 for ; Tue, 22 Jun 2004 00:32:48 +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 B7C6B69A3F; Mon, 21 Jun 2004 20:32:46 -0400 (EDT) Date: Mon, 21 Jun 2004 20:32:45 -0400 From: Bill Moran To: Chuck Swiger Message-Id: <20040621203245.1f0e7444.wmoran@potentialtech.com> In-Reply-To: <40D76DA3.9090809@mac.com> 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> 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 00:32:49 -0000 Chuck Swiger wrote: > Bill Moran wrote: > > It's the mailboxes themselves that are difficult to get. Best we've got right > > now is backing up the Cyrus mail folders using rsync ... but this is very time- > > consuming, and (thus) only done once a day. In order for it to be done right, > > Cyrus has to be shut down while it's backing up. > > Are you using mbox files rather than maildir-style mailboxes? No, I'm using Cyrus' native storage method. I don't quite understand the details of how it lays things out, but it seems to create a number of files for each folder, although not quite 1 per message. > The latter uses one-message-per-file, and ought to work *much* better both in > terms of performance and stability, and in terms of playing nice with the way > rsync wants to back things up. Doesn't really matter. Fact is, the mail directories are something on the order of 3G. No matter how efficiently I store them, rsync is not going to be able to back them up fast enough to hit the level of redundancy I'm shooting for. Although Maildirs might work a little better, since I wouldn't have to stop the IMAP server during backup. It takes about 30 minutes to rsync the system to the backup server right now. That's perfectly acceptable for nightly backup purposes. This is a 1.5Ghz with 256M RAM and 80G ATA 100 HDDs. If the system runs rysnc continuously 24/7, I still have 30mins old data. > [ I don't think that stuffing email into a database is a particularly good > idea since that means keeping large blobs of non-relational data floating > around, something that the filesystem can do a better job of handling... ] It's a good idea if I want real-time redundancy. I see where you're coming from, and it's true that a RDBMS isn't the best way to store emails. But, when you look at the features available, it's the best way for this circumstance. With something like Slony, I'd have real-time redundancy with (I'm expecting) only a minor performance drop. Although I can't be sure until I can put something together to test. Reliability is much more important than performance in this case. Who cares if their email takes and extra 60 seconds to deliver, as long as it doesn't get lost! If the email arrives fast, it's useless if the server fails and the email is lost because the SMTP server told the delivering server that it had arrived and then crashed before it could be backed up. -- Bill Moran Potential Technologies http://www.potentialtech.com