Cassandra – delete old data from data table

Solved930 viewsCassandra
0
0 Comments

Hi all,

We have a DMA with massive amount of data at Cassandra (from trending). Due to this, we are suffering some problems when a backup is done.

Do you know if Cassandra Cleaner tool is the safest way to delete some old data from here?

Please note that only data from that DMA should be removed as it is part of a cluster and we don't want to use "time to live" options as we will delete data from all DMAs

Thanks!

Pedro

Pedro Sánchez [DevOps Advocate] Selected answer as best 26th July 2022

1 Answer

1
13.52K 1 Comment

Hi Pedro,

The Cassandra cleaner will not remove trend data, it will only clean up historical alarm data.

This means that running the tool will not help in this case.
I'm not aware of any alternatives except for manual intervention through queries

(which should only be done by a subject matter expert, ideally from Skyline, as incorrect queries can lead to data loss or system malfunctions).

Pedro Sánchez [DevOps Advocate] Posted new comment 26th July 2022
Pedro Sánchez [DevOps Advocate] commented

Thank you, Ive! we will ask for some help then 😉
You are viewing 1 out of 1 answers, click here to view all answers.