ScyllaDB Enterprise 2022

Our latest enterprise release, ScyllaDB Enterprise 2022.2 is a production-ready release providing stability and performance improvements introduced in ScyllaDB Open Source 5.1 and building upon the abundance of enhancements in ScyllaDB Enterprise 2022.

Now in ScyllaDB Enterprise 2022

Alternator Time-to-Live (TTL) (2022.2+)

This release supports Time-to-Live (TTL) expirations of data in our DynamoDB-compatible API, known as “Alternator.” The TTL has a deletion delay of up to 48 hours. With ScyllaDB’s Alternator, you can set a custom deletion delay (by default set to 24 hours). Also, Alternator will BYPASS CACHE for scans employed in TTL expiration, reducing the impact on user workloads. We’ve also implemented new metrics to observe TTL expirations.

Limit Partition Access Rate (2022.2+)

It is now possible to limit read rates and writes rates into a partition with a new WITH per_partition_rate_limit clause for the CREATE TABLE and ALTER TABLE statements. This is useful to prevent hot-partition problems when high rate reads or writes are bogus (for example, arriving from spam bots).

Load and Stream (2022.2+)

This feature extends nodetool refresh to allow loading arbitrary SSTables that do not belong to a particular node into the cluster. It loads the SSTables from disk, calculates the data’s owning nodes, and automatically streams the data to the owning nodes. In particular this is useful when restoring a cluster from backup.

Materialized View: Prune (2022.2+)

So-called “ghost rows” manifest when rows in a materialized view do not correspond to any base table rows. Such inconsistencies should be prevented altogether and ScyllaDB strives to avoid them, but if they happen, the new PRUNE MATERIALIZED VIEW statement can be used to restore a materialized view to a fully consistent state without rebuilding it from scratch.

Materialized View: Synchronous Mode (2022.2+)

In ordinary (asynchronous) materialized views the operation returns before the view is updated. In synchronous materialized views the operation does not return until the view is updated. This enhances consistency but reduces availability as in some situations all nodes might be required to be functional.

AWS EC2 I4i Instances

ScyllaDB now supports AWS EC2 I4i series instances. Capitalizing on 3rd generation Intel Xeon “Ice Lake” processors, the AWS Nitro System hypervisor, and low-latency Nitro NVMe SSDs, ScyllaDB can achieve more than twice the throughput and lower latencies with I4i servers versus comparable i3 servers.

Arm-based Systems

ScyllaDB Enterprise also supports systems with Arm-based processors, including the new AWS Im4gn and Is4gen storage-optimized instances powered by Graviton2 processors. Now compiled to run on any AArch64 architecture, you can even run ScyllaDB in a Docker container on an Arm-based M1-powered Macintosh for next-gen application development.

I/O Scheduler

Integrated via a Seastar update, a new I/O scheduler seeks to find what is known as the effective dispatch rate — the fastest rate at which the system can process data without running into internal queuing jams to keep latency low.

Improved Reverse Queries

Reverse queries are SELECT statements that use reverse order from the table schema to accelerate queries for large partitions when advantageous. Whereas rows in a partition are sorted in ascending order by default, a reverse query would sort rows with the newest row first in descending order

Repair-based Node Operations

The same data transfer logic used for repair, a background process to sync data between nodes, is now used for topology changes. Node operations can restart from points where stopped without re-sending synced data, a significant time-saver when adding or removing large nodes. New off-strategy compaction can also be utilized to optimize performance.

Virtual Tables for Config and Nodetool Info

More lightweight than sstables, virtual tables are not persisted and generated on-the-fly. A new system.config virtual table allows querying and updating config parameters over CQL. Nodetool command info can also be queried including snapshots, protocol servers, and runtime info. Virtual tables can also be accessed remotely, including for ScyllaDB Cloud users.

Alternator, Our DynamoDB-compatible API

Enabling migration to ScyllaDB with potentially no application code changes, Alternator has been updated with valuable new support for:

  • Cross-Origin Resource Sharing (CORS)
  • Nested attribute paths
  • Attribute paths in ConditionExpression, FilterExpression, and ProjectionExpression

SSTable Index Caching

Indexes (not just data from SSTable rows) can now be cached in memory, between readers, populated on access, and evicted on memory pressure. Disks no longer need to be touched when walking an index – reducing IO and decreasing latency.

Timeout Operations Syntax

Timeouts can now be set for individual queries versus applying to the entire system through a new “USING TIMEOUT” syntax. A particularly useful feature for queries known to take considerable time, the new timeout syntax can also be used for updates (INSERT, UPDATE, DELETE).

Granular Timeout Controls

Timeouts also have more granular control to meet latency requirements and free up server resources. By using Service Level Properties for example to associate attributes to rules and users, timeouts can be based on service level and workload types.

Cloud Formation

A new variable VpcCidrIp allows you to set CIDR IP range for VPC. Previously, the range was hard coded to 172.31.0.0/16. Plus the Cloud Formation template was reordered for better readability.

Guardrails

Guardrails are a collection of reservations that make it harder to use non-recommended options in production, such as:

  • Preventing use of SimpleReplicationStrategy.
  • Warn or prevent use of DateTieredCompactionStrategy (versus TimeWindowCompactionStrategy).
  • Disabling Thrift, a legacy interface, by default
  • Ensuring all nodes use the same snitch mode

ScyllaDB administrators can use default settings or customize guardrails as needed.

Check out the latest ScyllaDB Manager and ScyllaDB Monitoring Stack for new features such as the new Advisor Section and more.

Built on the Foundations of ScyllaDB Enterprise 2021

After more than 6,000 commits originating from five open source releases, ScyllaDB Enterprise 2022 has many additional features and enhancements since ScyllaDB Enterprise 2021, including:

  • LDAP Authentication and Authorization
  • Change Data Capture (CDC)
  • Space Amplification Goal (SAG) for ICS
  • Remove the Seed Concept in Gossip
  • Binary Search in SSTable Promoted Index
  • Alternator, Our DynamoDB-Compatible API
  • GCP Images
  • And much more

Resources

ScyllaDB Enterprise builds on the proven features and capabilities of ScyllaDB Open Source, while also bringing with a set of unique enterprise-only features.

Get more details on the latest release of our highly performant ScyllaDB Enterprise database.
Read our release notes for full details on the features and capabilities in ScyllaDB Enterprise 2022.1
Implementing a New IO Scheduler Algorithm for Mixed Read/Write Workloads
The latest evolution of our monstrously fast and scalable NoSQL database.

Learn how to configure ScyllaDB to replace or extend Amazon DynamoDB.

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