CODEWITHSUNDEEP
cassandra
Joom187
Joom187

Reputation: 305

Cassandra backup system keyspaces

I have 3 node cassandra cluster and I have a script which backup all of the keyspaces, but when it comes to restore on fresh cluster, data keyspaces restored correctly, but system_* keyspaces not. So it is necessary to backup system keyspaces in cassandra?

Upvotes: 1

Views: 332

Answers (2)

Carlos Monroy Nieblas
Carlos Monroy Nieblas

Reputation: 2283

You will need to backup the keyspace system_schema at the same time, as it will contain the definition of keyspaces, tables, and columns. The other system* keyspaces should be left untouched.

Upvotes: 1

LetsNoSQL
LetsNoSQL

Reputation: 1538

Fresh cluster makes own setup like token ranges etc based on configurations.you can restore the cluster on new cluster but you need to create schema and configuration same as old cluster. There is many ways to take backup and restore procedure based on requirements as below:- https://docs.datastax.com/en/archived/cassandra/3.0/cassandra/operations/opsBackupRestore.html

Upvotes: 0

Related Questions