Jonathan Ellis

<p>As Cassandra&nbsp;<a href="http://www.sfgate.com/technology/businessinsider/article/10-Tech-Skills-That-Will-Earn-You-Over-100-000-5193599.php">continues to increase in popularity</a>, it's natural that more people will benchmark it against systems they're familiar with as part of the evaluation process. Unfortunately, many of these results are less valuable than one would hope, due to preventable errors.</p>

<p>Here are some of the most common mistakes to keep in mind when writing your own, or reading others'. Many of these apply more broadly than just Cassandra or even databases.</p>

<h3>Testing on virtual machines</h3>

<p>This one is actually defensible: if you deploy on VMs, then benchmarking on VMs is the most relevant scenario for you. So as long as you understand&nbsp;<a href="http://www.slideshare.net/eonnen/high-performance-network-programming-on-the-jvm-oscon-2012/62">the performance hit you're taking</a>, this can be a reasonable choice. However, care must be taken:&nbsp;<a href="http://blog.sematext.com/2013/04/22/ec2-neighbour-caught-stealing-cpu/">noisy neighbors</a>&nbsp;can skew results, especially when using smaller instance sizes. Even with larger instances, it's&nbsp;<a href="http://blog.scalyr.com/2012/10/16/a-systematic-look-at-ec2-io/">much more difficult than you think</a>&nbsp;to get consistent results.</p>

<p>As an alternative, consider using a "bare metal cloud" like Softlayer or Storm on Demand.</p>

<h3>Testing on shared storage</h3>

<p>Here we are firmly into antipattern territory. Modern databases are uniformly designed around scaling out across commodity hardware; shared storage will become your bottleneck sooner rather than later and will muddy the water considerably as you attempt to test scaling the database.</p>

<p>Amazon's EBS is particularly bad: the network adds significant latency, penalizing systems like Cassandra that care about durability, because they pay that latency hit twice: first to append to the commitlog, and later when flushing the sstables.</p>

<p><a href="http://aws.amazon.com/about-aws/whats-new/2012/07/31/announcing-provisioned-iops-for-amazon-ebs/">Provisioned iops</a>&nbsp;could help (although I have yet to see a benchmark that uses this), but&nbsp;<a href="http://perfcap.blogspot.com/2011/03/understanding-and-using-amazon-ebs.html">far better to stick with local storage</a>.</p>

<h3>Misconfigured disks</h3>

<p>There's not much point in testing a high-level system like a database if low level operations like random reads don't work. I've seen systems with readahead defaulting as high as 32MB -- meaning, if Cassandra requests a 1KB row, the kernel will actually do 32MB of disk i/o.</p>

<p>Do a sanity check: do you get reasonable numbers for dd and bonnie++? DataStax Enterprise's pre-flight check is also useful.</p>

<p>Follow the documentation on configuring disks. It's particularly important on spinning disks that the commitlog be on its own spindle or set of spindles to avoid contention with reads.</p>

<p>P.S. Of course you don't have swap enabled. Right?</p>

<h3>Inadequate load generation</h3>

<p>There are only two principles to doing load generation right:</p>

<ol>
	<li>Feed Cassandra enough work</li>
	<li>Generate the workload on separate machines</li>
</ol>

<p>That's it! But it's frequently done wrong, from the extreme case of a single-threaded client running on the same laptop as Cassandra, to more subtle problems with the Python Global Interpreter Lock. It seems that&nbsp;<a href="http://googleresearch.blogspot.com/2006/06/extra-extra-read-all-about-it-nearly.html">like binary search</a>, it's surprisingly difficult to build a good load generator. If possible, avoid the temptation of rolling your own and use something battle-tested. Reasonable options include:</p>

<ul>
	<li>cassandra-stress: shipped with Cassandra; as a rough rule of thumb you can expect to need one stress machine for every two nodes in your cassandra cluster (divided by replica count)</li>
	<li>stress-ng: a replacement for stress that is about twice as fast, so plan a 1:4 ratio of load:cassandra machines</li>
	<li>ycsb: a cross-platform nosql benchmarking tool, limited to simple tables and queries by primary key. Expect to need about a 1:2 ratio of ycsb workload generators to Cassandra machines.</li>
</ul>

<p>(Of course, only fairly coarse differences show up with simple synthetic benchmarks like these. We are working on a&nbsp;<a href="https://issues.apache.org/jira/browse/CASSANDRA-6572">workload recording tool</a>&nbsp;that will allow replaying a live workload from one cluster in a different one, which will be much more useful to test upgrades or performance tuning against real-world conditions.)</p>

<h3>Meager datasets</h3>

<p>Related to but distinct from load generation, it's tempting to benchmark with a small dataset because hey, it gets fast results! I've seen Cassandra benchmarked with as few as 100,000 rows. This just isn't enough to tell us anything interesting about the performance properties of modern systems.</p>

<p>There are a few inflection points that can tell you a lot about how a system will scale. One is when the dataset no longer fits in memory. Another is when the&nbsp;<em>indexes</em>&nbsp;no longer fit in memory. Smaller datasets may not be representative of what you will see as you push past those thresholds.</p>

<p>If you are impatient, you can artificially restrict the memory available to the system with&nbsp;<a href="http://aep.appspot.com/display/WRLEE1nbs0AAFIYGQjLCtLVRlyo/">something like this</a>, but the closer you can come to the real conditions your application will face, the more relevant the results will be.</p>

<h3>Measuring different things in different systems</h3>

<p>Particularly when comparing different products, it's important to take care that the same thing is being measured across the board. Some mistakes I've seen include</p>

<ul>
	<li>Comparing mongodb's non-durable write performance with Cassandra doing durable writes</li>
	<li>Comparing latency writing to Cassandra with latency buffering an HBase update locally (a&nbsp;<a href="https://github.com/brianfrankcooper/YCSB/pull/98">YCSB bug</a>)</li>
	<li>Comparing a Cassandra cluster (where each node can route requests) to a larger MongoDB cluster (with extra router nodes)</li>
</ul>

<h3>Poor benchmark hygiene</h3>

<p>The cluster should be reset in between benchmarking runs, including&nbsp;<a href="http://linux-mm.org/Drop_Caches">dropping the page cache</a>. Even when benchmarking pure inserts, data from earlier runs will "pollute" your results as&nbsp;<a href="https://www.datastax.com/documentation/cassandra/2.0/webhelp/index.html#cassandra/dml/manage_dml_intro_c.html">compaction</a>&nbsp;kicks in, so clean it out completely. (Of course it's legitimate to test compaction's effect on performance, but that should be done deliberately and not as part of bad hygiene.)</p>

<p>Tests against JVM-based systems like Cassandra need to be long enough to allow the JVM to "warm up" and JIT-compile the bytecode to machine code. cassandra-stress has a "daemon" mode to make it easy to separate the warm-up phase from results that you actually measure; for other workload generators, your best bet is to simply make enough requests that the warmup is negligible.</p>

<h3>Flouting best practices</h3>

<p>There are a lot of performance tuning dials available in both the JVM and Cassandra. These can be used to optimize performance for specific workloads&nbsp;<a href="http://tech.shift.com/post/74311817513/cassandra-tuning-the-jvm-for-read-heavy-workloads">as Shift recently illustrated so well</a>, but in general the defaults reflect the collective experience of the Cassandra community and improving upon them takes both understanding and effort.</p>

<p>I'm reminded of a benchmark that set the Cassandra row cache size equal to the entire JVM heap size, starving everything else of memory. I can only guess at the thought process that went into that: cache is good, so more cache must be better? In fact, the row cache is a fairly specialized structure that is disabled by default for good reason.</p>

<p>When in doubt, ask for a sanity check!</p>


How not to benchmark Cassandra

Jonathan EllisTechnology

Share

More Technology

Getting Started with DataStax Astra DB and Amazon Bedrock

Why You Can't Miss Cassandra Summit

Mitigate the OpenAI Debacle with Open Source and Cloud

Supercharge AI Assistants with Superagent and DataStax

NoSQL and Vector DB
for Generative AI,
Instantly, At Scale