Cassandra Create Keyspace / Schema
The Cassandra Create Keyspace Tool provided by RazorSQL allows users to visually create keyspaces or schemas. To access the Create Keyspace tool, go to the DB Tools -> Create -> Create Schema menu option in RazorSQL. The following fields are displayed on the Create Keyspace tool:
Keyspace Name: The name of the keyspace or schema to be created
Replication Class: The name of the replication class - for example, either SimpleStrategy
or NetworkTopologyStrategy.
Replication Factor: For the SimpleStrategy, the numeric value representing the replication factor
Data Center Information: Information about the data centers when using the NetworkTopologyStrategy
After entering the above information, the Create Keyspace Tool can generate and/or execute the SQL needed to create the keyspace
Listed below are examples of the SQL the Create Keyspace Tool generates for a sample Cassandra keyspace / schema.
CREATE KEYSPACE sample_keyspace
WITH REPLICATION = {
'class' : 'SimpleStrategy',
'replication_factor' : 3
}
CREATE KEYSPACE sample_keyspace
WITH REPLICATION = {
'class' : 'NetworkTopologyStrategy',
'datacenter1' : 2,
'datacenter2' : 1
}
