Introducing ScyllaDB Open Source 3.1

ScyllaDB Open Source 3.1, an update to the open-source NoSQL database, introduces several enhancements aimed at improving performance and operational efficiency. ScyllaDB, which shares the Cassandra Query Language interface and horizontal scalability with Apache Cassandra, is engineered in C++ for high throughput and low latency, optimizing database node usage. The release supports Amazon EC2 I3en servers, offering high storage density, and introduces relocatable packaging to streamline software releases. Key features include the default use of the SSTable 3.0 format, support for local secondary indexes alongside global ones, and improvements in materialized view handling, which enhance query efficiency. The update also introduces a new per partition limit in CQL, the BYPASS CACHE feature for optimizing range scans, and enhancements to the ALLOW FILTERING command. Additionally, ScyllaDB sponsors a Linux kernel improvement to enhance network event handling, reflecting its commitment to the open-source community. Advanced tools like nodetool toppartitions and improved row-level repair mechanisms help manage data efficiently, addressing hot partitions and reducing unnecessary data transfers during repairs, thereby boosting performance.