MIgrating from self-managed Cassandra to Keyspaces

Question

Running a Cassandra cluster on Kubernetes and is considering a move to Keyspaces.

It is unclear on how to export the data from the existing cluster and import it into Keyspaces?

Would they just use cqlsh COPY?

Accepted Answer

Yes,  use `cqlsh`:

https://aws.amazon.com/blogs/database/loading-data-into-amazon-mcs-with-cqlsh/

At the moment, doesn't look like Keyspaces is a supported target for DMS.

Answer

Yes, but is not the only option.
- for small datasets or tables you can [load data into Amazon Keyspaces using `cqlsh`](https://docs.aws.amazon.com/keyspaces/latest/devguide/bulk-upload.html). 
- for production workloads with large datasets, you can [use the DataStax Bulk Loader for Apache Cassandra to load data into Amazon Keyspaces](https://docs.aws.amazon.com/keyspaces/latest/devguide/dsbulk-upload.html) using the `dsbulk` command.

MIgrating from self-managed Cassandra to Keyspaces

相關內容