my guess (from what I learnt on this forum): you probably have to manually create the schema on the new cluster. shutdown new cluster. overwrite the column family files with your backup on all nodes in the new cluster, then boot up.
You are right and now my question is how I restore on test cluster. Do I need to create column families and then copy snapshot on each directory?
Thanks & Regards
On 12/4/2012 9:09 PM, Tomas Nunez wrote:
I think he was talking about the "fragmentation" of the snapshot. In cassandra 1.0.X all ColumnFamilies are in the same directory, but in cassandra 1.1.X each ColumnFamily is in its own directory, and snapshots of each ColumnFamily are inside this directory.
1.0.X Snapshot directory:/cassandra/data/<KeySpace>/snapshots/<cassandra_bkup_files>
1.1.X Snapshot directory/cassandra/data/<KeySpace>/<ColumnFamily>/snapshots/<cassandra_bkup_files>
In 1.0.X you can restore a Keyspace backup by copying just one directory. In 1.1.X it seems you need to copy one directory for each ColumnFamily, which is a little more complicated.
2012/12/1 Tyler Hobbs <email@example.com>
The nodetool snapshot command has keyspace and column family options (from nodetool --help):
snapshot [keyspaces...] -cf [columnfamilyName] -t [snapshotName] - Take a snapshot of the optionally specified column family of the specified keyspaces using optional name snapshotName
On Wed, Nov 28, 2012 at 5:40 AM, Adeel Akbar <firstname.lastname@example.org> wrote:
I have Cassandra 1.1.4 cluster with 2 nodes. I need to take backup and restore on staging for testing purpose. I have taken snapshot with below mentioned command but It created snapshot on every Keyspace's column family. Is there any other way to take backup and restore quick.
/opt/apache-cassandra-1.1.4/bin/nodetool -h localhost snapshot -t cassandra_bkup
Thanks & Regards
Tomàs Núñez IT-Sysprod Tel. + 34 93 159 31 00 Fax. + 34 93 396 18 52 Llull, 95-97, 2º planta, 08005 Barcelona Skype: tomas.nunez.groupalia email@example.com Twitter Facebook Linkedin