Exploring Cluster Topology with Cassandra Shell
Explore how Apache Cassandra stores and manages cluster topology details using the CQL shell. Understand the roles of the system.local and system.peers tables, and learn how to query node and peer information through hands-on CQL exercises. This lesson equips you to retrieve cluster configuration and monitor node status using Cassandra's built-in tools.
We'll cover the following...
As the course progresses, we will use the CQL shell to create tables and run queries, etc. For now, let’s explore how Cassandra stores cluster information and query it through cqlsh.
Cluster topology through cqlsh
Cassandra maintains tables in the System keyspace to hold cluster configuration details. As previously stated, nodes of a Cassandra cluster periodically gossip information about themselves and a subset of their peers to other nodes.
The system.local table
Each node maintains information about itself in the system.local table including:
A
host_id...