Is it possible to know on which Cassandra nodes the data are stored for a DMA ?

Solved743 viewscassandra cluster
4
0 Comments

I’ve a cluster with N Dataminer Agent and M Cassandra Node.

Is it possible to know on which Cassandra nodes the data are stored for a DMA ?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 6th July 2023

1 Answer

5
813 0 Comments

Hello Bernard

Some time ago I had the need for something similar, to know on which nodes (out of a cluster of 3) some trend data was stored, i found this nodetool getendpoints really helpfull (15109 is the DMAid and key for that table), check more details here:

https://docs.datastax.com/en/dse/5.1/dse-dev/datastax_enterprise/tools/nodetool/toolsGetEndPoints.html

The command
[root@cassandra_srv_1 ~]# nodetool getendpoints du_noc_trend_data_rt trend_data_rt 15109

And the output will show the nodes where the data is:
10.66.117.68
10.66.117.67

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 6th July 2023