Results 1 to 9 of 9

Thread: Sizing of Mysql vs Message store

  1. #1
    hillman's Avatar
    hillman is offline Moderator
    Join Date
    May 2007
    Location
    Vancouver, Canada
    Posts
    75
    Rep Power
    7

    Default Sizing of Mysql vs Message store

    Hi,
    Does anyone have any stats for the size of their MySQL store (the ./db directory) vs their message store (./store) for fairly large ( > 1 TB) stores?

    I have a test server up now with 4gb of mail accumulated and the mysql store is 600mb in size. I'm starting to think about how much fast storage we're going to need once the message store is scaled up into the multi-terabyte range. Is it relatively linear?

    Thanks!

  2. #2
    Krishopper is offline Dedicated Member
    Join Date
    Dec 2006
    Location
    Minneapolis MN
    Posts
    775
    Rep Power
    9

    Default

    I don't have nearly 1TB, but on a machine with 2.0 GB in store (I do have compression enabled as well), and my db directory is 447 MB.

    I suppose it all depends on what you have for metadata (number of folders and accounts and such). The metadata for one user with one folder and 10 GB of mail will probably take considerably less space than 1,000 users with 100 folders and 10 MB of mail each.

  3. #3
    Rich Graves is offline Outstanding Member
    Join Date
    Jan 2007
    Location
    Minnesota
    Posts
    718
    Rep Power
    9

    Default

    I have 2500 users, most of them undergraduates. 610GB store (df -i says 9.7 million inodes), 6.5GB redolog, 15GB db/data, 128MB openldap-data, 940GB backup (default 1-month retention).

    I've got /opt/zimbra on a Compellent SAN, providing block-level HSM behind the scenes (which saves *a lot* of money, if you can bring yourself to trust Compellent's software -- there are a few other vendors with similar features), and /opt/zimbra/backup on a cheap SATA array on the other end of a 5km fiber link. The Compellent tells me that I've got about 100GB on FC RAID 10, 100GB on FC RAID5, and the rest on SATA RAID 5.

    I am not doing compression or HSM at the Zimbra level because the SAN takes care of that for me. I am not currently doing ZCS archive/discovery, though I will start enabling it "soon."
    Last edited by Rich Graves; 11-10-2007 at 12:33 PM.

  4. #4
    bonadio is offline Loyal Member
    Join Date
    Oct 2007
    Location
    Brazil
    Posts
    88
    Rep Power
    7

    Default

    Hello Rich

    Could you tell me what server size do you have to hold those 2500 users?
    Number of servers, memory, CPU

    Do you do antivirus/anti-spam on those servers using zimbra solution or third party?

    Thanks

  5. #5
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    20

    Default

    And just because I have to say it do be aware that the professional services dept has several tools available to calculate just about every possible ratio you can think of - though it's mainly aimed at larger installs.
    Last edited by mmorse; 11-11-2007 at 02:18 PM.

  6. #6
    bonadio is offline Loyal Member
    Join Date
    Oct 2007
    Location
    Brazil
    Posts
    88
    Rep Power
    7

    Default

    Hello mmorse

    Would they have any available specs about the size of a server able
    to handle 2000-3000 users, I found in the forum users with 200 users
    systems. Today we have 25.000 emails users and I was wondering
    the number of servers needed to accommodate those users with ZImbra.

    I know this is a difficult question but a system to 2000 - 3000 users
    would be a nice start.

    Thanks

  7. #7
    Klug's Avatar
    Klug is offline Moderator
    Join Date
    Mar 2006
    Location
    Beaucaire, France
    Posts
    2,292
    Rep Power
    13

    Default

    In this kind of setup, server(s) is (are) not really the problem, SAN is.

    http://www.zimbra.com/blog/archives/..._benchmar.html

  8. #8
    bonadio is offline Loyal Member
    Join Date
    Oct 2007
    Location
    Brazil
    Posts
    88
    Rep Power
    7

    Default

    Hi Klug

    I think the PDF from this link is not available

    http://www.zimbra.com/pdf/Zimbra%20S...0Benchmark.pdf

    I get a 404 error

    []s

  9. #9
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    20

    Default

    Quote Originally Posted by bonadio View Post
    Would they have any available specs about the size of a server able to handle 2000-3000 users, I found in the forum users with 200 users systems. Today we have 25.000 emails users and I was wondering the number of servers needed to accommodate those users with ZImbra.
    I know this is a difficult question but a system to 2000 - 3000 users would be a nice start.
    I assume that's 25,000? (25k vs 25) Yes, yes they would certainly be able to help.

    But some other important questions would include:
    - The mail quota's you plan on giving on the average? (as well as existing mailbox sizes)
    - Avg number of messages sent/received by those users per day?
    - Avg message size?
    - Avg attachment sizes? What percentage of your messages contain attachments?
    - Are you going to use NE and index attachments?
    - Avg active users in a day? And how many max simultaneous users do you need to support?
    - Are you totally starting from scratch on servers & storage or do you have something inplace?
    - etc etc

    You can contact sales@zimbra.com (or by the many other methods) for a custom quote as well.
    Last edited by mmorse; 11-12-2007 at 12:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mysql data store rebuild
    By ashelley in forum Administrators
    Replies: 3
    Last Post: 03-23-2010, 03:39 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. Message store hard links
    By bdbell in forum Migration
    Replies: 0
    Last Post: 05-22-2007, 06:14 AM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Message blobs in Mysql, easy replication?
    By kbaker in forum Developers
    Replies: 3
    Last Post: 02-08-2006, 11:43 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
  •