Was this page helpful?
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 Open Source support for Apache Cassandra features. They do not include the ScyllaDB Enterprise-only features or ScyllaDB-specific features with no match in Apache Cassandra. See ScyllaDB Features for more information about ScyllaDB features.
- Available in ScyllaDB and compatible with Apache Cassandra.
- Not available in ScyllaDB.
NC - Available in ScyllaDB, but not compatible with Apache Cassandra.
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 |
Deprecated in ScyllaDB and Cassandra |
Support for the Thrift protocol is deprecated and will be dropped in future releases of ScyllaDB. |
SSTable format (all versions) |
3.11(mc / md / me), 2.2(la), 2.1.8 (ka) |
me - supported in ScyllaDB Open Source 5.1 and ScyllaDB Enterprise 2022.2.0 (and later)md - supported in ScyllaDB Open Source 4.3 and ScyllaDB Enterprise 2021.1.0 (and later) |
JMX |
3.11 |
More below |
Configuration (cassandra.yaml) |
3.11 |
|
Log |
NC |
|
Gossip and internal streaming |
NC |
|
SSL |
NC |
The tools are based on Apache Cassandra 3.11.
Nodetool Reference - Scylla commands for managing Scylla 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 Scylla cluster
Scylla SStable - Validates and dumps the content of SStables, generates a histogram, dumps the content of the SStable index.
Scylla Types - Examines raw values obtained from SStables, logs, coredumps, etc.
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
SSTableMetadata - Scylla 3.0, Scylla Enterprise 2019.1 and newer versions
sstablelevelreset - Reset level to 0 on a selected set of SSTables that use LeveledCompactionStrategy (LCS).
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.
SELECT * FROM MUTATION_FRAGMENTS() Statement - dump the underlying mutation data from tables.
Run each tool with -h
, --help
for full options description.
Options |
Support |
---|---|
Any (Write Only) |
|
One |
|
Two |
|
Three |
|
Quorum |
|
All |
|
Local One |
|
Local Quorum |
|
Each Quorum (Write Only) |
|
SERIAL |
* |
LOCAL_SERIAL |
* |
* See Scylla LWT.
Options |
Support |
---|---|
PropertyFileSnitch |
|
Dynamic snitching |
|
CloudstackSnitch |
|
Options |
Support |
---|---|
Murmur3Partitioner (default) |
|
RandomPartitioner |
|
OrderPreservingPartitioner |
|
ByteOrderedPartitioner |
|
CollatingOrderPreservingPartitioner |
Options |
Support |
---|---|
Compression (see below) |
Options |
Support |
---|---|
CQL Compression |
|
LZ4 |
|
Snappy |
|
Options |
Support |
---|---|
Options |
Support |
---|---|
Incremental Repair |
|
Options |
Support |
---|---|
SimpleStrategy |
|
NetworkTopologyStrategy |
Options |
Support |
---|---|
Role Based Access Control (RBAC) |
Options |
Support |
---|---|
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
Feature |
Support |
---|---|
DURABLE_WRITES |
|
IF NOT EXISTS |
|
WITH REPLICATION |
(see below) |
Feature |
Support |
---|---|
SimpleStrategy |
|
NetworkTopologyStrategy |
|
OldNetworkTopologyStrategy |
Feature |
Support |
---|---|
Primary key column |
|
Compound primary key |
|
Composite partition key |
|
Clustering order |
|
Static column |
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 |
|
Feature |
Support |
---|---|
SizeTieredCompactionStrategy (STCS) |
|
DateTieredCompactionStrategy (DTCS) |
* |
TimeWindowCompactionStrategy (TWCS) |
* No longer supported. Use TimeWindowCompactionStrategy (TWCS) instead.
Feature |
Support |
---|---|
sstable_compression LZ4Compressor |
|
sstable_compression SnappyCompressor |
|
sstable_compression DeflateCompressor |
|
chunk_length_kb |
|
crc_check_chance |
Feature |
Support |
---|---|
ALTER KEYSPACE |
|
ALTER TABLE |
|
ALTER TYPE |
|
ALTER USER |
|
ALTER ROLE |
Feature |
Support |
---|---|
BATCH |
|
INSERT |
|
Prepared Statements |
|
SELECT |
|
TRUNCATE |
|
UPDATE |
|
USE |
Feature |
Support |
---|---|
CREATE TRIGGER |
|
CREATE USER |
|
CREATE ROLE |
Feature |
Support |
---|---|
DROP KEYSPACE |
|
DROP TABLE |
|
DROP TRIGGER |
|
DROP TYPE |
|
DROP USER |
|
DROP ROLE |
Feature |
Support |
---|---|
GRANT PERMISSIONS |
|
GRANT ROLE |
|
LIST PERMISSIONS |
|
LIST USERS |
|
LIST ROLES |
|
REVOKE PERMISSIONS |
|
REVOKE ROLE |
Feature |
Support |
---|---|
MATERIALIZED VIEW |
|
ALTER MATERIALIZED VIEW |
|
CREATE MATERIALIZED VIEW |
|
DROP MATERIALIZED VIEW |
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.
Was this page helpful?