Re: Is it possible to create a schema before a Cassandra node starts up ?

[Rob Coli]

On Fri, Sep 14, 2012 at 7:05 AM, Xu, Zaili <z...@pershing.com> wrote:
> I am pretty new to Cassandra. I have a script that needs to set up a schema
> first before starting up the cassandra node. Is this possible ? Can I create
> the schema directly on cassandra storage and then when the node starts up it
> will pick up the schema ?

Aaron gave you the scientific answer, which is that you can't load
schema without starting a node.

However if you :

1) start a node for the first time
2) load schema
3) call nodetool drain so all system keyspace CFs are guaranteed to be
flushed to sstables
4) then, from your script, start that node (or a node with identical
configuration) using the flushed system sstables ("directly on the
storage")

You can "set up a schema before starting up the cassandra node" or
having a cassandra node or cluster running all the time. This might be
useful in for example testing contexts...

=Rob

-- 
=Robert Coli
AIM&GTALK - rc...@palominodb.com
YAHOO - rcoli.palominob
SKYPE - rcoli_palominodb