#scylla #cql #toolkit #database-table #run-command

app scylladb-dev-toolkit

Developer Toolkit for ScyllaDB

2 unstable releases

0.2.0 Aug 21, 2024
0.1.0 Jul 29, 2024

#486 in Database interfaces

Download history 116/week @ 2024-07-27 6/week @ 2024-08-03 6/week @ 2024-08-10 147/week @ 2024-08-17 11/week @ 2024-08-24

164 downloads per month

MIT/Apache

17KB
260 lines

ScyllaDB Daniel Dev Toolkit

This is just probably a messy project to create things to make my workaround ScyllaDB and Rust environment easier.

Don't expect great things from this code - Daniel Reis

How to use

Select an action from the list below and run the command on the terminal:

  • keyspace
  • multi-dc (WIP)
  • table-action

Features

Create a new keyspace without authentication on CQLSH

A quick way to set up a Keyspace with a given name and replication factor. Also supports flags for tablets in case you need to use features which is not supported by Tablets yet (e.g: LWT and CDC):

| Option                                      | Description                                | Default             |
|---------------------------------------------|--------------------------------------------|---------------------|
| `--host <HOST>`                             | Scylla Host                                | `localhost:9042`    |
| `-u, --user <USER>`                         |                                            |                     |
| `-p, --password <PASSWORD>`                 |                                            |                     |
| `-t, --timeout <TIMEOUT>`                   |                                            | `3`                 |
| `-k, --keyspace <KEYSPACE>`                 | Keyspace name                              | `mykeyspace`        |
| `-r, --replication-factor <REPLICATION_FACTOR>` | Replication factor                        | `3`              |
| `-d, --drop`                                | Drop the keyspace if it already exists     |                     |
| `--without-tablets`                         |                                            |                     |
| `-h, --help`                                | Print help                                 |                     |
toolkit keyspace --keyspace he4rtless_ks --replication-factor 1 --without-tablets 

Truncate or Drop specific tables with suffix

This feature is useful when you need to clean up your database from tables with a specific suffix.

| Option                                      | Description                                | Default             |
|---------------------------------------------|--------------------------------------------|---------------------|
| `--host <HOST>`                             | Scylla Host                                | `localhost:9042`
| `-u, --user <USER>`                         |                                            |                     |
| `-p, --password <PASSWORD>`                 |                                            |                     |
| `-t, --timeout <TIMEOUT>`                   |                                            | `3`                 |
| `-k, --keyspace <KEYSPACE>`                 | Keyspace name                              | `mykeyspace`        |
| `-s, --suffix <SUFFIX>`                     | Suffix to filter tables                    | `test`              |
| `-a, --action`                              | If you want to 1-truncate or 2-delete      |                     |
| `-h, --help`                                | Print help                                 |                     |
toolkit truncate --keyspace he4rtless_ks --suffix v1 --action 1

Setup multiple Schemas for testing purposes.

A simple way to alter tables which is in an already created ScyllaDB Cluster and enable it to be Multi-DC.

| Option                                      | Description                                | Default             |
|---------------------------------------------|--------------------------------------------|---------------------|
| `--host <HOST>`                             | Scylla Host                                | `localhost:9042`    |
| `-u, --user <USER>`                         |                                            |                     |
| `-p, --password <PASSWORD>`                 |                                            |                     |
| `-t, --timeout <TIMEOUT>`                   |                                            | `3`                 |
| `-r, --replication-factor <RF>`             | Replication factor                         | `3`                 |
| `-d, --dcs <DCS>`                           | Data centers (comma-separated)             | `DC1,DC2`           |
| `-k, --keyspace <KEYSPACE>`                 | Keyspace name                              | `mykeyspace`        |
| `-h, --help`                                | Print help                                 |                     |

toolkit multi-dc --keyspace he4rtless_ks --replication-factor 3 --dcs DC1,DC2

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Dependencies

~12–25MB
~297K SLoC