Re:Introduction to MongoDB
by liuliu on Wednesday January 12, 2011 @05:39PM
(#2098022)
Just wonder who have hosted data that is larger than RAM with MongoDB, and what's the performance characteristics?
[ Parent
| on HN ]
This happened to Foursquare, and resulted in a lengthy outage. See http://groups.google.com/group/mongodb-user/browse_thread/th... for the full details (including why recovery took so long).
Re:Introduction to MongoDB
by ethangunderson on Thursday January 13, 2011 @12:15AM
(#2098936)
FWIW, Foursquare's situation was kind of unique. They have a need for all of their data to be in RAM. In most applications, you can define a working set of data. As long as you can keep that working set and indexes in RAM, you'll be fine.
I have not used mongodb for anything sensitive (just log and test analysis), but my experience is that while at least the index stays in ram, things go relatively well, and degrade much worse than mysql once it does not.
My experience with MongoDB (300GB database; most of which was insert-only, but some large chunk of it was being updated) under constant load was horrible: I would not go back there. I've since spent a lot of time learning more about PostgreSQL's implementation and figuring out how to tweak more performance out of it. At this point I no longer believe there is any benefit to using MongoDB at all.
Re:Introduction to MongoDB
by justinjenkins on Wednesday January 12, 2011 @09:51PM
(#2098625)
You could run into problems but one option to deal with this is to "scale out" to a larger number of machines and shard the data onto each separate machine (with their own RAM) as appose to one or two high RAM machines.
Re:Introduction to MongoDB
by throwaway1138 on Friday January 14, 2011 @02:30AM
(#2102867)
This bears repeating. Because MongoDB doesn't do joins, sharding is orders of magnitude easier than with an SQL system; if you run out of RAM, shard.