Performance report: Scylla vs Cassandra on low-end hardware
What to expect from Scylla’s performance on low-end hardware
These performance advantages stem from Scylla’s modern hardware-friendly and ultra-scalable architecture. As a result, Scylla’s performance grows as the hardware size grows.
Scaling both up and out offers many advantages: from simplified cluster management to access to generally better hardware and economies of scale. We will address those choices in detail in an upcoming blog post.
However, many users have compelling reasons to stay on low-end hardware, even if temporarily. It’s then fair to ask: How does Scylla fare against Cassandra in such scenarios?
We’ll show in this report that while Scylla’s performance edge over Cassandra is lower than what more powerful hardware would provide, Scylla keeps outperforming Cassandra in a wide range of scenarios even when weak hardware imposes itself as a bottleneck (see Table 1).
|Test||Cassandra 3.0.9||Scylla 1.6.1||Difference||Better is:|
|Time to populate||5h 21m 29s||4h 27m 19s||20%||lower|
|Time to compact||7h 32m||21m||21x||lower|
|Total quiesce time (populate and compact)||12h 43m||4h 48m||2.68x||lower|
|51,267 reads/second||124,958 reads/second||2.43x||higher|
|7,363 reads/second||6,958 reads/second||-5%||higher|
|5,089 reads/second||5,592 reads/second||9.8%||higher|
|Reads during writes||547 reads/second||920 reads/second||68%||higher|
(at 5,000 writes/second)
|130.3 milliseconds||11.9 milliseconds||10.9x||lower|
(at 10,000 writes/second)
|153.3 milliseconds||16.9 milliseconds||9.0x||lower|
(at 20,000 writes/second)
|199 milliseconds||20.3 milliseconds||9.8x||lower|
(at 30,000 writes/second)
|217.1 milliseconds||27.5 milliseconds||7.9x||lower|
Table 1: Summary of results obtained for all tests conducted in this benchmark
Test design: goals and overview
For all tests, each cluster consists of 3 server instances and clients querying a table set with a replication factor of 3, and consistency level of QUORUM.
To provide readers with a fair assessment of Scylla’s performance on low-end hardware under various scenarios, we divided this test into 4 different phases, executed in the following order:
- Populate: Add a fixed number of partitions to the database, with the goal of generating a data set much larger than memory.
- Read: Query a fixed number of partitions for a fixed amount of time. Three separate tests are conducted with different numbers of partitions, so that the workload is served entirely from memory, entirely from a disk with a Gaussian distribution providing some caching opportunities, and entirely from a disk with a uniform distribution providing little or no caching opportunities.
- Write latency: In the previous phases, we aimed at executing as many operations as possible, achieving peak throughput from the cluster. In this last phase, we will observe the cluster’s latency behavior under an increasing number of operations when both Scylla and Cassandra are sustaining the same throughput.
- Reads during writes: This phase combines writes and random reads simultaneously from different clients. The reads are distributed uniformly through the write range so that they’ll be served from the disk.
We ran both Cassandra and Scylla on Amazon EC2, using c3.2xlarge machines. These machines have 8 vCPUs placed on 4 physical cores and 16 GB of memory. That is a configuration that can easily be described in 2017 as “laptop specs.” All instances of the c3 class, including c3.2xlarge, have 2 local SSDs attached. Using the local SSDs in a RAID array is our recommendation on EC2 machines where local SSDs are available.
However, we do acknowledge that there are valid uses for EBS. Because the goal of this benchmark is to demonstrate Scylla’s behavior in low-end hardware, we will use the local SSDs in a RAID array for the commit log only, while keeping the data volume in an attached GP2 EBS volume, 3.4 TB in size. The choice of size is so that the volumes achieve the maximum IOPS per volume of 10k IOPS.
We have used a single volume to match conditions we often see in the field. For production deployments using EBS, we recommend using as many disks as possible in a RAID configuration, up to the 65k IOPS per-instance maximum that AWS advertises.
Loaders: 3 x m4.2xlarge (8 vCPUs) writing to a disjoint set.In this phase we write 810,774,192 unique partitions separated equally over the 3 loaders and measure the time each cluster takes to complete it. Table 2 summarizes the results (lower is better), including high-percentile latencies. The times reported for both population and quiesce is the time when the last client finishes, and the latency reported is the highest of the 3 loaders for each percentile during data ingestion.
|Population time||Total time to quiesce||Population time||Total time to quiesce|
|19,289 seconds||46,409 seconds||16,039 seconds||17,299 seconds|
|lat 95th||lat 99th||lat 99.9th||lat max||lat 95th||lat 99th||lat 99.9th||lat max|
Table 2: Cassandra and Scylla’s population phase. Latency (ms) during ingestion reported is higher of each of the 3 clients at each percentile
Cassandra takes 20% more time than Scylla to insert the data. However, note that Cassandra has a setting that limits the compaction throughput so that it doesn’t influence write workloads, which is set to the default value of 16.
Scylla has no such option and auto-tunes itself and uses its Workload Conditioning techniques to make sure a compaction backlog, which is undesirable for reads, is not created. So Scylla is faster even when compactions are running at full speed.
Because of that, after the population phase is done Scylla finishes all remaining compactions in around 21 minutes. The same task in Cassandra takes around 7:32 hours. As Cassandra throttles its compactions, a massive backlog is created, hurting concurrent reads, and hampering Cassandra’s ability to compact faster during idle periods without human intervention.
To reflect that, we’ll report the “Total time to quiesce”, defined as the time between the population phase start and the time where all activity ceases. We will show in the “reads during writes” phase how a growing compaction backlog has a very real impact in performance.
The graph in Figure 1 shows a plot of cluster throughput (yellow) versus aggregate number of active compactions over time (green). The plot is generated by Scylla’s monitoring stack. As the load finishes, compactions are already far ahead on their way to completion.
Figure 1: Scylla finishes all pending compactions 21 minutes after the load finishes
In comparison, Figure 2 shows the AWS monitoring panel for the Cassandra nodes. During and after the ingestion period, users would face a massive compaction backlog.
Figure 2: Cassandra finishes all pending compactions 7:32 hours after the load finishes
We believe that the amount of tuning involved in a typical Cassandra cluster operation is way too large and makes it hard to adapt to changing circumstances. That factor is the drive behind our continuous work to make Scylla self-tuning. Still, for fairness, after all the tests were done we executed the ingestion test for Cassandra again, this time disabling compaction throttling (Cassandra was stopped, data were removed, and caches were dropped).
Figure 3 shows the results we obtained. Cassandra is able to take advantage of being idle now, with an initial burst that very likely already merged a lot of sstables for the first size tier into larger ones, which will greatly help reads. Still, that takes 2 hours. The total compaction time gets reduced by 25% to 6 hours, a far cry from Scylla’s 21-minute compaction.
Figure 3: Cassandra gets better if compactions are unthrottled, with the total time to compact all data being reduced to 6 hours, from the previous 7:32 hours
Loaders: 3 x m4.2xlarge (8 vCPUs) randomly reading partitions
All 3 phases in the read test were done after both Cassandra and Scylla finishes their compactions.
For the small dataset read phase we queried the partitions according to a Gaussian distribution centered at the mean with stdev=10k partitions. The goal is to demonstrate the performance of both Cassandra and Scylla serving a dataset that is highly likely to fit in memory. The small number of cores will be a limiting factor, but EBS will not. After an initial warm-up, this workload will not use the disk at all, and will run for 20 minutes.
For the medium-size dataset read phase, we will query randomly according to a gaussian distribution centered at the mean with stdev=100M. This dataset size is chosen to be at least twice as big as the memory size, but it is small enough so that cache locality considerations will come into play. This phase will run for 60 minutes.
For the large dataset read phase, we will query randomly according to a uniform distribution spanning the whole range of keys. This dataset should reduce locality considerations of cache to a minimum and stress the EBS volumes to its maximum. This phase will run for 60 minutes.
Scylla’s throughput in the small dataset is 2.5 times higher than Cassandra’s.
In the medium and large dataset tests, EBS is the limiting factor for both Scylla and Cassandra, and the disk throughput stays at its 10k IOPS peak during the whole test. The results in this situation are less conclusive, with Scylla performing 9.8% better than Cassandra for uniform reads over the entire dataset, and Cassandra performing 5% better than Scylla for Gaussian reads.
The similarity of the disk-bound results is expected from a situation in which hardware is a bottleneck, but it does show some opportunities for improvement in Scylla that we are already working to resolve. However, one needs to keep in mind that this test was done with the cluster quiet, after all compaction work was done. We believe a more realistic scenario involves reading concurrently to writes. That will be done in the “reads during writes” phase.
Loaders: 1 x m4.2xlarge (8 vCPUs) writing at a fixed rate
In the previous tests, we focused on the throughput the system can achieve. However, most real-life systems operate at or close to a steady rate and will try to stay away from their maximum capacity. It is then interesting to focus on the latency of requests at a steady rate.
We ran a single loader, rate limited at 5k, 10k, 20k and 30k writes/second respectively. All of these are below the maximum throughput of both Scylla and Cassandra, as observed during population. Each run lasted for 30 minutes. We executed nodetool flush between each run. After the flush, the system was allowed to quiesce before the next run started.
Table 3 summarizes the results. Scylla is clearly ahead, providing latencies up to 10 times better than Cassandra at high percentiles. That’s easy to see in both Figure 4, which shows the mean latencies for all throughput tested and Figure 5, which shows the 99.9th percentile.
Table 3: Latency percentiles (ms) at a fixed throughput.
Figure 4: Mean latencies in Scylla versus Cassandra
Figure 5: 99.9th percentile latencies for Scylla and Cassandra
Reads during writes phase
Loaders: 2 x m4.2xlarge (8 vCPUs) split into one writer, one reader.
As we noted in the population phase, even at a lower rate of writes, Cassandra can’t keep up with compactions, taking 7:32 hours to fully compact after the load finishes, far more than Scylla’s 21 minutes.
As users running real workloads know, this result is much more than a benchmarking artifact. Not being able to compact fast enough impairs the cluster’s ability to serve reads and is particularly harmful for read latencies.
To assess the impact a compaction backlog have in a concurrent read workload, we have loaded each cluster with a constant rate of 30k writes/second to for a period of 4 hours. The writes focus on a specific subset of the population range (10M keys), and the rate is determined based on the results of the population phase to be challenging enough for the clusters to handle, without saturating them.
After roughly 3 hours (1000 seconds), we fire a latency-oriented, workload from another loader, using only 40 threads. The reads, however, are random and spread throughout the whole range, forcing them to be served from the disk.
The results of this test appear in Table 4:
|Throughput||547 reads/second||920 reads/second||68 %|
|latency mean||10.7 milliseconds||10.9 milliseconds||-1.83 %|
|latency 95th||30.8 milliseconds||23.9 milliseconds||28.9 %|
|latency 99th||130.5 milliseconds||31.2 milliseconds||4.2 x|
|latency 99.9th||250.5 milliseconds||42.9 milliseconds||5.8 x|
|latency max||5711.3 milliseconds||517 milliseconds||11 x|
Table 4: Cassandra versus Scylla reading during write load.
In this situation, Scylla can serve the reads 68% faster than Cassandra with much improved tail latencies. Looking at nodetool cfhistograms can help us understand part of the reason why. One of the servers shows, at 99% Cassandra is reading from 20 SSTables while Scylla is reading from only 6. At max, Cassandra reads from 29 SStables while Scylla reads from 14.
keyspace1/standard1 histograms Percentile SSTables Write Latency Read Latency Partition Size Cell Count (micros) (micros) (bytes) 50% 1.00 20.50 3379.39 258 5 75% 1.00 20.50 5839.59 258 5 95% 3.00 35.43 14530.76 258 5 98% 4.00 42.51 25109.16 258 5 99% 20.00 42.51 43388.63 258 5 Min 1.00 3.97 126.94 180 5 Max 29.00 268650.95 268650.95 258
keyspace1/standard1 histograms Percentile SSTables Write Latency Read Latency Partition Size Cell Count (micros) (micros) (bytes) 50% 1.00 14.00 1597.00 310 5 75% 1.00 14.00 8239.00 310 5 95% 3.00 24.00 14237.00 310 5 98% 4.00 29.00 17084.00 310 5 99% 6.00 35.00 20501.00 310 5 Min 0.00 3.00 21.00 259 5 Max 14.00 152321.00 219342.00 310 5
Note that because we are only writing to a subset of the data, the problem is pushed to the higher percentiles; data that is read from outside that range should be resolved by 1 SSTable only, assuming the Bloom Filters work well (they usually do). For larger datasets involving many rewrites, it’s easy to see that Scylla’s advantage would increase.
Writing to the entire range multiple times would take this test too long, so we capped it. But this situation happens routinely in many real deployments.
While it is true that Scylla shines the brightest when executed on high-end server hardware grows in power, this benchmark demonstrates that Scylla’s advantage over Cassandra is not restricted to high-end environments.
Hardware is becoming cheaper and bigger. This trend is exemplified by AWS’ recent release of the i3 server class with up to 64 vCPUs and 16 GB/s of NVMe disk throughput, which Scylla will soon support. We believe that users will benefit from easier maintenance and fewer failures with fewer, larger nodes. However, Scylla consistently outperforms Cassandra even in situations with constrained resources.
At peak throughput, Scylla is able to handle data ingestion faster than Cassandra, and it does so at lower high percentile latencies without creating a compaction backlog or requiring manual tuning of compaction rates. When compared at an equivalent rate lower than the point of saturation, Scylla is able to maintain latencies that are more consistent and up to 10 times lower than Cassandra for the 99.9th percentile.
In the absence of competing writes, reading from memory in Scylla is 2.5 times faster than Cassandra, while reading datasets entirely from disk will provide similar results for both databases. However, for many workloads this is an unrealistic scenario, as reads happen while data is being ingested. When that’s the case, Scylla’s ability to compact data faster puts Scylla ahead by 68% even if the workload is served from the disk.
For this test, we tested DataStax Community Edition, based on Cassandra 3.0.9. We configured the Cassandra VMs in accordance with the official Datastax guide that can be found herehttps://docs.datastax.com/en/landing_page/doc/landing_page/recommendedSettingsLinux.html, optmizing for SSDs.
Also in accordance with that guide, we set the JVM Garbage collector to G1GC. because the document doesn’t specify the exact G1GC settings, we picked the following:
-XX:+UseG1GC -XX:G1RSetUpdatingPauseTimePercent=5 -XX:MaxGCPauseMillis=500 -XX:InitiatingHeapOccupancyPercent=70 -XX:ParallelGCThreads=8 -XX:ConcGCThreads=8
Also, we made changes to the Cassandra yaml file; some based on the comments present in the file while others based on [Al Tobey’s guide to Cassandra tuning](https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html). Although the guide is written with Cassandra 2.1 in mind, we found the changes to be still relevant.
A summary of the changes follow:
memtable_allocation_type: offheap_buffers trickle_fsync: true concurrent_reads: 16 concurrent_writes: 64 concurrent_counter_writes: 16 disk_optimization_strategy: ssd concurrent_compactors: 8
For this benchmark, we used the official ScyllaDB 1.6.1 AMI. We made no changes to the Scylla configuration file because Scylla is supposed to automatically adapt to changing circumstances.
However, two automatic configuration issues affecting c3.2xlarge exclusively failed to be made to Scylla and had to be manually adjusted. We are working to fix [this issue] (https://github.com/scylladb/scylla-ami/issues/21) as we strive to provide a setup-free experience across all kinds of hardware.
Users of c3.2xlarge can bypass these issues by applying the following changes:
# adjust the correct cpuset for Scylla echo CPUSET=\"--cpuset 1-7\" | sudo tee /etc/scylla.d/cpuset.conf # manually configure Scylla’s networking sudo sh /usr/lib/scylla/posix_net_conf.sh -sq # prevent the wrong network configuration to be applied on Scylla’s startup. sudo sed -i "s/SET_NIC=yes/SET_NIC=no/" /etc/sysconfig/scylla-server
In addition to those changes, the official Scylla 1.6.1 [does not recognize attached EBS devices](20](https://github.com/scylladb/scylla-ami/issues/20), and will create a RAID array with all available devices at /var/lib/scylla. We manually undid that and then mounted the EBS device at the data location, and a RAID array with the local SSDs at the commitlog location.
Commands used and raw results
Here’s a list of all stress commands used at each phase. Shown below are the Scylla versions. Cassandra differs on IP addresses and log file names only.
cassandra-stress write n=270258064 cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=540516129..810774192 \ -node 172.30.0.205,188.8.131.52,172.30.0.228 \ -rate threads=800 -log file=Scyllareplica3mar22017.data cassandra-stress write n=270258064 cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=270258065..540516128 \ -node 172.30.0.205,184.108.40.206,172.30.0.228 \ -rate threads=800 -log file=Scyllareplica3mar22017.data cassandra-stress write n=270258064 cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..270258064 \ -node 172.30.0.205,220.127.116.11,172.30.0.228 \ -rate threads=800 -log file=Scyllareplica3mar22017.data
cassandra-stress write duration=30m cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..810774192 \ -node 172.30.0.205,18.104.22.168,172.30.0.228 \ -rate threads=800 limit=5000/s\ -log file=testlim5k_ScyllaC32xlMar22017.data cassandra-stress write duration=30m cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..810774192 \ -node 172.30.0.205,22.214.171.124,172.30.0.228 \ -rate threads=800 limit=10000/s\ -log file=testlim10k_ScyllaC32xlMar22017.data cassandra-stress write duration=30m cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..810774192 \ -node 172.30.0.205,126.96.36.199,172.30.0.228 \ -rate threads=800 limit=20000/s\ -log file=testlim20k_ScyllaC32xlMar22017.data cassandra-stress write duration=30m cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..810774192 \ -node 172.30.0.205,188.8.131.52,172.30.0.228 \ -rate threads=800 limit=30000/s\ -log file=testlim30k_ScyllaC32xlMar22017.data
cassandra-stress read duration=20m cl=QUORUM -mode native cql3 -pop dist=gaussian\(1..810774192,405387096,10000\) \ -node 172.30.0.205,184.108.40.206,172.30.0.228 \ -rate threads=400 \ -log file=testreadsmall_Scylla_C32xlMar22017.data cassandra-stress read duration=60m cl=QUORUM -mode native cql3 -pop dist=uniform\(1..810774192\) \ -node 172.30.0.205,220.127.116.11,172.30.0.228 \ -rate threads=400 \ -log file=testreadlarge_Scylla_C32xlMar22017.data cassandra-stress read duration=60m cl=QUORUM -mode native cql3 -pop dist=gaussian\(1..810774192,405387096,100000000\) \ -node 172.30.0.205,18.104.22.168,172.30.0.228 \ -rate threads=400 \ -log file=testreadmedium_Scylla_C32xlMar22017.data
Reads during writes:
cassandra-stress read duration=60m no-warmup cl=QUORUM -mode native cql3 -pop dist=uniform\(1..810774192\) \ -node 172.30.0.205,22.214.171.124,172.30.0.228 \ -rate threads=10 -log file=testmixed_read.data cassandra-stress write duration=4h cl=QUORUM -schema "replication(factor=3)" -mode native cql3 -pop seq=1..10000000\ -node 172.30.0.205,126.96.36.199,172.30.0.228 \ -rate threads=800 limit=30000/s\ -log file=testmixed_write30k.data
The complete list, together with the raw results achieved by each loader can be found here.