1. Please start Cassandra.

2. Confirm that Cassandra has been started, and start cassandra-cli.

   • In case of Windows, double-click <%CASSANDRA_HOME%/bin/cassandra-cli.bat>.
   • In case of Linux, execute the command below to start it.

   /usr/local/cassandra/bin/cassandra-cli
   

3. When the console has shown up, please enter the command below.

   connect localhost/9160;
   

4. Please confirm that the connection is successful, and enter the command below.

   create keyspace default;
   

5. The message below is displayed, and you can confirm that the keyspace [default] has been created successfully.

   ... schemas agree across the cluster
   

• Connection User Name : aoyagi
• Password : aoyagi_pwd
• Keyspace Name : imbox_keyspace

1. Password should be added to Connection Authentication Setting (passwd.properties).

   admin=admin_pwd
   user=user_pwd
   aoyagi=aoyagi_pwd
   

2. Add the keyspace which aoyagi can access to Access Authority Setting (access.properties).

   # The magical '<modify-keyspaces>' property lists users who can modify the
   # list of keyspaces: all users will be able to view the list of keyspaces.
   <modify-keyspaces>=admin
   
   # Access to Keyspace 'default'
   default.<rw>=admin
   default.<ro>=user
   # Access to all ColumnFamily
   default.*.<rw>=admin
   default.*.<ro>=user
   
   # Access to Keyspace 'imbox_keyspace'
   imbox_keyspace.<rw>=aoyagi
   imbox_keyspace.<ro>=user
   # Access to all ColumnFamily
   imbox_keyspace.*.<rw>=aoyagi
   imbox_keyspace.*.<ro>=user
   

   Warning

   • In case authentication setting is used, keyspace other than the one set in access.properties may not be created.

3. Please start Cassandra.

4. Then, please specify authentication information, and start cassandra-cli.

   • In case of Windows, please start the Command Prompt, and execute the command below.

     %CASSANDRA_HOME%/bin/cassandra-cli -u aoyagi -pw aoyagi_pwd
     

   • In case of Linux, please execute the command below to do startup.

     /usr/local/cassandra/bin/cassandra-cli -u aoyagi -pw aoyagi_pwd
     

     Note

     Please refer to [How Connection Authentication is Confirmed] for the method of specifying authentication information.

5. Please confirm that the connection is successful, enter the command below, and create [imbox_keyspace].

   create keyspace imbox_keyspace;
   

6. The message below should be displayed, and you can confirm that the keyspace [imbox_keyspace] has been added.

   ... schemas agree across the cluster
   

   Note

   In case you need to build the cluster and create keyspaces in multiple Cassandra’s, you can create the keyspace in Cassandra of seed node,and then execute the nodetool repair command. As a consequence, keyspaces are created in other nodes, and it would not be necessary to create the keyspace on every node.

1. Cassandra should be started.

2. Please confirm that Cassandra has been started, and start cassandra-cli.

   Startup method of cassandra-cli is as follows.

   • In case of Windows, please double-click <%CASSANDRA_HOME%/bin/cassandra-cli.bat>.

   • In case of Linux, please run the command below and do the startup.

     /usr/local/cassandra/bin/cassandra-cli
     

3. When the console has shown up, please enter the command below.

   connect localhost/9160;
   

4. [Connected to: “IMBox Cluster” on localhost/9160] should be displayed on the console. Please enter the command below.

   drop keyspace default;
   

5. Deletion is completed, if [... schemas agree across the cluster] is displayed on the console.

• In case of Windows, please start the Command Prompt, and execute the command below.

  %CASSANDRA_HOME%/bin/nodetool -h [IP address of the Node to be executed] flush
  

• In case of Linux, please execute the command below.

  # /usr/local/cassandra/bin/nodetool -h [IP address of the Node to be executed] flush
  

After the execution, following log will be generated on Cassandra.

INFO 15:12:11,104 Enqueuing flush of Memtable-Versions@2895088(83/103 serialized/live bytes, 3 ops)
INFO 15:12:11,105 Writing Memtable-Versions@2895088(83/103 serialized/live bytes, 3 ops)
INFO 15:12:11,258 Completed flushing %CASSANDRA_HOME%\data\system\Versions\system-Versions-he-3-Data.db (247 bytes) for commitlog position ReplayPosition(segmentId=42805933509718, position=544)

• In case of Windows, please start the Command Prompt, and execute the commands below.

  %CASSANDRA_HOME%/bin/nodetool -h [IP address of the Node to be executed] flush
  %CASSANDRA_HOME%/bin/nodetool -h [IP address of the node to be executed] snapshot -t (arbitrary snapshot name)
  

• In case of Linux, please execute the commands below.

  # /usr/local/cassandra/bin/nodetool -h [IP address of the Node to be executed] flush
  # /usr/local/cassandra/bin/nodetool -h [IP address of the Node to be executed] snapshot -t (arbitrary snapshot name)
  

If the data has been saved by snapshot, it can be recovered (restored) to the point of snapshot.

• In case of Windows

1. Cassandra should be stopped.
2. Please delete the file of commitlog (example: C:/var/lib/cassandra/commit_log).
3. Please delete SSTable (example: Each db file of C:/var/lib/cassandra/data/default/(Column Family Name)/ should be deleted).
4. Please copy each db file of snapshot to C:/var/lib/cassandra/data/default/(Column Family Name).
5. Please start Cassandra.

• In case of Linux

1. Cassandra should be stopped.
2. Please delete the file of commitlog (example: /var/lib/cassandra/commit_log).
3. Please delete SSTable (Each db file of /var/lib/cassandra/data/default/(Column Family Name)/ should be deleted).
4. Please copy each db file of snapshot to /var/lib/cassandra/data/default/(Column Family Name).
5. Please start Cassandra.