Was this page helpful?
Caution
You're viewing documentation for an unstable version of ScyllaDB Manual. Switch to the latest stable version.
ScyllaDB and Apache Cassandra CompatibilityCopy
ScyllaDB is a drop-in replacement for Apache Cassandra 3.11, with additional features from Apache Cassandra 4.0. This page contains information about ScyllaDB compatibility with Apache Cassandra.
The tables on this page include information about ScyllaDB support for Apache Cassandra features. They do not include the ScyllaDB-specific features with no match in Apache Cassandra. See ScyllaDB Features for more information about ScyllaDB features.
How to Read the Tables on This PageCopy
- Available in ScyllaDB and compatible with Apache Cassandra.
- Not available in ScyllaDB.
NC - Available in ScyllaDB, but not compatible with Apache Cassandra.
InterfacesCopy
Apache Cassandra Interface |
Version Supported by ScyllaDB |
Comments |
|---|---|---|
CQL |
Fully compatible with version 3.3.1, with additional features from later CQL versions (for example, Duration type).
Fully compatible with protocol v4, with additional features from v5.
|
More below |
Thrift |
Not supported anymore in ScyllaDB 6.0 |
deprecated in Apache Cassandra and got dropped in 4.0
deprecated in ScyllaDB 5.2 and got dropped in 6.0
|
SSTable format (all versions) |
3.11(mc / md / me), 2.2(la), 2.1.8 (ka) |
me - supported in ScyllaDB 2022.2.0 and latermd - supported in ScyllaDB 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 ToolsCopy
The tools are based on Apache Cassandra 3.11.
Nodetool Reference - ScyllaDB commands for managing ScyllaDB node or cluster using the command-line nodetool utility.
Tracing - a ScyllaDB tool for debugging and analyzing internal flows in the server.
SSTableloader - Bulk load the sstables found in the directory to a ScyllaDB cluster
ScyllaDB SStable - Validates and dumps the content of SStables, generates a histogram, dumps the content of the SStable index.
ScyllaDB Types - Examines raw values obtained from SStables, logs, coredumps, etc.
cassandra-stress A tool for benchmarking and load testing a ScyllaDB and Cassandra clusters.
scylla 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 ScyllaDB in Developer Mode.
perftune - performance configuration.
Reading mutation fragments - dump the underlying mutation data from tables.
Maintenance socket - a Unix domain socket for full-permission CQL connection.
Maintenance mode - a mode for performing maintenance tasks on an offline ScyllaDB node.
Task manager - a tool for tracking long-running background operations.
Run each tool with -h, --help for full options description.
FeaturesCopy
Consistency Level (read and write)Copy
Options |
Support |
|---|---|
Any (Write Only) |
|
One |
|
Two |
|
Three |
|
Quorum |
|
All |
|
Local One |
|
Local Quorum |
|
Each Quorum (Write Only) |
|
SERIAL |
* |
LOCAL_SERIAL |
* |
* See ScyllaDB LWT.
SnitchesCopy
Options |
Support |
|---|---|
PropertyFileSnitch |
|
Dynamic snitching |
|
CloudstackSnitch |
|
PartitionersCopy
Options |
Support |
|---|---|
Murmur3Partitioner (default) |
|
RandomPartitioner |
|
OrderPreservingPartitioner |
|
ByteOrderedPartitioner |
|
CollatingOrderPreservingPartitioner |
Protocol OptionsCopy
Options |
Support |
|---|---|
Compression (see below) |
CompressionCopy
Options |
Support |
|---|---|
CQL Compression |
|
LZ4 |
|
Snappy |
|
Backup and RestoreCopy
Options |
Support |
|---|---|
Repair and ConsistencyCopy
Options |
Support |
|---|---|
Incremental Repair |
|
Replica Replacement StrategyCopy
Options |
Support |
|---|---|
SimpleStrategy |
|
NetworkTopologyStrategy |
SecurityCopy
Options |
Support |
|---|---|
Role Based Access Control (RBAC) |
Indexing and CachingCopy
Options |
Support |
|---|---|
Additional FeaturesCopy
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 CompatibilityCopy
Create KeyspaceCopy
Feature |
Support |
|---|---|
DURABLE_WRITES |
|
IF NOT EXISTS |
|
WITH REPLICATION |
(see below) |
Create Keyspace with ReplicationCopy
Feature |
Support |
|---|---|
SimpleStrategy |
|
NetworkTopologyStrategy |
|
OldNetworkTopologyStrategy |
Create TableCopy
Feature |
Support |
|---|---|
Primary key column |
|
Compound primary key |
|
Composite partition key |
|
Clustering order |
|
Static column |
Create Table AttCopy
Feature |
Support |
|---|---|
bloom_filter_fp_chance |
|
caching |
(ignored) |
comment |
|
compaction |
|
compression |
|
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 |
|
replicate_on_write |
|
speculative_retry |
|
Create Table CompactionCopy
Feature |
Support |
|---|---|
SizeTieredCompactionStrategy (STCS) |
|
DateTieredCompactionStrategy (DTCS) |
* |
TimeWindowCompactionStrategy (TWCS) |
* No longer supported. Use TimeWindowCompactionStrategy (TWCS) instead.
Create Table CompressionCopy
Feature |
Support |
|---|---|
sstable_compression LZ4Compressor |
|
sstable_compression SnappyCompressor |
|
sstable_compression DeflateCompressor |
|
chunk_length_kb |
|
crc_check_chance |
Alter CommandsCopy
Feature |
Support |
|---|---|
ALTER KEYSPACE |
|
ALTER TABLE |
|
ALTER TYPE |
|
ALTER USER |
|
ALTER ROLE |
Data ManipulationCopy
Feature |
Support |
|---|---|
BATCH |
|
INSERT |
|
Prepared Statements |
|
SELECT |
|
TRUNCATE |
|
UPDATE |
|
USE |
Create CommandsCopy
Feature |
Support |
|---|---|
CREATE TRIGGER |
|
CREATE USER |
|
CREATE ROLE |
Drop CommandsCopy
Feature |
Support |
|---|---|
DROP KEYSPACE |
|
DROP TABLE |
|
DROP TRIGGER |
|
DROP TYPE |
|
DROP USER |
|
DROP ROLE |
Roles and PermissionsCopy
Feature |
Support |
|---|---|
GRANT PERMISSIONS |
|
GRANT ROLE |
|
LIST PERMISSIONS |
|
LIST USERS |
|
LIST ROLES |
|
REVOKE PERMISSIONS |
|
REVOKE ROLE |
Materialized ViewsCopy
Feature |
Support |
|---|---|
MATERIALIZED VIEW |
|
ALTER MATERIALIZED VIEW |
|
CREATE MATERIALIZED VIEW |
|
DROP MATERIALIZED VIEW |
Index commandsCopy
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.