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 }