ScyllaDB Open Source 3.3

ScyllaDB Open Source Box icon

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.

New in ScyllaDB Open Source

blue arrow

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.

blue arrow

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.

blue arrow

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.

blue arrow

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).
blue arrow

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×1038 addressable devices. This enables and facilitates the continued expansion of data networks.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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.
blue arrow

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%.
blue arrow

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

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

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

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

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.

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

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

ScyllaDB University Mascot

ScyllaDB University

Get started on the path to ScyllaDB expertise

ScyllaDB Cloud Mascot

ScyllaDB Cloud

It’s easy to get started with our NoSQL DBaaS