From owner-freebsd-questions@FreeBSD.ORG Sat Apr 9 21:33:30 2005 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 C225116A4CE for ; Sat, 9 Apr 2005 21:33:30 +0000 (GMT) Received: from pi.codefab.com (pi.codefab.com [199.103.21.227]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7624543D1F for ; Sat, 9 Apr 2005 21:33:30 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from localhost (localhost [127.0.0.1]) by pi.codefab.com (Postfix) with ESMTP id BB6135E16; Sat, 9 Apr 2005 17:33:29 -0400 (EDT) Received: from pi.codefab.com ([127.0.0.1]) by localhost (pi.codefab.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 77218-10; Sat, 9 Apr 2005 17:33:29 -0400 (EDT) Received: from [192.168.1.3] (pool-68-161-53-96.ny325.east.verizon.net [68.161.53.96]) by pi.codefab.com (Postfix) with ESMTP id 7CA0F5DA0; Sat, 9 Apr 2005 17:33:28 -0400 (EDT) Message-ID: <42584A22.9010209@mac.com> Date: Sat, 09 Apr 2005 17:33:22 -0400 From: Chuck Swiger Organization: The Courts of Chaos User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050319 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Doug Lee References: <20050409203727.GI4670@kirk.dlee.org> In-Reply-To: <20050409203727.GI4670@kirk.dlee.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at codefab.com cc: freebsd-questions@freebsd.org Subject: Re: Anyone ever consider a filesystem served by MySQL for mail folders? 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: Sat, 09 Apr 2005 21:33:30 -0000 Doug Lee wrote: > Ok, tell me if this is a totally awful idea, but it seems quite useful > to me, even if unusual... It's a totally awful idea. :-) > Is it practical to implement a mountable filesystem for mail archiving > whose contents are served by a MySQL (or other SQL) database? > Creating this is surely way beyond my level of expertise in FreeBSD, > and maybe even the full design is, but I imagine this much: > > The actual supporting database would include category strings for each > message (many-to-many). File names in the filesystem would be > category strings, so saving an email would file it in that category > (to save in several categories, resave to the corresponding names; > only one actual copy of the message would be saved). [ ... ] Using a database backend for mail storage and to provide fancy searching and the like is the architecture used to build Microsoft Exchange and Lotus Notes. The advantage is that users gets fancy searching. The disadvantage is that you need to provide around 4 times as much disk space for a DB-based mailstore as you would for a normal mbox/maildir style representation, you need to provide a lot more server horsepower, you need to continuously maintain and purge old mail from the database, and you end up with your mail buried in database tables, so heaven help you if the database becomes inconsistent and you need to recover. -- -Chuck