Seven NoSQL Databases in a Week

Restoring from a snapshot

Let's say that after taking a snapshot, one of our tables ends up with corrupted data for a particular user. The application team fixes the problem on their end, and simply asks for us to restore the logins_by_user table to the last snapshot.

First of all, let's take a look at the data in question:

cassdba@cqlsh> use packt ; 
cassdba@cqlsh:packt> SELECT * FROM logins_by_user WHERE user_id='avery' LIMIT 1; 
 
 user_id | login_datetime                  | origin_ip 
---------+---------------------------------+----------- 
   avery | 1970-01-01 19:48:33.945000+0000 | 10.0.15.2 
 
(1 rows) 

Obviously, the new user did not recently log in on January 1, 1970, so our corrupted data has been presented to us. To ensure that we are starting from a clean ...