Backing up a Cassandra SSTable via SSTabledump

This article will explain how you can back up a specific Cassandra SSTable using the SSTabledump tool.

What is SStabledump?

SStabledump is a tool to converts a Cassandra SSTable into a JSON format file.


  • To dump a Cassandra SSTable, you must supply exactly one sstable.

  • Cassandra must be stopped before this tool is executed, or unexpected results will occur. Note: the script does not verify that Cassandra is stopped. (We recommend you to execute "nodetool flush" before dumping a Cassandra SSTable if you prefer not to stop the Cassandra server.)

1. Locate your target deployment

Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.

2. Go to the Shell / SSH page

Click Manage > Shell / SSH tab to go to the Shell / SSH page.

Then click the connect icon to open the shell interface.

3. Execute nodetool flush

Execute the "nodetool flush" command. This will flush one or more tables from the memtable to SSTables on disk.

4. Dump a Cassandra SSTable

Dump the entire table without any options.

For example:

cd /cloudclusters/cassandra/data/keytest7/table1-074ffb00a26911eb8477b3953cc438c9

sstabledump md-1-big-Data.db > ./backups/keytest7.table1

cat ./backups/keytest7.table1

Copyright © 2021 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 04/26/2021

results matching ""

    No results matching ""