<mdione....@orange.com> writes: > One of the scenarios I have to have in account for a small Cassandra > cluster (N=4) is > 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. Is > 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.
