I am currently working on a project where it is critical to know how my data is distributed among the nodes, for instance in which nodes are my elements from table “user” where “age<30”, etc. I know it will be on about 3 nodes since I have 3 replicas, but I would like to know precisely which of them.
First I tried to use the monitoring UI, but I couldn’t find a way to see what data is in each node.
Then I tried launching SQL queries targeting precise sets of data and check on the monitoring which nodes would react to these queries, but my UI aways say that the first node receives the queries, no matter the query I put in entry, which I find really strange.
So here are my questions in decreasing order of priority :
- Is these any way I can possibly know which data is in which node?
- Do you know why on monitoring UI only the first node receives the queries?
- Is it possible to know which are the primary ranges and which are the replicas?