Querying system tables for cluster topology information

Query system tables to get cluster topology information.

Query system tables to get cluster topology information. Display the IP address of peer nodes, datacenter and rack names, ports, token values, versions, and other information.

Tip: The ring or list view in OpsCenter Monitoring displays IP address and workload, in addition to node health.

Procedure

After setting up a cluster, query the peers table.

SELECT peer, data_center, dse_version, graph
FROM system.peers;

The following output will vary depending on the version used.

 peer           | data_center | dse_version | graph
----------------+-------------+-------------+-------
  10.10.100.110 |   Cassandra |       6.7.0 | False

(1 rows)