<story><title>NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak</title><url>http://www.networkworld.com/cgi-bin/mailto/x.cgi?pagetosend=/news/tech/2012/102212-nosql-263595.html</url><text></text></story><parent_chain></parent_chain><comment><author>karterk</author><text>I was part of a large migration that moved a significant amount of data from MongoDB to HBase recently. Along the way, I also spent significant time digging into Cassandra and Riak.&lt;p&gt;I appreciate the effort and intention behind this article, but for all practical purposes, such numbers are really not helpful. From experience, if you really want performance from HBase, you need to spend significant amount of time coming up with the right way to structure your data in HBase. To name a few:&lt;p&gt;* choosing the right row key that optimizes bulk scans&lt;p&gt;* setting optimum client and server caching based on the size of each row&lt;p&gt;* pre-splitting regions, and setting custom region sizes&lt;p&gt;You will also run into various cluster-related issues. Things don&apos;t really scale linearly as you add more nodes. You need to also consider maintenance, upgrades, backups, replication and so on.&lt;p&gt;If you want to choose a NoSQL (or for that matter any database), spend some time thinking about whether it fits your data model and your own understanding of the technology. Performance is rarely gained by simply switching a few knobs.</text></comment>
<story><title>NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak</title><url>http://www.networkworld.com/cgi-bin/mailto/x.cgi?pagetosend=/news/tech/2012/102212-nosql-263595.html</url><text></text></story><parent_chain></parent_chain><comment><author>jegoodwin3</author><text>Not sure I buy the paper&apos;s analysis.  They don&apos;t seem to know much about load testing -- they speak as though throughput is &apos;load&apos; (rather than the multiprogramming level) and don&apos;t computer Bandwidth - Delay products.&lt;p&gt;Also, rather than using M/M/1 or some reasonable analytic model, they deliberately trottled their request rates to hold throughput constant (thereby guaranteeing different loadings for different &apos;benchmarks&apos;)&lt;p&gt;Just reading the first graph, for example, and applying Little&apos;s Law, it&apos;s pretty evident that Cassandra was loaded more heavily than than the two MySQL systems, with HBASE and Riak trailing.&lt;p&gt;Looks like HBASE and Cassandra lead the pack to me, with different characterists for different purposes.&lt;p&gt;Advice to authors: buy a book by Neil Gunther.</text></comment>