CODEWITHSUNDEEP
cassandracassandra-3.0recoverydata-recovery
asliwinski
asliwinski

Reputation: 1704

Cassandra - recovery of data after accidental delete

As the data in case of Cassandra is physically removed during compaction, is it possible to access the recently deleted data in any way? I'm looking for something similar to Oracle Flashback feature (AS OF TIMESTAMP).

Also, I can see the pieces of deleted data in the relevant commit log file, however it's obviously unreadable. Is it possible to convert this file to a more readable format?

Upvotes: 0

Views: 1242

Answers (1)

Christophe Schmitz
Christophe Schmitz

Reputation: 2996

You will want to execute a restore from your commitlog. The safest is to copy the commitlog to a new cluster (with same schema), and restore following the instructions (comments) from commitlog_archiving.properties file. In your case, you will want to set restore_point_in_time to a time between your insert and your delete.

Upvotes: 1

Related Questions