Originally from the User Slack
@YGwan: Hello, I would like to ask you a question about SyllaDB Data Migration. I would like to migrate all the data in the table in a particular keyspace to a different syllaDB server. When I use the nodepool snapshot command, not all data is migrated, only certain parts of data are migrated. Each server is using the same version of syllaDB. Is there a best way to migrate these data?
@Patrick_Bossman: You can use Scylla manager to backup on one scylla and restore a keyspace in another.
You could also use Scylla Migrator, which would read using CQL from one Scylla to another. It operates one table at a time.
@avi: nodetool snapshot should contain all the data up to the point in time where you took the snapshot
@YGwan: @Patrick_Bossman
> You can use Scylla manager to backup on one scylla and restore a keyspace in another.
> You could also use Scylla migrator, which would read using CQL from one Scylla to another. It operates one table at a time.
Do you have any reference materials for this part? I also checked the manager and the migrator, but I couldn’t find any reference materials related to data migration.
@Patrick_Bossman: For Scylla manager, a restore takes the backup and … Restores it to the target. So the migration when the source of the backup is restored to a different target cluster, that’s the data movement.
@YGwan: > @avi
nodetool snapshot should contain all the data up to the point in time where you took the snapshot
what’s mean “all the data up to the point in time”
If I use the nodetool snapshot command to create a snapshot of a particular keyspace and table, isn’t it creating a snapshot of the entire data? Of course, I did the nodetool refresh command.
@Patrick_Bossman: Scylla migrator is built on spark and uses CQL to move data from a source cluster to a target cluster.
https://migrator.docs.scylladb.com/stable/
ScyllaDB Migrator Documentation | ScyllaDB Docs
https://manager.docs.scylladb.com/stable/restore/
Restore | ScyllaDB Docs
@YGwan: > For Scylla manager, a restore takes the backup and … Restores it to the target. So the migration when the source of the backup is restored to a different target cluster, that’s the data movement.
Let’s check out the data backup using the scylla manager. Thank you.
> Scylla migrator is built on spark and uses CQL to move data from a source cluster to a target cluster.
thanks!!. i try to check this link