BACKING UP DATA IN CASSANDRA-
All keyspaces snapshot-
- You can back up all the keyspaces on a node with the following command in the terminal:
nodetool snapshot
Requested creating snapshot(s) for [all keyspaces] with snapshot name [1499019048455] and options {skipFlush=false}
Snapshot directory: 1499019048455
- By default the location of the backed-up file is:
In general, the snapshot directory is /var/lib/data/keyspace_name/table_name–UUID/snapshots/1496225100
Ex: /var/lib/cassandra/data/admatic/emp-20e70b2030d511e8bdf32b06aa808981/snapshots/26-03-18
Single Keyspace backup-
- Command: nodetool snapshot -t
Ex: nodetool snapshot -t 26-03-18 admatic
Requested creating snapshot(s) for [university] with snapshot name [26-03-18]
Snapshot directory: 26-03-18
Single table snapshot-
general-
nodetool snapshot --table
Ex: nodetool snapshot --table emp admatic
Performing incremental backup-
Once you create a system-wide snapshot, you can employ Cassandra’s incremental backups feature to back up data that has been updated since the full snapshot was made
command to enable incremental backup: nodetool enable backup
disable incr. backup: nodetool disable backup