cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre-Yves Ritschard <>
Subject Re: going back in time
Date Tue, 24 Jul 2012 13:44:34 GMT
<> writes:

>   One of the scenarios I have to have in account for a small Cassandra cluster (N=4)
> restoring the data back in time. I will have full backups for 15 days, and it's possible
> that I will need to restore, let's say, the data from 10 days ago (don't ask, I'm not

> going into the details why). 
>   I know/suspect that restores by KeySpace/ColumnFamily are possible (we haven't tested

> yet), but I wonder if it would there any side effects of stopping all the nodes 
> (assuming cut to the other KS are OK), restoring the SSTables, and starting the nodes

> one by one.
>   So far we're thinking in RF=4, but also in RF=3 or at least RF<N in the future.
> all this crazy talk or is it possible? Any side effects in the KS system and/or indexes

> to have in account?

Snapshot and restores are great for point in time recovery. There's no
particular side-effect if you're willing to accept the downtime.

If you don't want to take your whole cluster offline you can use
sstableloader as well.

View raw message