ScyllaDB Open Source 3.3

ScyllaDB Open Source 3.3 introduces a rich set of new production-ready features for IPv6, LIKE operators, as well as experimental features such as Lightweight Transactions (LWT), Change Data Capture (CDC) and a DynamoDB-compatible API. Already the industry’s most performant NoSQL database, ScyllaDB Open Source includes features beyond the capabilities of Apache Cassandra and DynamoDB.

ScyllaDB Open Source 5.x is here!
Beyond the features listed below, we have a whole new set of capabilities and enhancements with the release of ScyllaDB Open Source 4.x and ScyllaDB Open Source 5.x.

DISCOVER SCYLLADB OPEN SOURCE 5.X

New in ScyllaDB Open Source

User Defined Functions (UDF) in Lua (Experimental in ScyllaDB Open Source 3.3)

ScyllaDB User Defined Functions (UDF) with the Lua language adds the ability for developers to deploy server-side scripts to perform data transforms such as aggregations, sums and averages. This simplifies complex queries for developers who need fast and easy streamlined queries that fit their service’s data-model.

Lightweight Transactions (LWT) (Experimental in ScyllaDB Open Source 3.2)

This feature allows you to track changes made to a base table in your database for visibility or auditing. Changes made to the base table are stored in a separate table that can be queried by standard CQL. Our CDC implementation uses a configurable Time To Live (TTL) to ensure it does not occupy an inordinate amount of your disk.

DynamoDB-compatible API (Project Alternator) (Experimental in ScyllaDB Open Source 3.2)

Our Amazon DynamoDB-compatible API implementation, known as Project Alternator, enables you to connect your DynamoDB applications to ScyllaDB without any changes to your client code. This gives you the multi-cloud, multi-vendor flexibility you need for resiliency and disaster recovery.

CQL LIKE Operator (New in ScyllaDB Open Source 3.2)

ScyllaDB’s LIKE operator allows wildcard pattern searches. It supports both single character or string wildcards, and also verbatim and empty field matches. These additional operators mean that you can create queries on ScyllaDB you cannot make in Cassandra. Also unlike Apache Cassandra, ScyllaDB’s LIKE operator is not reliant on SSTable Attached Secondary Indexes (SASI).

Internet Protocol version 6 (IPv6) (New in ScyllaDB Open Source 3.2)

This feature allows database administrators to escape the limitations of the Internet Protocol version 4 (IPv4) 32-bit address space established back in the 1980s. IPv4 was limited to about 4.3 billion devices on the Internet. IPv6 uses 128-bit addresses allowing 3.4×10³⁸ addressable devices. This enables and facilitates the continued expansion of data networks.

Improved Repair via RPC Streaming (New in ScyllaDB Open Source 3.2)

Rebuilding a failed node is a non-trivial operation. It requires decommissioning the old node, spinning up a new one, and streaming data from the replicas to bring the new node up to speed. ScyllaDB’s RPC streaming mechanism makes it more efficient to transfer large amounts of data, cutting time-to-rebuild dramatically.

Materialized Views (New in ScyllaDB Open Source 3.0)

Creates a persistent table that is a subset of a base table, using different keys and thus accelerating the search. The view and the base consistencies are managed by ScyllaDB automatically. Materialized Views are now fully production ready in ScyllaDB 3.0, while still experimental in Apache Cassandra.

Global and Local Secondary Indexes (New in ScyllaDB Open Source 3.0 and 3.1)

Global Secondary Indexes (GSI) allows you to query data through non-primary key columns, minimizing the amount of data retrieved from the database and resulting in faster interactions. GSI is compatible with Apache Cassandra; however, with ScyllaDB the index is cluster-global and search does not depend on the size of the cluster. An enhancement added in ScyllaDB Open Source 3.1, Local Secondary Indexes (LSI) allows ScyllaDB to optimize workloads where the partition key of the base table and the index are the same key.

AWS i3en Instance Support (New in ScyllaDB Open Source 3.1)

ScyllaDB Open Source 3.1 is now supported on the AWS i3en instances, where each node can store up to 30TB of data. Significantly larger databases can now be created, simplifying development, deployment and enhancing user experiences.

Row Level Repair (New in ScyllaDB Open Source 3.1)

Speeds up repairs by working at the row level. This significantly reduces the time for repairs and lowers the volume of data that needs to be transferred between nodes when repairs are needed.

Allow Filtering (New in ScyllaDB Open Source 3.0)

Get more query flexibility by appending queries with ALLOW FILTERING to bypass some Cassandra query restrictions. Designed for low-selectivity queries, the ALLOW FILTERING command can be executed on regular and primary key columns, reducing the network traffic back to the client and resulting in better application performance.

SSTable 3.0 Compatibility (New in ScyllaDB Open Source 3.0)

Now compatible with the latest Apache Cassandra file format (SSTable “mc”), which results in less disk space used and improved performance. The storage volume is reduced by as much as 3X.

Hinted Handoff (New in ScyllaDB Open Source 3.0)

Automatically recover intermediate failures by storing up to 3 hours of untransmitted data between nodes. This improves consistency and reduces the repair time and amount of work, resulting in higher overall performance for large clusters.

Multi-Partition Scan Improvement (New in ScyllaDB Open Source 3.0)

Increases system responsiveness and efficiency by improving locality and caching of range scans. This feature increases the throughput of range scans by 30%, reduces the amount of data read from the disk by 40% and lowers disk operations by as much as 75%.

Streaming Improvements (New in ScyllaDB Open Source 3.0)

Boost the speed of auto-scaling the cluster as well as replacing faulty nodes. These improvements result in higher performance for the overall system when there is a change in the cluster topology.

Resources

ScyllaDB Open Source Release 3.2

Get more details on the latest release of our highly performant open source NoSQL database.

Lightweight Transactions in ScyllaDB vs Apache Cassandra

ScyllaDB VP of Product Tzach Livyatan and Software Team Lead Konstantin Osipov introduce the ScyllaDB implementation of Lightweight transactions (LWT).

ScyllaDB Alternator: The Open Source DynamoDB-compatible API

Our open source Amazon DynamoDB-compatible API allows you to run your database on any cloud or on premises.

Change Data Capture in ScyllaDB

Take a deep dive into Change Data Capture (CDC) in ScyllaDB, and how it compares to Apache Cassandra in this engineering talk from our ScyllaDB Summit.

ScyllaDB Unveils Highly Anticipated Features for High-Performance NoSQL Database

Read our press release announcing ScyllaDB Open Source 3.2 from our ScyllaDB Summit last fall

IPv6 Address Configuration

Read the documentation on how to configure client-to-node and node-to-node IPv6 addresses in ScyllaDB.

ScyllaDB University

Get started on the path to ScyllaDB expertise

ScyllaDB Cloud

It’s easy to get started with our NoSQL DBaaS

2024 ©ScyllaDB | ScyllaDB, and ScyllaDB Cloud, are registered trademarks of ScyllaDB, Inc.

Apache® and Apache Cassandra® are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. Amazon DynamoDB® and Dynamo Accelerator® are trademarks of Amazon.com, Inc. No endorsements by The Apache Software Foundation or Amazon.com, Inc. are implied by the use of these marks.