In your terminal, start the first node via TODO

Wait for the node to start up. Once it has done so, press enter to get back to the prompt. TODO probably not necessary

Run the nodetool status command to verify the node is working properly.

The UN indicates UP NORMAL meaning the node is ready to go. Load indicates current disk space usage. Owns indicates how many tokens this node is responsible for (it is the only node in the ring at the moment). Token should be 0 (the same value set in the cassandra.yaml file). We discuss racks later in the series.

Start the second node

via /home/ubuntu/node2/bin/dse cassandra command.

This node will take longer to bootstrap and join the cluster.

Wait for the second node to finish bootstrapping such that both nodes are up and normal before continuing.

nodetool status

Now let's recreate the two tables we made in previous scenarios and import their data. Start cqlsh and execute the commands that follow:

cqlsh CREATE KEYSPACE killrvideo WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1 };

Now use the killrvideo keyspace and create the videos table:

USE killrvideo; {{execute}}

CREATE TABLE videos ( id uuid, added_date timestamp, title text, PRIMARY KEY ((id)) );

COPY videos(id, added_date, title) WITH HEADER=TRUE;

FROM '~/videos.csv' CREATE TABLE videos_by_tag ( tag text, video_id uuid, added_date timestamp, title text, PRIMARY KEY ((tag), added_date, video_id)) WITH CLUSTERING ORDER BY(added_date DESC);

COPY videos_by_tag(tag, video_id, added_date, title) FROM '/home/ubuntu/labwork/data-files/videos-by-tag.csv' WITH HEADER=TRUE;

Now let's determine which nodes own which partitions in the videos_by_tag table. Execute the following query:

SELECT token(tag), tag FROM videos_by_tag;

How many partitions are there? On which node does each partition reside?

You can refresh your memory as to which nodes own which token ranges by running the following in the terminal:

nodetool ring

You can further prove which partition resides on which node by executing the following nodetool commands in the terminal:

nodetool getendpoints killrvideo videos_by_tag 'cassandra'

nodetool getendpoints killrvideo videos_by_tag 'datastax'

The getendpoints command returns the IP addresses of the node(s) which store the partitions with the respective partition key value (the last argument in single quotes: cassandra and datastax respectively). Notice we must also supply the keyspace and table name we are interested in since, we set replication on a per-keyspace basis. There is more on replication to come later in this series.

Now, let's review