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
Hi,
I have TTL set on my tables which will expire my table records based on set value. I want to move already stored old data from Cassandra table to S3 so that I can still use that data if needed from S3 once it is expired in cassandra tables.
I need some thoughts on how to do it in a better way so that existing read and write traffic is not impacted on that table from which I am moving the old data to S3.
Thanks!
@tsingh2k15_176037 Once the data has expired, you will no longer be able to read them via CQL. Even when the data is still on disk, the tombstones will prevent a replica from returning the data. Eventually, deleted (expired) data that is past the gc_grace_seconds will get compacted out of the SSTables. For more information, see How is data deleted.
On the other hand if you want to archive SSTables to S3, you can create backups using nodetool snapshot then copy the snapshots to S3. For more information, see Taking a snapshot. Cheers!
4 People are following this question.
