Benchmarking MongoDB vs ScyllaDB: Caching Workload Deep Dive

BenchANT conducted a detailed benchmarking study comparing the performance of MongoDB and ScyllaDB in handling caching workloads, focusing on throughput, latency, scalability, and cost-effectiveness. Using the YCSB Workload A with both uniform and hotspot request distributions, the study evaluated small, medium, and large database scaling sizes. The findings revealed that ScyllaDB consistently outperformed MongoDB by providing higher throughput and lower latencies across all configurations, achieving near-linear scalability and offering significantly more operations per dollar. In the uniform distribution tests, ScyllaDB's throughput reached up to 20 times higher than MongoDB, while the latency results showed ScyllaDB maintained lower read and update latencies. The study also included a long-running 12-hour benchmark, where ScyllaDB sustained stable performance compared to MongoDB, which experienced latency spikes. Additionally, ScyllaDB demonstrated superior insert performance, especially with larger datasets, and both databases showed increased throughput with weaker consistency settings, though ScyllaDB's improvements were more pronounced.