Linux or Windows?

[Kader Belbina]

This has probably been asked a bunch of times but I havn't found a
definitive answer.

I am currently working on a new web application that will pull data
from a big mongodb shard. Every day there will be about 20million new
documents being inserted, and lots of queries against it.

My two boxes just arrived that are going to make up my initial shard.
I anticipate having to add another box every 6months to 1year
depending on success. The specs are:

16gb ram
6 1TB Caviar Blacks Sata 6 in Raid 10
i7 2600 (3.8ghz sandybridge)

I am unsure on whether its best to deploy this on Windows Server 2008
RC2 or a linux setup. I am very comfortable with windows so would
prefer this but do I lose much stability / performance on windows?
What linux distro if any is recommended?

Many thanks for any help!

[Gaetan Voyer-Perrault]

I haven't seen any benchmarks comparing Windows vs. Linux for MongoDB performance.

That stated, people are definitely using MongoDB on Windows and I haven't seen any performance complaints either.

I would use whatever OS you're comfortable with.

> Every day there will be about 20million new documents being inserted, and lots of queries against it.

Based on the specs you've described, I don't think you have enough RAM in this boxes. MongoDB works best when at least the indexes can fit into RAM. (even better when indexes plus some data fit into RAM)

20M docs / day = 600M docs / month.

If you're using ObjectId as your only index, that index is going to take about 16 to 20GB for 600M docs. That's just one month of data with one index. You're planning to have 6 months of data and you're probably going to have more indexes if you plan to do heavy querying.

- Gates

--
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com.
To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.

[Kader Belbina]

Hmmmm, that RAM is an issue then :-O Will need to think of efficient
ways to index then and investigate.

Good to hear though that windows doesn't have any stability problems.

On Mar 29, 3:26 pm, Gaetan Voyer-Perrault <ga...@10gen.com> wrote:
> I haven't seen any benchmarks comparing Windows vs. Linux for MongoDB
> performance.
>
> That stated, people are definitely using MongoDB on Windows and I haven't
> seen any performance complaints either.
>
> I would use whatever OS you're comfortable with.
>
> > Every day there will be about 20million new documents being inserted, and
>
> lots of queries against it.
>
> Based on the specs you've described, I don't think you have enough RAM in

> this boxes. MongoDB works best when *at least* the indexes can fit into RAM.

[Andreas Jung]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kader Belbina wrote:

>
> I am unsure on whether its best to deploy this on Windows Server 2008
> RC2 or a linux setup. I am very comfortable with windows so would
> prefer this but do I lose much stability / performance on windows?
> What linux distro if any is recommended?

If you have the freedom: go with Linux. If weird things are happening,
you can eventually look at the sources and investigate and understand
misbehavior. On Windows you can't (wisdom by Richard Kreuter).

Linux distro: it does not matter.

- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJNkp/EAAoJEADcfz7u4AZjCwILv0wafvnZ4xr+B6gTdPnKkiQK
YpZvkUFtsYQw0eBCCaXoFDptYejG2Iq4d5vMWcvt54k0rmGdrhG/RsFE1joURMbK
p298rX7NvBonE54/ZhXQXtiLWB6oK1pJhYicfk9g5rL/sbbi4jyUmSYFxh0tqPj4
qOMHkxNXAuCPr7uyGIInjxcPhBU8AqwwnBwMBiZHZEG/dTR0qHTyIq7oBRFmnnx/
QTYBKM6NLx7TkEfPTdAn2FZSQpFU0erItjSkaPb7Mto9lkMKdzKn8okyCZS/4spj
QGY/q2FI8XQuJWThnvvedy2FT0/sQo1uxzJoeDFOoiQcUQ65ayLT81796qNjhjwM
33/hRZcA4liNmAAJSo2beb0gKsdlLD4m46CFjK4JNSdEdRe/55lekFKJqvx7AsSV
hM566p9HM+GaUaFP3CrrT6s7tip7QfwwaCQFOpdGNFrQAF2EuitsztamdNblG9HA
mWufF7LAXWQCLwMk8OtgmML7nJFpQuk=
=FSsV
-----END PGP SIGNATURE-----