Sizing of Mysql vs Message store

[hillman]

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!

[Krishopper]

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.

[Rich Graves]

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."

[bonadio]

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

[mmorse]

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.

[bonadio]

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

[Klug]

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

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

[bonadio]

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

[mmorse]

Originally Posted by bonadio

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.