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 * FROM system.peers;

In the following output, the columns and data vary depending on the version used, and the example output is truncated because of the large number of columns.

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

(1 rows)