Taking a Global Snapshot of Cassandra Clusters
Taking a Global Snapshot of Cassandra Clusters
Taking a keyspace as a dump can give you a view of your entire Cassandra cluster. Using a mix of built-in and third-party tools makes it possible.
Join the DZone community and get the full member experience.
Join For FreeRavenDB vs MongoDB: Which is Better? This White Paper compares the two leading NoSQL Document Databases on 9 features to find out which is the best solution for your next project.
Snapshots are taken per node using the nodetool snapshot command. To take a global snapshot, run the nodetool snapshot command using a parallel ssh utility, such as pssh.
A snapshot first flushes all in-memory writes to the disk, then makes a hard link of the SSTable files for each keyspace. You must have enough free disk space on the node to accommodate making snapshots of your data files. A single snapshot requires little disk space, but snapshots can cause your disk usage to grow more quickly over time because a snapshot prevents old, obsolete data files from being deleted. After the snapshot is complete, you can move the backup files to another location if needed, or you can leave them in place.
Note: Cassandra can only restore data from a snapshot when the table schema exists. It is recommended that you also backup the schema.Procedure
Run the nodetool snapshot command, specifying the hostname, JMX port, and keyspace. For example:
$ nodetool -h localhost -p 7199 snapshot mykeyspaceResults
The snapshot is created in the data_directory_location/keyspace_name/table_name–UUID/snapshots/snapshot_name directory. Each snapshot directory contains numerous .db files that contain the data at the time of the snapshot. Such as:
Package Installations
/var/lib/cassandra/data/mykeyspace/users-081a1500136111e482d09318a3b15cc2/snapshots/1406227071618/mykeyspace-users-ka-1-Data.dbTarball Installations
install_location/data/data/mykeyspace/users-081a1500136111e482d09318a3b15cc2/snapshots/1406227071618/mykeyspace-users-ka-1-Data.db
Taking a Global Snapshot
As stated earlier, a global snapshot can be taken using the pssh tool. So let us configure this tool first.
The steps for configuring the pssh are:
- Install the pssh tool using the following command
sudo apt-get install python-pip sudo pip install pssh - Create a hosts file that contains all the ip’s of the nodes present in that cluster and name it something like
pssh-hosts.
It should look something like this:192.168.2.123 192.168.2.125 192.168.2.120 - Now run the following command so that the snapshots get created on each and every node:
pssh -h pssh-hosts -P "/root/cassandra/bin/nodetool -h localhost -p 7199 snapshot "
Now you've taken the dump of data on each node. You can download it using secure copy and restore it accordingly. I am still working on automating the process of downloading the dump, but I will update you all as soon as it is done!
I hope youve enjoyed this article! If you have any queries, ping me here or on Twitter, and I'll be happy to help you out.
Get comfortable using NoSQL in a free, self-directed learning course provided by RavenDB. Learn to create fully-functional real-world programs on NoSQL Databases. Register today.
Like This Article? Read More From DZone
Published at DZone with permission of Shivansh Srivastava , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}