BACKING UP DATA IN CASSANDRA-

All keyspaces snapshot-

  1. 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
  1. 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-

  1. 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

results matching ""

    No results matching ""