Here are my notes on how to make schema changes in 0.6:
# Empty the commitlog with "nodetool drain."
=> NOTE while this is running, the node will not accept writes.
# Shutdown Cassandra and verify that there is no remaining data in the
commitlog.
=> HOW to verify?
# Delete the sstable files (-Data.db, -Index.db, and -Filter.db) for any CFs
removed, and rename the files for any CFs that were renamed.
# Make necessary changes to your storage-conf.xml.
# Start Cassandra back up and your edits should take effect.
Related URLs:
http://wiki.apache.org/cassandra/FAQ#modify_cf_config
http://www.mail-archive.com/user@cassandra.apache.org/msg02498.html
HTH
Dave Viner
On Wed, Jul 7, 2010 at 11:39 PM, Peter Schuller <peter.schul...@infidyne.com
> wrote:
> > If I want to add a new Keyspace, does it mean I have to distribute my
> > storage-conf.xml to whole nodes? and restart whole nodes?
>
> I *think* that is the case in Cassandra 0.6, but I'll let someone else
> comment. In trunk/upcoming 7 there are live schema upgrades that
> propagate through the cluster:
>
> http://wiki.apache.org/cassandra/LiveSchemaUpdates
>
>
> --
> / Peter Schuller
>
