Hi Jean, Answers in line to be sure to be exhaustive:
- how can I restore the data directory structure in order to copy my snapshots at the right position? --> making a script to do it and testing it I would say. basically under any table repo you have a "snapshots/snapshot_name" directory (snapshot_name is timestamp if not specified off the top of my head..) and then your sstables. - is it possible to recreate the schema on one node? --> The easiest way that come to my mind is to set "auto_bootstrap: false" on a node not already in the ring. If you have trouble with the schema of a node in the ring run a "nodetool resetlocalschema" - how can I avoid the node from streaming from the other nodes? --> See above (auto_bootstrap: false). BTW, option might not be present at all, just add it. - must I also have the snapshot of the system tables in order to restore a node from only the snapshot of my tables? --> just you user table. Yet remember that snapshot is per node and as such you will just have part of the data this node use to hold. meaning that if the new node have different tokens, there will be unused data + missing data for sure. Basically when a node is down I use to remove it, repair the cluster, and bootstap it (auto_bootstrap: true). Streams are part of Cassandra. I accept that. An other solution would be to "replace" the node --> http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_replace_node_t.html C*heers, Alain 2015-06-25 17:07 GMT+02:00 Jean Tremblay <jean.tremb...@zen-innovations.com> : > Hi, > > I am testing snapshot restore procedures in case of a major catastrophe > on our cluster. I’m using Cassandra 2.1.7 with RF:3 > > The scenario that I am trying to solve is how to quickly get one node > back to work after its disk failed and lost all its data assuming that the > only thing I have is its snapshots. > > The procedure that I’m following is the one explained here: > http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_backup_snapshot_restore_t.html > > I can do a snapshot that is straight forward. > My problem is in the restore of the snapshot. > > If I restart Cassandra with an empty data directory the node will > bootstrap. > Bootstrap is very nice, since it recreate the schema and reload the data > from its neighbour. > But this is quite heavy traffic and quite a slow process. > > My questions are: > > - how can I restore the data directory structure in order to copy my > snapshots at the right position? > - is it possible to recreate the schema on one node? > - how can I avoid the node from streaming from the other nodes? > - must I also have the snapshot of the system tables in order to restore a > node from only the snapshot of my tables? > > Thanks for your comments. > > Jean > > > > >
