Results 1 to 4 of 4

Thread: Message blobs in Mysql, easy replication?

  1. #1
    kbaker is offline Active Member
    Join Date
    Jan 2006
    Posts
    33
    Rep Power
    9

    Default Message blobs in Mysql, easy replication?

    So I see that the message store has been divided into metadata stored in mysql and the filessystem for the actual message. I understand that the decision to use the filesystem allowed for increased performance.

    I am wondering how hard it would be to store the message blobs in the MySql rather than in the file system. This would allow for a secondary hot backup server to be synced up by simply using the standard master/slave MySql replication.

    This concept has been tested in production for some time now by the developers of DBMail.org, another open IMAP server, but that uses MySQL exclusively for its message store.

    Any thoughts? I was thinking of this more as an optional configuration rather than a replacement of the current system.

    I am much more concerned with up time than speed so would be willing to take a performance hit to make this change.

  2. #2
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default blobs in mysql

    We've seen problems (eg data corruption) with that kind of data in mysql.

  3. #3
    kbaker is offline Active Member
    Join Date
    Jan 2006
    Posts
    33
    Rep Power
    9

    Default

    I've heard of similiar issues. However the developers at DBMail seem to have mafe it around the issue. I could chat with them about it.

    In the interest of curiousity, is the message store to the filesystem in just a few methods? or is it burried in the entire system? If it wouldn't be too hard I might just want to play around with it.

    I'll be digging into the code next week to get myself familiar, so will probably will just find it, but thought I'd ask

    Thanks,

    Kevin
    Last edited by kbaker; 02-01-2006 at 01:33 PM.

  4. #4
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default Blobs in the DB

    Quote Originally Posted by kbaker
    In the interest of curiousity, is the message store to the filesystem in just a few methods? or is it burried in the entire system? If it wouldn't be too hard I might just want to play around with it.
    Theoretically, you should just be able to implement a new subclass of com.zimbra.cs.store.StoreManager. Please let us know how it goes.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. MySQL Logger Replication Files
    By rsharpe in forum Administrators
    Replies: 0
    Last Post: 10-30-2006, 07:00 AM
  3. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  4. Replies: 4
    Last Post: 01-18-2006, 11:58 AM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

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