Creating a keyspace

Add a new keyspace and set the replication factor.

A keyspace is the equivalent to a SQL database. It is the top level container for database objects. The keyspace replication strategy and factor control data availability for a set of tables in each datacenter of the cluster.
  • SimpleStrategy: Applies the same replication setting across the cluster. Only use this setting on single node test or development environments.
  • NetworkTopography: Applies the replication setting per datacenter. Use in production environments.
  • EverywhereStrategy: The default replication strategy for the dse_system and solr_admin keyspaces. Do not use or alter any instances of EverywhereStrategy.

Procedure

  1. Verify the datacenter name using nodetool status.
    nodetool status

    The output is:

    Datacenter: datacenter1
    ================
    Status=Up/Down
    |/ State=Normal/Leaving/Joining/Moving
    --  Address         Load       Tokens       Owns    Host ID                               Rack
    UN  10.200.181.134  4.97 MiB   1            ?       c9027497-011c-4390-ae59-e4ed1ac794cc  rack1
    UN  10.200.181.135  5.16 MiB   1            ?       af2af8ec-5fa2-4a04-ac9c-c75669d8d3a0  rack1
    
  2. Verify the datacenter names, which are case sensitive and ensure that you exactly match the case in the next step.
  3. Start cqlsh and create a keyspace.
    CREATE KEYSPACE IF NOT EXISTS cycling 
    WITH REPLICATION = { 
      'class' : 'NetworkTopologyStrategy', 
      'datacenter1' : 3};
  4. Switch to the keyspace.
    USE cycling;