Scylla Enterprise Features¶

The following features are scheduled for an upcoming release of Scylla Enterprise. To see which release, read the Release Notes.

• LDAP Role Management

• LDAP Authentication

The following are new features in ScyllaDB Enterprise 2022.1.x:

• Virtual Tables - Tables that retrieve system-level information by generating their contents on-the-fly when queried.

  • Virtual table for configuration - system.config, allows you to query and update configuration over CQL.

  • Virtual tables for exposing system-level information, such as cluster status, version-related information, etc.

See the Release Notes for more information.

The following are new features for Scylla Scylla Enterprise 2021.1.x:

• Space Amplification Goal (SAG) for ICS - new CQL option to set a Space Amplification Goal (SAG) in Incremental Compaction Strategy (ICS).

• Scylla Unified Installer - Scylla is now available as an all-in-one binary tar file. You can download the tar file from the Scylla Download Center.

• Change Data Capture (CDC) query the history of all changes made to the table. From Scylla Enterprise 2021.1.1

Read the Release Notes for more information.

The following are new features for Scylla Scylla Enterprise 2020.1.x:

• Lightweight Transactions (LWT) - Allows you to create and manipulate data according to a specified condition. Lightweight Transactions CQL Reference.

• Scylla Alternator: an Amazon DynamoDB™-compatible API

• Group Results - using the CQL GROUP BY option you can condense into a single row all selected rows that share the same values for a set of columns.

• Like Operator - when used on SELECT statements informs Scylla that you are looking for a pattern match. The expression ‘column LIKE pattern’ yields true only if the entire column value matches the pattern.

• Open range deletions - deletes rows based on an open-ended request (>, <, >=, =<, etc.)

• Auto-expanding Replication Factor - allows you to set a single replication factor for all Data Centers, including all existing Data Centers.

• Non-Frozen UDTs - User Defined Types that are not in a collection do not have to be frozen. UDTs in a collection must be frozen.

• CQL Per Partition Limit - This new per partition limit further allows you to set the number of partitions returned as a result. You can mix both row limits and per partition limits in the same CQL statement.

• BYPASS CACHE - This CQL command introduced in Scylla Enterprise 2019.1.1, now available in open source, informs the database that the data being read is unlikely to be read again in the near future, and also was unlikely to have been read in the near past; therefore no attempt should be made to read it from the cache or to populate the cache with the data.

Read the Release Notes for more information.

The following are new features for Scylla Scylla Enterprise 2019.1.x:

• Incremental Compaction Strategy - (version 2019.1.4) - significantly lowers SA (size amplification) for workloads which run STCS and should be used instead of STCS.

• IPv6 (version 2019.1.4) support for client-to-node, node-to-node, Manager to node, and Monitoring to node communication - Scylla now supports IPv6 Global Scope Addresses for all IPs: seeds, listen_address, broadcast_address etc. This functionality is available for Scylla Manager in Scylla Manager 2.0.

• Workload Prioritization - Grant a level of service to roles in your organization.

• Scylla Materialized Views - An alternate view table for finding a partition by the value of another column.

• Global Secondary Indexes - A mechanism for allowing efficient searches on non-partition keys using Materialized Views.

• Local Secondary Indexes - More efficient Secondary Index searches when the base table and index share the same partition key.

• ALLOW FILTERING CQL Command that allows for server side data filtering that is not based on the primary key.

• Hinted Handoff - ensures availability and consistency

• SSTable 3.0 - new SSTable format

• Full (multi-partition) blog describing improvements for fulll scans.

• Role Based Access Control (RBAC) - compatible with Apache Cassandra 3.x using CQL commands to grant roles to users in an organization.

• GoogleCloudSnitch- optimized for use with GCE instances

• Large Partitions Support - Scylla supports large partitions.

• Encryption at Rest - protects your data persisted in storage or backup.

• BYPASS CACHE - This CQL command informs the database that the data being read is unlikely to be read again in the near future, and also was unlikely to have been read in the near past; therefore no attempt should be made to read it from the cache or to populate the cache with the data.

Read the Release Notes for more information.

The following are new features for Scylla Scylla Enterprise 2018.1.x

• Scylla Auditing Guide - allows administrators to know which users performed what action at what time.

• Scylla in-memory tables - an alternative table type for storing data in RAM.

• Scylla Counters - A data type for counting

• Time Window Compaction Strategy - a replacement compaction strategy for Date-Tiered Compaction Strategy, refined for time-series data.

• Heat Weighted Load Balancing a blog entry which investigates what happens if one of the nodes loses its cache and the solution Heat Weighted Load Balancing.

Read the Release Notes for more information.