Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

yashwanth.kondeti@verizon.com avatar image
yashwanth.kondeti@verizon.com asked Erick Ramirez answered

Is there a way to exclude a list of tables from the nodetool snapshot command?

Hi Datastax Community,

I am currently running nodetool snapshot (using cronjob) on my keyspace every 2 hours for backup purposes. The keyspace has over 50 tables, out of which 2 are used for testing and are very large. I don't want to take the snapshots of these 2 large tables as they are only for testing purpose and also would take lot of space. So instead of manually listing remaining 48 tables for which to take snapshot on, I am trying to find a way to exclude these 2 tables from the snapshot command. Is there a possibility to do this? I am looking for a command something like below:

nodetool snapshot <keyspace> --exclude <large_table1>, <large_table2>

backup
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

Unfortunately no, there isn't a way to exclude tables from the snapshot.

As you already pointed out, you can only "opt-in" by specifying the table name. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.