MongoDB vs. Cassandra [closed]

by

Lots of reads in every query, fewer regular writes

Both databases perform well on reads where the hot data set fits in memory. Both also emphasize join-less data models (and encourage denormalization instead), and both provide indexes on documents or rows, although MongoDB’s indexes are currently more flexible.

Cassandra’s storage engine provides constant-time writes no matter how big your data set grows. Writes are more problematic in MongoDB, partly because of the b-tree based storage engine, but more because of the multi-granularity locking it does.

For analytics, MongoDB provides a custom map/reduce implementation; Cassandra provides native Hadoop support, including for Hive (a SQL data warehouse built on Hadoop map/reduce) and Pig (a Hadoop-specific analysis language that many think is a better fit for map/reduce workloads than SQL). Cassandra also supports use of Spark.

Not worried about “massive” scalability

If you’re looking at a single server, MongoDB is probably a better fit. For those more concerned about scaling, Cassandra’s no-single-point-of-failure architecture will be easier to set up and more reliable. (MongoDB’s global write lock tends to become more painful, too.) Cassandra also gives a lot more control over how your replication works, including support for multiple data centers.

More concerned about simple setup, maintenance and code

Both are trivial to set up, with reasonable out-of-the-box defaults for a single server. Cassandra is simpler to set up in a multi-server configuration since there are no special-role nodes to worry about.

If you’re presently using JSON blobs, MongoDB is an insanely good match for your use case, given that it uses BSON to store the data. You’ll be able to have richer and more queryable data than you would in your present database. This would be the most significant win for Mongo.

More Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. How to remove a field completely from a MongoDB document?
  3. Store images in a MongoDB database
  4. Is the IN relation in Cassandra bad for queries?
  5. Find duplicate records in MongoDB
  6. Best practice to maintain a mgo session
  7. How do you rename a MongoDB database?
  8. Where does mongodb stand in the CAP theorem?
  9. How do I do a “NOT IN” query in Mongo?
  10. How do you query for “is not null” in Mongo?
  11. MongoDB update with condition
  12. How to stop insertion of Duplicate documents in a mongodb collection
  13. Mongodb aggregation $group, restrict length of array
  14. Is mongodb running?
  15. Does MongoDB support floating point types?
  16. MongoDB normalization, foreign key and joining
  17. MongoDB Single Document size limit is 16MB
  18. Get a document in MongoDB without specifying collection
  19. Does MongoDB’s $in clause guarantee order
  20. Authentication failure while trying to save to mongodb
  21. How do I query for distinct values in Mongoose?
  22. How to query MongoDB to test if an item exists?
  23. Working with special characters in a Mongo collection
  24. MongoDB: output ‘id’ instead of ‘_id’
  25. MongoDB: Updating subdocument
  26. MongoDB: Calculate dwell time between every status value change
  27. How to export all collections in MongoDB?
  28. How to access overall document count during arithmetic aggregation expression
  29. SQL: Using NULL values vs. default values
  30. How to deal with the timezone issue when storing dates in utc using mongod?

Leave a Comment