A Cassandra-compatible NoSQL data store.
Questions tagged [scylladb]
11 questions
3
votes
2 answers
Implementating user notifications list using Aerospike
I need to choose the right DB for a notifications system that needs to handle billions of notifications. The record structure is as follows:
[user_id, item_type, item_id, created_at, other_data]
The inserts are going to be in bulks up to hundreds…
Kaplan Ilya
- 173
- 2
- 7
3
votes
2 answers
Allocate space in Cassandra
We run a Cassandra cluster with 2 DC, 3 nodes each (2 RF). The state of the cluster is quite bad (never repaired) and the disks were getting full so we added additional nodes which after the bootstrap procedure joined successfully the cluster.…
Jibrilat
- 131
- 1
2
votes
2 answers
Can you restore a ScyllaDB from only a backup of /var/lib/scylla/data folder?
I had a single node scyllaDB which was lost, but only a backup of the /var/lib/scylla/data folder was done.
My question is, can a single node scylla be restored from only this backup? I already checked and the files don't contain any snapshots
perrohunter
- 121
- 2
2
votes
2 answers
Correct way to perform backup of Cassandra/Scylladb
What's the correct(advisable) method to backup a cassandra or scylladb so that we can restore it on development environment with ease?
Kokizzu
- 1,403
- 6
- 18
- 35
1
vote
1 answer
What are recycled-commitlogs?
Cassandra/ScyllaDB
I have a node with 51000+ recycled commitlogs and want to know if I can just blitz them.
I am Linux not Scylla/Cassandra but these are filling up a datadisk. Normal commitlogs appear to be created and used/removed so I am…
Hpoonis
- 11
- 1
1
vote
0 answers
After nodetool refresh number of records in the source is much larger than in the target instance
Restore snapshots to another cluster (migration)
source:
Scylla v. 4.4.1 on Kubernetes,
4 nodes e.g. a1,a2,a3,a4
target:
Scylla v. 5.4.6 - no Kubernetes installation
4 nodes e.g. b1,b2,b3,b4
Steps:
we built a cluster with the same number of…
ania wieczorek
- 11
- 1
1
vote
1 answer
Is there a full copy of data on each node if RF=3 and DC has 3 nodes?
When backing up a Scylla cluster (or cassandra for that matter) I understand that its best practice to take a snapshot of every node.
However if I have a 6 node distributed cluster spanning 2 datacenters with RF3 in each datacenter for the keyspace…
imbrian21
- 11
- 1
1
vote
1 answer
How do I manage Cassandra/Scylla snapshots?
I am new to Scylla, and I'm looking to setup a proper Backup & Restore solution.
I've just tested running nodetool snapshot -t my_backup, and see that what it does is create a snapshot folder caled my_backup, inside each keyspace & table…
Nuno
- 829
- 1
- 12
- 24
0
votes
1 answer
Unexpected Behavior with TimeWindowCompactionStrategy in ScyllaDB 6.1 Open Source
I’m using ScyllaDB 6.1 Open Source and have a table configured to store 30 days of data with the following compaction strategy:
compaction = {
'class': 'TimeWindowCompactionStrategy',
'compaction_window_size': '3',
'compaction_window_unit':…
Naman kaushik
- 11
- 1
0
votes
1 answer
Is a multi-table batch within the same node atomic and isolated?
Im trying to understand this.
cassandra batches are atomic always, and if the batch only modifies a single partition of a single table, then that batch is also isolated.
but what about multi table batches partitioned by the same key?
assume this…
0
votes
1 answer
How can I make (game_id, user_id) unique, yet (game_id, score) indexed/clustered, in ScyllaDB?
See this in ScyllaDB:
CREATE TABLE scores_leaderboards (
game_id int,
score int,
user_id bigint,
PRIMARY KEY (game_id, score, user_id)
) WITH CLUSTERING ORDER BY (score DESC);
The idea is that we can get the user IDs with the top…
Nuno
- 829
- 1
- 12
- 24