Comparative Analysis of Pipeline Architecture, Resource Deployment, and Configuration for Cassandra API-Compatible Databases: ScyllaDB vs. Cassandra

Abstract This work builds a benchmarking pipeline for resource deployment, configuration input, and the evaluation of Cassandra and ScyllaDB performance. It investigates performance under different scenarios, workload types, and internal structures. Insights and future improvements are provided. Analysing comparisons of both databases, there were several notable differences between Cassandra and ScyllaDB. ScyllaDB demonstrated superior performance in production-ready materialized views, global secondary indices, lightweight transactions, change data capture, row-based data cache, and adaptive behaviour to real-world workloads. On the other hand, Cassandra exhibited advantages, such as a well-established size-tiered compaction approach and the ability to leverage existing Java Virtual machine (JVM) tuning techniques.