ScyllaDB

https://docs.scylladb.com/
Admin
ScyllaDB is a distributed NoSQL wide-column database designed for data-intensive applications that...
Tokens:346,298
Snippets:4,901
Trust Score:10
Update:3 months ago
Show doc for...
Tokens:
Raw
### Install Specific ScyllaDB Versions and Editions

Source: https://docs.scylladb.com/branch-5.1/getting-started/install-scylla/scylla-web-installer.html

Examples of using command-line flags to specify product editions and version numbers during installation.

```bash
curl -sSf get.scylladb.com/server | sudo bash -s -- --scylla-version 4.6.1
```

```bash
curl -sSf get.scylladb.com/server | sudo bash -s -- --scylla-version 4.6
```

```bash
curl -sSf get.scylladb.com/server | sudo bash -s -- --scylla-product scylla-enterprise --scylla-version 2021.1
```

--------------------------------

### Create Table and Index for Filtering Examples

Source: https://docs.scylladb.com/branch-5.2/cql/dml.html

Setup schema for demonstrating filtering behavior in CQL.

```cql
CREATE TABLE users (
    username text PRIMARY KEY,
    firstname text,
    lastname text,
    birth_year int,
    country text
)

CREATE INDEX ON users(birth_year);
```

--------------------------------

### Create Keyspace Examples

Source: https://docs.scylladb.com/branch-5.2/cql/ddl.html

Basic examples of creating keyspaces using NetworkTopologyStrategy and SimpleStrategy.

```cql
CREATE KEYSPACE Excalibur
WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1' : 1, 'DC2' : 3}
AND durable_writes = true;
```

```cql
CREATE KEYSPACE Excelsior
WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 3};
```

--------------------------------

### Create User Examples

Source: https://docs.scylladb.com/branch-5.2/operating-scylla/security/authorization.html

Examples of creating users with specific passwords and superuser privileges.

```sql
CREATE USER alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE USER bob WITH PASSWORD 'password_b' NOSUPERUSER;
```

--------------------------------

### Create database roles

Source: https://docs.scylladb.com/branch-5.2/using-scylla/workload-prioritization.html

Initial setup to create the roles required for workload prioritization examples.

```CQL
CREATE ROLE Spark;
CREATE ROLE Web;
```

--------------------------------

### Example System Encryption Configuration

Source: https://docs.scylladb.com/branch-5.2/operating-scylla/security/encryption-at-rest.html

Example configuration using the LocalFileSystemKeyProviderFactory.

```yaml
system_info_encryption:
   enabled: True
   cipher_algorithm: AES
   secret_key_strength: 128
   key_provider: LocalFileSystemKeyProviderFactory
   secret_key_file: /path/to/systemKey.pem
```

--------------------------------

### Example CPU Set Configuration

Source: https://docs.scylladb.com/branch-5.1/getting-started/system-configuration.html

Example format for defining the CPU set in the configuration file.

```bash
--cpuset `1-15,17-31`
```

--------------------------------

### Start Scylla Server

Source: https://docs.scylladb.com/branch-5.1/troubleshooting/password-reset.html

Starts the Scylla service on a node.

```bash
sudo systemctl start scylla-server
```

--------------------------------

### CREATE KEYSPACE Example

Source: https://docs.scylladb.com/manual/stable/cql/ddl.html

An example of creating a keyspace with NetworkTopologyStrategy and durable writes enabled.

```cql
CREATE KEYSPACE Excalibur
WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1' : ['RAC1', 'RAC2', 'RAC3'], 'DC2' : 3}
AND durable_writes = true;
```

--------------------------------

### Setup Table for Range Deletions

Source: https://docs.scylladb.com/branch-5.2/cql/dml.html

Example schema creation and data insertion to demonstrate range deletion functionality.

```cql
CREATE KEYSPACE mykeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor': '1'}  AND durable_writes = true;
use mykeyspace ;
CREATE TABLE events ( id text, created_at date, content text, PRIMARY KEY (id, created_at) );

INSERT into events (id, created_at, content) VALUES ('concert', '2019-11-19', 'SuperM');
INSERT into events (id, created_at, content) VALUES ('concert', '2019-11-15', 'Billy Joel');
INSERT into events (id, created_at, content) VALUES ('game', '2019-11-03', 'Knicks v Sacramento');
INSERT into events (id, created_at, content) VALUES ('concert', '2019-10-31', 'Dead & Company');
INSERT into events (id, created_at, content) VALUES ('game', '2019-10-28', 'Knicks v Chicago');
INSERT into events (id, created_at, content) VALUES ('concert', '2019-10-25', 'Billy Joel');


SELECT * from events;

 id      | created_at | content
---------+------------+---------------------
    game | 2019-10-28 |    Knicks v Chicago
    game | 2019-11-03 | Knicks v Sacramento
 concert | 2019-10-25 |          Billy Joel
 concert | 2019-10-31 |      Dead & Company
 concert | 2019-11-15 |          Billy Joel
 concert | 2019-11-19 |              SuperM

(6 rows)
```

--------------------------------

### Create User Syntax and Examples

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/authorization.html

Defines the syntax for creating users and provides examples for setting passwords and superuser status.

```cql
create_user_statement: CREATE USER [ IF NOT EXISTS ] [ WITH PASSWORD `string` ] [ `user_option` ]
user_option: SUPERUSER | NOSUPERUSER
```

```cql
CREATE USER alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE USER bob WITH PASSWORD 'password_b' NOSUPERUSER;
```

```cql
CREATE USER alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE USER IF NOT EXISTS alice WITH PASSWORD 'password_a' SUPERUSER;
CREATE USER alice WITH PASSWORD 'password_a' NOSUPERUSER;
CREATE USER alice WITH PASSWORD 'password_a';
```

--------------------------------

### Snapshot examples

Source: https://docs.scylladb.com/manual/stable/operating-scylla/nodetool-commands/snapshot.html

Various usage examples for taking snapshots of all keyspaces, specific keyspaces, or individual tables.

```bash
> nodetool snapshot
Requested creating snapshot(s) for [all keyspaces] with snapshot name [1564577645291] and options {skipFlush=false}
Snapshot directory: 1564577645291
```

```bash
> nodetool snapshot mykeyspace;
Requested creating snapshot(s) for [mykeyspace] with snapshot name [1564577611409] and options {skipFlush=false}
Snapshot directory: 1564577611409
```

```bash
>nodetool snapshot -kc mykeyspace,yourkeyspace
Requested creating snapshot(s) for [mykeyspace,yourkeyspace] with snapshot name [1564639559884] and options {skipFlush=false}
Snapshot directory: 1564639559884
```

```bash
> nodetool snapshot --table heartrate mykeyspace;
Requested creating snapshot(s) for [mykeyspace] with snapshot name [1564577586524] and options {skipFlush=false}
Snapshot directory: 1564577586524
```

--------------------------------

### Example KMIP System Encryption Configuration

Source: https://docs.scylladb.com/branch-5.2/operating-scylla/security/encryption-at-rest.html

Example configuration using the KmipKeyProviderFactory.

```yaml
system_info_encryption:
   enabled: True
   cipher_algorithm: AES
   secret_key_strength: 128
   key_provider: KmipKeyProviderFactory
   kmip_host:  yourkmipServerIP.com
```

--------------------------------

### Auto-expanding Datacenters Example

Source: https://docs.scylladb.com/branch-5.2/cql/ddl.html

Example showing how to use replication_factor to auto-expand datacenters.

```cql
CREATE KEYSPACE excalibur
    WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor' : 3}

DESCRIBE KEYSPACE excalibur
    CREATE KEYSPACE excalibur WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1': '3', 'DC2': '3'} AND durable_writes = true;
```

--------------------------------

### Example System Encryption Configurations

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/encryption-at-rest.html

Examples of configuring system encryption using LocalFileSystemKeyProviderFactory or KmipKeyProviderFactory.

```yaml
system_info_encryption:
   enabled: True
   cipher_algorithm: AES
   secret_key_strength: 128
   key_provider: LocalFileSystemKeyProviderFactory
   secret_key_file: /path/to/systemKey.pem
```

```yaml
system_info_encryption:
   enabled: True
   cipher_algorithm: AES
   secret_key_strength: 128
   key_provider: KmipKeyProviderFactory
   kmip_host:  yourkmipServerIP.com
```

--------------------------------

### Nodetool compact usage examples

Source: https://docs.scylladb.com/manual/stable/operating-scylla/nodetool-commands/compact.html

Examples showing how to run compaction on all tables, a specific keyspace, or a specific table.

```bash
nodetool compact
nodetool compact keyspace1
nodetool compact keyspace1 standard1
```

--------------------------------

### Clone the Spark example repository

Source: https://docs.scylladb.com/branch-5.1/kb/scylla-and-spark-integration.html

Use this command to retrieve the source code for the example application.

```text
https://github.com/jsebrien/spark-tests
```

--------------------------------

### CREATE INDEX Examples

Source: https://docs.scylladb.com/manual/stable/cql/secondary-indexes.html

Various examples of creating secondary indexes, including the application of view properties.

```cql
CREATE INDEX userIndex ON NerdMovies (user);
CREATE INDEX ON Mutants (abilityId);

-- Create a secondary index called `catsIndex` on the table `Animals`.
-- The indexed column is `cats`. Both properties, `comment` and
-- `synchronous_updates`, are view properties, so the underlying materialized
-- view will be configured with: `comment = 'everyone likes cats'` and
-- `synchronous_updates = true`.
CREATE INDEX catsIndex ON Animals (cats) WITH comment = 'everyone likes cats' AND synchronous_updates = true;

-- Create a secondary index called `dogsIndex` on the same table, `Animals`.
-- This time, the indexed column is `dogs`. The property `gc_grace_seconds` is
-- a view property, so the underlying materialized view will be configured with
-- `gc_grace_seconds = 13`.
CREATE INDEX dogsIndex ON Animals (dogs) WITH gc_grace_seconds = 13;

-- The view property `CLUSTERING ORDER BY` is not supported by secondary indexes,
-- so this statement will be rejected by Scylla.
CREATE INDEX bearsIndex ON Animals (bears) WITH CLUSTERING ORDER BY (bears ASC);
```

--------------------------------

### Grant permissions examples

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/authorization.html

Examples of granting specific permissions to roles for keyspaces and tables.

```sql
GRANT SELECT ON ALL KEYSPACES TO data_reader;
```

```sql
GRANT MODIFY ON KEYSPACE keyspace1 TO data_writer;
```

```sql
GRANT DROP ON keyspace1.table1 TO schema_owner;
```

--------------------------------

### List Permissions Examples

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/authorization.html

Various examples of listing permissions for specific users and resources.

```cql
LIST ALL PERMISSIONS OF alice;
```

```cql
LIST ALL PERMISSIONS ON keyspace1.table1 OF bob;
```

```cql
LIST SELECT PERMISSIONS OF carlos;
```

--------------------------------

### Auto-expanding and Overriding Datacenter Example

Source: https://docs.scylladb.com/branch-5.2/cql/ddl.html

Example showing how to auto-expand datacenters while overriding a specific datacenter configuration.

```cql
CREATE KEYSPACE excalibur
    WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor' : 3, 'DC2': 2}

DESCRIBE KEYSPACE excalibur
    CREATE KEYSPACE excalibur WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1': '3', 'DC2': '2'} AND durable_writes = true;
```

--------------------------------

### Install Boto3 Python Library

Source: https://docs.scylladb.com/branch-5.2/alternator/getting-started.html

Install the AWS SDK for Python to interact with the DynamoDB-compatible API.

```bash
sudo pip install --upgrade boto3
```

--------------------------------

### Create Encrypted Table Example

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/encryption-at-rest.html

Specific example of creating a table using the LocalFileSystemKeyProviderFactory and a custom key file path.

```sql
CREATE TABLE data.atrest (pk text primary key, c0 int) WITH
  scylla_encryption_options = {
    'cipher_algorithm' : 'AES/ECB/PKCS5Padding',
    'secret_key_strength' : 128,
    'key_provider': 'LocalFileSystemKeyProviderFactory',
    'secret_key_file': '/etc/scylla/encryption_keys/data_encryption_keys'
  }
;
```

--------------------------------

### Create Secondary Index Examples

Source: https://docs.scylladb.com/branch-5.2/cql/secondary-indexes.html

Basic examples of creating secondary indexes on table columns.

```cql
CREATE INDEX userIndex ON NerdMovies (user);
CREATE INDEX ON Mutants (abilityId);
```

--------------------------------

### Create Local Secondary Index Example

Source: https://docs.scylladb.com/branch-5.2/cql/secondary-indexes.html

Example of creating a local secondary index where the partition key is specified.

```cql
CREATE TABLE menus (location text, name text, price float, dish_type text, PRIMARY KEY(location, name));
CREATE INDEX ON menus((location),dish_type);
```

--------------------------------

### Start ScyllaDB Node

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/procedures/cluster-management/add-node-to-cluster.html

Commands to start the Scylla service on a standard installation or within a Docker container.

```bash
sudo systemctl start scylla-server
```

```bash
docker exec -it some-scylla supervisorctl start scylla
```

--------------------------------

### Build the example application

Source: https://docs.scylladb.com/branch-5.1/kb/scylla-and-spark-integration.html

Compile the project using Maven.

```bash
mvn compile
```

--------------------------------

### Example Help Output

Source: https://docs.scylladb.com/branch-5.1/getting-started/install-scylla/config-commands.html

Sample output showing Scylla version information and available command line options.

```text
Scylla version 4.2.3-0.20210104.24346215c2 with build-id 0c8faf8bb8a3a0eda9337aad98ed3a6d814a4fa9 starting ...
command used: "scylla --help"
parsed command line options: [help]
Scylla options:
  -h [ --help ]                         show help message
  --version                             print version number and exit
  --options-file arg                    configuration file (i.e.
                                        <SCYLLA_HOME>/conf/scylla.yaml)
  --memtable-flush-static-shares arg    If set to higher than 0, ignore the
                                        controller's output and set the
                                        memtable shares statically. Do not set
                                        this unless you know what you are doing
                                        and suspect a problem in the
                                        controller. This option will be retired
                                        when the controller reaches more
                                        maturity
  --compaction-static-shares arg        If set to higher than 0, ignore the
                                        controller's output and set the
                                        compaction shares statically. Do not
                                        set this unless you know what you are
                                        doing and suspect a problem in the
                                        controller. This option will be retired
                                        when the controller reaches more
                                        maturity
```

--------------------------------

### Handle package conflicts with Apache Cassandra

Source: https://docs.scylladb.com/branch-5.2/faq.html

Example error message when attempting to install scylla-tools on a system with existing Cassandra packages.

```text
Unpacking scylla-tools (1.0.1-20160411.b9fe89b-ubuntu1) ...
dpkg: error processing archive /var/cache/apt/archives/scylla-tools_1.0.1-20160411.b9fe89b-ubuntu1_all.deb (--unpack):
trying to overwrite '/usr/bin/nodetool', which is also in package cassandra 2.1.4
```

--------------------------------

### Display scylla_swap_setup help

Source: https://docs.scylladb.com/branch-5.1/kb/set-up-swap.html

View available options and arguments for the swap configuration script.

```bash
scylla_swap_setup --help
usage: scylla_swap_setup [-h] [--swap-directory SWAP_DIRECTORY] [--swap-size SWAP_SIZE]

Configure swap for Scylla.

optional arguments:
 -h, --help            show this help message and exit
 --swap-directory SWAP_DIRECTORY
   specify swapfile directory
 --swap-size SWAP_SIZE
   specify swapfile size in GB
```

--------------------------------

### Display cluster status for a three-node multi-AZ setup

Source: https://docs.scylladb.com/branch-5.2/faq.html

Example output of a nodetool-style status command for a cluster with three nodes across three racks.

```text
Datacenter: DC1
Status=Up/Down
State=Normal/Leaving/Joining/Moving
--  Address        Load       Tokens  Owns (effective)                         Host ID         Rack
UN  192.168.1.201  118.82 KB  256     33.6%             8d5ed9f4-7764-4dbd-bad8-43fddce94b7c   A1
UN  192.168.1.202  111.82 KB  256     33.1%             8d5ed9f4-7764-4dbd-bad8-43fddce94b7c   B1
UN  192.168.1.203  114.82 KB  256     33.3%             8d5ed9f4-7764-4dbd-bad8-43fddce94b7c   C1
```

--------------------------------

### Run ScyllaDB setup script

Source: https://docs.scylladb.com/manual/stable/getting-started/install-scylla/install-on-linux.html

Executes the setup script to tune system settings and generate storage configuration files.

```bash
sudo scylla_setup
```

--------------------------------

### Install ScyllaDB with Web Installer

Source: https://docs.scylladb.com/branch-5.1/getting-started/install-scylla/scylla-web-installer.html

Executes the default installation script to install the latest official version of ScyllaDB Open Source.

```bash
curl -sSf get.scylladb.com/server | sudo bash
```

--------------------------------

### Install AssemblyScript

Source: https://docs.scylladb.com/manual/stable/cql/wasm.html

Command to install the AssemblyScript compiler.

```bash
npm install -g assemblyscript
```

--------------------------------

### Upgrade Scylla via Unified Installer

Source: https://docs.scylladb.com/branch-5.1/getting-started/install-scylla/unified-installer.html

Use the install script to upgrade the Scylla installation. Note that scylla-jmx and scylla-tools must be upgraded separately.

```bash
./install.sh --upgrade
```

```bash
./install.sh --upgrade --nonroot
```

--------------------------------

### Create Role Examples

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/authorization.html

Examples of creating roles with various configurations, including passwords, login privileges, and custom options.

```cql
CREATE ROLE new_role;
CREATE ROLE alice WITH PASSWORD = 'password_a' AND LOGIN = true;
CREATE ROLE bob WITH PASSWORD = 'password_b' AND LOGIN = true AND SUPERUSER = true;
CREATE ROLE carlos WITH OPTIONS = { 'custom_option1' : 'option1_value', 'custom_option2' : 99 };
```

--------------------------------

### Run scylla_swap_setup

Source: https://docs.scylladb.com/branch-5.1/kb/set-up-swap.html

Execute the script to configure swap with a specific directory and size.

```bash
sudo scylla_swap_setup --swap-directory /tmp/swp --swap-size SWAP_SIZE 500
```

--------------------------------

### CQL CREATE TABLE Examples

Source: https://docs.scylladb.com/branch-5.2/cql/ddl.html

Various examples demonstrating table creation with different primary key structures, clustering orders, and table options.

```cql
 CREATE TABLE monkeySpecies (
     species text PRIMARY KEY,
     common_name text,
     population varint,
     average_size int
 ) WITH comment='Important biological records'
    AND read_repair_chance = 1.0;

 CREATE TABLE timeline (
     userid uuid,
     posted_month int,
     posted_time uuid,
     body text,
     posted_by text,
     PRIMARY KEY (userid, posted_month, posted_time)
 ) WITH compaction = { 'class' : 'LeveledCompactionStrategy' };

 CREATE TABLE loads (
     machine inet,
     cpu int,
     mtime timeuuid,
     load float,
     PRIMARY KEY ((machine, cpu), mtime)
 ) WITH CLUSTERING ORDER BY (mtime DESC);

 CREATE TABLE users_picture (
     userid uuid,
     pictureid uuid,
     body text,
     posted_by text,
     PRIMARY KEY (userid, pictureid, posted_by)
 ) WITH compression = {'sstable_compression': 'LZ4Compressor'};


 CREATE TABLE data_atrest (
     pk text PRIMARY KEY,
     c0 int
 ) WITH scylla_encryption_options = {
    'cipher_algorithm' : 'AES/ECB/PKCS5Padding',
    'secret_key_strength' : 128,
    'key_provider': 'LocalFileSystemKeyProviderFactory',
    'secret_key_file': '/etc/scylla/data_encryption_keys/secret_key'};

CREATE TABLE caching (
                 k int PRIMARY KEY,
                 v1 int,
                 v2 int,
             ) WITH caching = {'enabled': 'true'};
```

--------------------------------

### Start Node After Rollback

Source: https://docs.scylladb.com/manual/stable/upgrade/upgrade-guides/upgrade-guide-from-2026.x.y-to-2026.x.z.html

Command to start the ScyllaDB service after a rollback.

```bash
sudo service scylla-server start
```

--------------------------------

### Configure APT Repository for Debian/Ubuntu

Source: https://docs.scylladb.com/manual/stable/getting-started/install-scylla/install-on-linux.html

Commands to create the keyring directory, import the GPG key, and add the ScyllaDB repository source.

```bash
sudo mkdir -p /etc/apt/keyrings
```

```bash
sudo gpg --homedir /tmp --no-default-keyring --keyring /tmp/temp.gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys c503c686b007f39e
sudo gpg --homedir /tmp --no-default-keyring --keyring /tmp/temp.gpg --export --armor c503c686b007f39e | gpg --dearmor > /etc/apt/keyrings/scylladb.gpg
```

```bash
sudo wget -O /etc/apt/sources.list.d/scylla.list https://downloads.scylladb.com/deb/debian/scylla-2026.2.list
```

--------------------------------

### Drop Keyspace Example

Source: https://docs.scylladb.com/manual/stable/cql/ddl.html

Example of dropping a keyspace named Excelsior.

```cql
DROP KEYSPACE Excelsior;
```

--------------------------------

### Example output of system.clients query

Source: https://docs.scylladb.com/branch-5.1/troubleshooting/clients-table.html

Sample output showing the address and port columns for active connections.

```text
address    | port
------------+-------
172.17.0.2 | 33296
172.17.0.2 | 33298
```

--------------------------------

### Revoke permissions examples

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/authorization.html

Examples of revoking specific permissions from roles.

```sql
REVOKE SELECT ON ALL KEYSPACES FROM data_reader;
REVOKE MODIFY ON KEYSPACE keyspace1 FROM data_writer;
REVOKE DROP ON keyspace1.table1 FROM schema_owner;
REVOKE DESCRIBE ON ALL USERS FROM user_admin;
```

--------------------------------

### Node Startup Log Entry

Source: https://docs.scylladb.com/manual/stable/features/cdc/cdc-stream-changes.html

Example log entry showing the ScyllaDB version and startup time.

```text
INFO  2020-02-06 17:59:35,087 [shard 0] init - ScyllaDB version 666.development-0.20200206.9eae0b57a with build-id 052adc1eb0601af2 starting ...
```

--------------------------------

### Install ScyllaDB on Debian/Ubuntu

Source: https://docs.scylladb.com/manual/stable/getting-started/install-scylla/install-on-linux.html

Commands to update the package list and install ScyllaDB.

```bash
sudo apt-get update
sudo apt-get install -y scylla
```

--------------------------------

### Example 1: CPUSET and perftune configuration

Source: https://docs.scylladb.com/manual/stable/kb/customizing-cpuset.html

Configures ScyllaDB on CPUs 3, 4, 5 with IRQs on the same CPUs, allowing other applications to use eth5 for network optimizations.

```bash
CPUSET="--cpuset 3,4,5 "
```

```yaml
cpu_mask: '0xffff'
dir:
- /var/lib/scylla
irq_cpu_mask: '0x38'
nic:
- eth5
tune:
- net
- disks
```

--------------------------------

### Nodetool tablestats example

Source: https://docs.scylladb.com/manual/stable/operating-scylla/nodetool-commands/tablestats.html

Example usage and output format for the tablestats command.

```bash
nodetool tablestats
```

```text
Keyspace: keyspace1
Read Count: 0
Read Latency: NaN ms.
Write Count: 41656
Write Latency: 0.016199467063568274 ms.
Pending Flushes: 0
Table: standard1
SSTable count: 17
SSTables in each level: [ ]
Space used (live): 28331544
Space used (total): 38060888
Space used by snapshots (total): 0
Off heap memory used (total): 5505072
SSTable Compression Ratio: 0.0
Number of partitions (estimate): 26829
Memtable cell count: 4868
Memtable data size: 4128083
Memtable off heap memory used: 4980736
Memtable switch count: 0
Local read count: 0
Local read latency: NaN ms
Local write count: 41656
Local write latency: 0.014 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 524336
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 259
Compacted partition maximum bytes: 310
Compacted partition mean bytes: 310
Average live cells per slice (last five minutes): 0.0
Maximum live cells per slice (last five minutes): 0.0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0.0
```

--------------------------------

### Start Spark Worker

Source: https://docs.scylladb.com/branch-5.1/kb/scylla-and-spark-integration.html

Run this command after the master is active to start a worker node.

```bash
./sbin/start-slave.sh spark://localhost:7077
```

--------------------------------

### Describe and Create Keyspace Before Update

Source: https://docs.scylladb.com/stable/operating-scylla/procedures/cluster-management/update-topology-strategy-from-simple-to-network.html

Displays the initial state of a keyspace using SimpleStrategy.

```CQL
DESCRIBE KEYSPACE mykeyspace;
CREATE KEYSPACE mykespace WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor': '3'};
```

--------------------------------

### Repairing by start token

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/nodetool-commands/repair.html

Executes a repair on a range of nodes starting with the specified token.

```bash
nodetool repair -st 10474535988
nodetool repair --start-token
```

--------------------------------

### Decompress SSTable Example

Source: https://docs.scylladb.com/manual/stable/operating-scylla/admin-tools/scylla-sstable.html

Example of the input and output filenames when running the decompress operation.

```text
md-12311-big-Data.db
```

```text
md-12311-big-Data.db.decompressed
```

--------------------------------

### Create ScyllaDB Data Directories on Host

Source: https://docs.scylladb.com/manual/stable/operating-scylla/procedures/tips/best-practices-scylla-on-docker.html

Prepare the host filesystem for ScyllaDB data storage by creating the necessary directories.

```bash
sudo mkdir -p /var/lib/scylla/data /var/lib/scylla/commitlog
```

--------------------------------

### Encrypt Existing Table Example

Source: https://docs.scylladb.com/branch-5.1/operating-scylla/security/encryption-at-rest.html

Example of applying encryption settings to a specific table.

```cql
ALTER TABLE data.atrest (pk text primary key, c0 int) WITH
  scylla_encryption_options = {
    'cipher_algorithm' : 'AES/ECB/PKCS5Padding',
    'secret_key_strength' : 192,
    'key_provider': 'LocalFileSystemKeyProviderFactory',
    'secret_key_file': '/etc/scylla/encryption_keys/data_encryption_keys'
  }
;
```

--------------------------------

### Prepare Scylla Keyspace

Source: https://docs.scylladb.com/branch-5.1/kb/scylla-and-spark-integration.html

Create the keyspace for the Spark example application.

```cql
CREATE KEYSPACE spark_example WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor': 1};
USE spark_example;
```

--------------------------------

### Install EPEL Repository on CentOS/RHEL

Source: https://docs.scylladb.com/manual/stable/getting-started/install-scylla/install-on-linux.html

Commands to install the EPEL repository based on the OS version.

```bash
sudo yum install epel-release
```

```bash
sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
```

```bash
sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm
```

--------------------------------

### Example Output for Supported Features

Source: https://docs.scylladb.com/branch-5.1/architecture/raft.html

Sample output showing the list of supported features when Raft is enabled.

```text
supported_features
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CDC,CDC_GENERATIONS_V2,COMPUTED_COLUMNS,CORRECT_COUNTER_ORDER,CORRECT_IDX_TOKEN_IN_SECONDARY_INDEX,CORRECT_NON_COMPOUND_RANGE_TOMBSTONES,CORRECT_STATIC_COMPACT_IN_MC,COUNTERS,DIGEST_FOR_NULL_VALUES,DIGEST_INSENSITIVE_TO_EXPIRY,DIGEST_MULTIPARTITION_READ,HINTED_HANDOFF_SEPARATE_CONNECTION,INDEXES,LARGE_PARTITIONS,LA_SSTABLE_FORMAT,LWT,MATERIALIZED_VIEWS,MC_SSTABLE_FORMAT,MD_SSTABLE_FORMAT,ME_SSTABLE_FORMAT,NONFROZEN_UDTS,PARALLELIZED_AGGREGATION,PER_TABLE_CACHING,PER_TABLE_PARTITIONERS,RANGE_SCAN_DATA_VARIANT,RANGE_TOMBSTONES,ROLES,ROW_LEVEL_REPAIR,SCHEMA_TABLES_V3,SEPARATE_PAGE_SIZE_AND_SAFETY_LIMIT,STREAM_WITH_RPC_STREAM,SUPPORTS_RAFT_CLUSTER_MANAGEMENT,TOMBSTONE_GC_OPTIONS,TRUNCATION_TABLE,UDA,UNBOUNDED_RANGE_TOMBSTONES,VIEW_VIRTUAL_COLUMNS,WRITE_FAILURE_REPLY,XXHASH
```

--------------------------------

### Install PyYAML for Python 3.6

Source: https://docs.scylladb.com/branch-5.1/troubleshooting/python-error-no-module-named-yaml.html

Install the missing PyYAML dependency to resolve the import error.

```bash
sudo yum install python36-PyYAML -y
```

--------------------------------

### Uninstall Scylla via Unified Installer

Source: https://docs.scylladb.com/branch-5.1/getting-started/install-scylla/unified-installer.html

Use the uninstall script to remove the Scylla installation.

```bash
sudo ./uninstall.sh
```

```bash
./uninstall.sh --nonroot
```

--------------------------------

### Generate new configuration

Source: https://docs.scylladb.com/branch-5.1/kb/perftune-modes-sync.html

Run the scylla_sysconfig_setup utility to create a new configuration based on the specified NIC and directory paths.

```bash
sudo scylla_sysconfig_setup --nic eth5 --homedir /var/lib/scylla --confdir /etc/scylla
```

--------------------------------

### Start and Validate ScyllaDB Node

Source: https://docs.scylladb.com/manual/stable/upgrade/upgrade-guides/upgrade-guide-from-2026.x.y-to-2026.x.z.html

Commands to start the service and verify the node status and version.

```bash
sudo service start scylla-server
```

```bash
nodetool status
curl -X GET "http://localhost:10000/storage_service/scylla_release_version"
journalctl _COMM=scylla
```
Tokens:
Raw