Scylla Enterprise Features

Scylla Enterprise 2020.1 Features

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.

Scylla Enterprise 2019.1 Features

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.

Scylla Enterprise 2018.1 Features

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

Read the Release Notes for more information.