Results 1 to 2 of 2

Thread: Db Mail Storage?

  1. #1
    darren1234 is offline Starter Member
    Join Date
    Oct 2005
    Posts
    2
    Rep Power
    9

    Default Db Mail Storage?

    Has anyone considered using MySQL for the email storage? Something like what www.dbmail.org is doing for the backend.

    While I have only spent a few minutes browsing the architecture, it seems that maintaining integrity between MySql, Ldap, and the filesystem may be a big job. Removing the filesystem as the storage may be an advantage.

  2. #2
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    We actually think the work we've done to ensure LDAP, MySQL, and the file system stay sync'd well worth it. Storing messages as MIME files in the file system is the most natural place for them, and provides better caching for variable message sizes than any database could. The messages(files) are for the most part write once; read many. All the expensive searches are performed against the metadata in MySQL or the indexes of Lucene; both of which are designed for these types of queries. So we feel we've made solid choices in our design.
    Last edited by KevinH; 10-05-2005 at 10:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  2. fresh install down may be due to tomcat
    By gon in forum Installation
    Replies: 10
    Last Post: 07-25-2007, 08:09 AM
  3. DynDNS and Zimbra
    By afterwego in forum Installation
    Replies: 30
    Last Post: 04-01-2007, 03:34 PM
  4. Tomcat broken after upgrade to 4
    By dotslashroot in forum Migration
    Replies: 13
    Last Post: 01-31-2007, 06:05 PM
  5. Mail not getting to mail boxes
    By ehults in forum Installation
    Replies: 5
    Last Post: 10-31-2005, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •