Scylla Documentation Logo Documentation
  • Server
    • Scylla Open Source
    • Scylla Enterprise
    • Scylla Alternator
  • Cloud
    • Scylla Cloud
    • Scylla Cloud Docs
  • Tools
    • Scylla Manager
    • Scylla Monitoring Stack
    • Scylla Operator
  • Drivers
    • CQL Drivers
    • DynamoDB Drivers
Download
Menu
Scylla Getting Started Migrate to Scylla Scylla and Apache Cassandra Compatibility

Scylla and Apache Cassandra Compatibility¶

Latest update: Scylla 4.0

Scylla is a drop-in replacement for Apache Cassandra 3.11, supporting both the data format (SSTable) and all relevant external interfaces, with many features from more advanced Apache Cassandra releases. The following page detailed the level of support for each interface. For more on Cassandra features which are not available yet see here

Note

This table includes Apache Cassandra features and the corresponding Scylla Open Source status. It does not include Scylla Enterprise features or Scylla Open Source features with no match in Apache Cassandra. More on Scylla Features

For all tables below, the following convention is used:

  • - Not Available in Scylla

  • NC - Available in Scylla, but not compatible with Apache Cassandra

  • - Available and compatible with Apache Cassandra

Interfaces¶

Apache Cassandra

Version

Comments

CQL

CQL spec 3.4.0, Native protocol v4 (C* 3.11)

More below

Thrift

Compatible with Cassandra 2.1

SSTable format (all versions)

3.11(mc / md ), 2.2(la), 2.1.8 (ka)

md format is supported in Scylla 4.3, 2021.1.0 and later

JMX

3.11

More Below

Configuration (cassandra.yaml)

3.11

Log

NC

Gossip and internal streaming

NC

SSL

NC

Supported Tools¶

(based on Apache Cassandra 3.11 release)

  • Nodetool Reference - Scylla commands for managing Scylla node or cluster using the command-line nodetool utility.

  • CQLSh - the CQL shell.

  • REST - Scylla REST/HTTP Admin API.

  • Tracing - a ScyllaDB tool for debugging and analyzing internal flows in the server.

  • SSTableloader - Bulk load the sstables found in the directory to a Scylla cluster

  • scylla-sstable - Validates and dumps the content of SStables, generates a histogram, dumps the content of the SStable index.

  • cassandra-stress A tool for benchmarking and load testing a Scylla and Cassandra clusters.

  • SSTabledump - Scylla 3.0, Scylla Enterprise 2019.1 and newer versions

  • SSTable2JSON - Scylla 2.3 and older

  • sstablelevelreset - Reset level to 0 on a selected set of SSTables that use LeveledCompactionStrategy (LCS).

  • SSTable-Index - A tool which lists all partitions contained in an SSTable index.

  • sstablemetadata - Prints metadata about a specified SSTable.

  • sstablerepairedset - Mark specific SSTables as repaired or unrepaired.

  • configuration_encryptor - encrypt at rest sensitive scylla configuration entries using system key.

  • local_file_key_generator - Generate a local file (system) key for encryption at rest, with the provided length, Key algorithm, Algorithm block mode and Algorithm padding method.

  • scyllatop - A terminal base top-like tool for scylladb collectd/prometheus metrics.

  • scylla_dev_mode_setup - run Scylla in Developer Mode.

  • perftune - performance configuration.

Run each tool with -h, --help for full options description.

Features¶

Consistency Level (read and write)¶

Options

Support

Any (Write Only)

One

Two

Three

Quorum

All

Local One

Local Quorum

Each Quorum (Write Only)

SERIAL

*

LOCAL_SERIAL

*

* From Scylla 4.0. See Scylla LWT

Snitches¶

Options

Support

SimpleSnitch

RackInferringSnitch

PropertyFileSnitch

GossipingPropertyFileSnitch

Dynamic snitching

EC2Snitch

EC2MultiRegionSnitch

GoogleCloudSnitch

CloudstackSnitch

Partitioners¶

Options

Support

Murmur3Partitioner (default)

RandomPartitioner

*

OrderPreservingPartitioner

ByteOrderedPartitioner

*

CollatingOrderPreservingPartitioner

* Removed in Scylla 4.0

Protocol Options¶

Options

Support

Encryption

Authentication

Compression (see below)

Compression¶

Options

Support

CQL Compression

LZ4

Snappy

Node to Node Compression

Client to Node Compression

Backup and Restore¶

Options

Support

Snapshot

Incremental backup

Restore

Repair and Consistency¶

Options

Support

Nodetool Repair

Incremental Repair

Hinted Handoff

Lightweight transactions

*

* From Scylla 4.0. See Scylla LWT

Replica Replacement Strategy¶

Options

Support

SimpleStrategy

NetworkTopologyStrategy

Security¶

Options

Support

Role Based Access Control (RBAC)

Indexing and Caching¶

Options

Support

row / key cache

(More on Scylla memory and cache)

Secondary Index

*

Materialized Views

*

* In Scylla Open Source and Scylla Enterprise from 2019.1

Additional Features¶

Feature

Support

Counters

User Defined Types

User Defined Functions

*

Time to live (TTL)

Super Column

vNode Enable

Default

vNode Disable

Triggers

Batch Requests

Includes conditional updates

* Experimental

CQL Command Compatibility¶

Create Keyspace¶

Feature

Support

DURABLE_WRITES

IF NOT EXISTS

WITH REPLICATION

(see below)

Create Keyspace with Replication¶

Feature

Support

SimpleStrategy

NetworkTopologyStrategy

OldNetworkTopologyStrategy

Create Table¶

Feature

Support

Primary key column

Compound primary key

Composite partition key

Clustering order

Static column

Create Table Att¶

Feature

Support

bloom_filter_fp_chance

caching

(ignored)

comment

compaction

compression

dclocal_read_repair_chance

default_time_to_live

gc_grace_seconds

index_interval

max_index_interval

memtable_flush_period_in_ms

(ignored)

min_index_interval

populate_io_cache_on_flush

read_repair_chance

replicate_on_write

speculative_retry

ALWAYS, NONE

Create Table Compaction¶

Feature

Support

SizeTieredCompactionStrategy (STCS)

LeveledCompactionStrategy (LCS)

DateTieredCompactionStrategy (DTCS)

*

TimeWindowCompactionStrategy (TWCS)

* Deprecated in Scylla 4.0, use TWCS instead

Create Table Compression¶

Feature

Support

sstable_compression LZ4Compressor

sstable_compression SnappyCompressor

sstable_compression DeflateCompressor

chunk_length_kb

crc_check_chance

Alter Commands¶

Feature

Support

ALTER KEYSPACE

ALTER TABLE

ALTER TYPE

ALTER USER

ALTER ROLE

Data Manipulation¶

Feature

Support

BATCH

INSERT

Prepared Statements

SELECT

TRUNCATE

UPDATE

USE

Create Commands¶

Feature

Support

CREATE TRIGGER

CREATE USER

CREATE ROLE

Drop Commands¶

Feature

Support

DROP KEYSPACE

DROP TABLE

DROP TRIGGER

DROP TYPE

DROP USER

DROP ROLE

Roles and Permissions¶

Feature

Support

GRANT PERMISSIONS

GRANT ROLE

LIST PERMISSIONS

LIST USERS

LIST ROLES

REVOKE PERMISSIONS

REVOKE ROLE

Materialized Views¶

Feature

Support

MATERIALIZED VIEW

ALTER MATERIALIZED VIEW

CREATE MATERIALIZED VIEW

DROP MATERIALIZED VIEW

Index commands¶

Feature

Support

INDEX

CREATE INDEX

DROP INDEX

© 2016, The Apache Software Foundation.

Apache®, Apache Cassandra®, Cassandra®, the Apache feather logo and the Apache Cassandra® Eye logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. No endorsement by The Apache Software Foundation is implied by the use of these marks.

PREVIOUS
Apache Cassandra to Scylla Migration Process
NEXT
Scylla Migration Tools: An Overview
  • Getting Started
    • Install Scylla
      • Scylla Unified Installer (relocatable executable)
      • Air-gapped Server Installation
      • What is in each RPM
      • Scylla Housekeeping and how to disable it
      • Scylla Developer Mode
      • Scylla Configuration Reference
    • Configure Scylla
    • Scylla Requirements
      • System Requirements
      • OS Support by Platform and Version
      • Scylla in a Shared Environment
    • Cassandra Query Language (CQL)
      • CQLSh the CQL shell
      • Data Definition
      • Data Manipulation
      • Expiring Data with Time to Live (TTL)
      • Additional Information
      • Security
      • Data Types
      • Appendices
      • Definitions
      • Materialized Views
      • Functions
      • JSON
      • Global Secondary Indexes
      • Additional Information
      • Compaction
      • Consistency Levels
      • Reserved Keywords
      • Non-reserved Keywords
    • CQLSh: the CQL shell
    • Scylla Drivers
      • Scylla CQL Drivers
      • Scylla DynamoDB Drivers
    • Migrate to Scylla
      • Migration Process from Cassandra to Scylla
      • Scylla and Apache Cassandra Compatibility
      • Migration Tools Overview
    • Integration Solutions
      • Integrate Scylla with Spark
      • Integrate Scylla with KairosDB
      • Integrate Scylla with Presto
      • Integrate Scylla with Elasticsearch
      • Integrate Scylla with Kubernetes
      • Integrate Scylla with the JanusGraph Graph Data System
      • Integrate Scylla with DataDog
      • Integrate Scylla with Kafka
      • Integrate Scylla with IOTA Chronicle
      • Integrate Scylla with Spring
      • Shard-Aware Kafka Connector for Scylla
      • Install Scylla with Ansible
      • Integrate Scylla with Databricks
    • Tutorials
  • Scylla for Administrators
    • Administration Guide
    • Procedures
      • Cluster Management
      • Backup & Restore
      • Change Configuration
      • Maintenance
      • Best Practices
      • Benchmarking Scylla
      • Migrate from Cassandra to Scylla
      • Disable Housekeeping
    • Security
      • Scylla Security Checklist
      • Enable Authentication
      • Enable and Disable Authentication Without Downtime
      • Generate a cqlshrc File
      • Reset Authenticator Password
      • Enable Authorization
      • Grant Authorization CQL Reference
      • Role Based Access Control (RBAC)
      • Scylla Auditing Guide
      • Encryption: Data in Transit Client to Node
      • Encryption: Data in Transit Node to Node
      • Generating a self-signed Certificate Chain Using openssl
      • Encryption at Rest
      • LDAP Authentication
      • LDAP Authorization (Role Management)
    • Admin Tools
      • Nodetool Reference
      • CQLSh
      • REST
      • Tracing
      • scylla-sstable
      • SSTableLoader
      • cassandra-stress
      • SSTabledump
      • SSTable2json
      • SSTable Index
      • Scylla Logs
      • Seastar Perftune
    • Scylla Manager
      • Scylla Manager Docs
      • Upgrade Scylla Manager
      • Monitoring Support Matrix
    • Scylla Monitoring Stack
      • Latest Version
      • Upgrade Scylla Monitoring Stack
      • Monitoring Support Matrix
    • Scylla Operator
    • Upgrade Procedures
      • Scylla Enterprise
      • Scylla Open Source
      • Scylla Open Source to Scylla Enterprise
      • Scylla Manager
      • Scylla Monitoring
      • Scylla AMI
    • System Configuration
      • System Configuration Guide
      • scylla.yaml
      • Scylla Snitches
    • Benchmarking Scylla
  • Scylla for Developers
    • Learn To Use Scylla
      • Scylla University
      • Course catalog
      • Scylla Essentials
      • Basic Data Modeling
      • Advanced Data Modeling
      • MMS - Learn by Example
      • Care-Pet an IoT Use Case and Example
    • CQLSh
    • Apache Cassandra Query Language (CQL)
    • Scylla Alternator
    • Scylla Features
      • Scylla Open Source Features
      • Scylla Enterprise Features
    • Scylla Drivers
      • Scylla CQL Drivers
      • Scylla DynamoDB Drivers
  • Scylla Architecture
    • Scylla Ring Architecture
    • Scylla Fault Tolerance
    • Consistency Level Console Demo
    • Scylla Anti-Entropy
      • Scylla Hinted Handoff
      • Scylla Read Repair
      • Scylla Repair
    • SSTable
      • Scylla SSTable - 2.x
      • Scylla SSTable - 3.x
    • Compaction Strategies
  • Troubleshooting Scylla
    • Errors and Support
      • Report a Scylla problem
      • Error Messages
      • Change Log Level
    • Scylla Startup
      • Ownership Problems
      • Scylla will not Start
      • Scylla Python Script broken
    • Cluster and Node
      • Failed Decommission Problem
      • Cluster Timeouts
      • Node Joined With No Data
      • SocketTimeoutException
      • NullPointerException
    • Data Modeling
      • Scylla Large Partitions Table
      • Scylla Large Rows and Cells Table
      • Large Partitions Hunting
    • Data Storage and SSTables
      • Space Utilization Increasing
      • Disk Space is not Reclaimed
      • SSTable Corruption Problem
      • Pointless Compactions
      • Limiting Compaction
    • CQL
      • Time Range Query Fails
      • COPY FROM Fails
      • CQL Connection Table
      • Reverse queries fail
    • Scylla Monitor and Manager
      • Manager and Monitoring integration
      • Manager lists healthy nodes as down
  • Knowledge Base
    • Upgrading from experimental CDC
    • Compaction
    • Counting all rows in a table is slow
    • CQL Query Does Not Display Entire Result Set
    • When CQLSh query returns partial results with followed by “More”
    • Run Scylla and supporting services as a custom user:group
    • Decoding Stack Traces
    • Snapshots and Disk Utilization
    • DPDK mode
    • Debug your database with Flame Graphs
    • How to Change gc_grace_seconds for a Table
    • Gossip in Scylla
    • Increase Permission Cache to Avoid Non-paged Queries
    • How does Scylla LWT Differ from Apache Cassandra ?
    • Map CPUs to Scylla Shards
    • Scylla Memory Usage
    • NTP Configuration for Scylla
    • POSIX networking for Scylla
    • Scylla consistency quiz for administrators
    • Recreate RAID devices
    • How to Safely Increase the Replication Factor
    • Scylla and Spark integration
    • Increase Scylla resource limits over systemd
    • Scylla Seed Nodes
    • How to Set up a Swap Space
    • Scylla Snapshots
    • Stopping a local repair
    • System Limits
    • How to flush old tombstones from a table
    • Time to Live (TTL) and Compaction
    • Scylla Nodes are Unresponsive
    • Update a Primary Key
    • Using the perf utility with Scylla
    • Configure Scylla Networking with Multiple NIC/IP Combinations
  • Scylla University
  • Scylla FAQ
  • Contribute to Scylla
  • Glossary
  • Create an issue

On this page

  • Scylla and Apache Cassandra Compatibility
    • Interfaces
    • Supported Tools
    • Features
      • Consistency Level (read and write)
      • Snitches
      • Partitioners
      • Protocol Options
      • Compression
      • Backup and Restore
      • Repair and Consistency
      • Replica Replacement Strategy
      • Security
      • Indexing and Caching
      • Additional Features
    • CQL Command Compatibility
      • Create Keyspace
      • Create Keyspace with Replication
      • Create Table
        • Create Table Att
        • Create Table Compaction
        • Create Table Compression
        • Alter Commands
        • Data Manipulation
        • Create Commands
        • Drop Commands
        • Roles and Permissions
        • Materialized Views
        • Index commands
Logo
Docs Contact Us About Us
Mail List Icon Slack Icon
© 2022, ScyllaDB. All rights reserved.
Last updated on 10 May 2022.
Powered by Sphinx 4.3.2 & ScyllaDB Theme 1.2.1