Per a question from @navjyotnishant
"Question regarding virtual tables, specifically system_view.clients. Can this be considered as a table to monitor connection to a node at runtime? Something similar to session monitoring in usual RDBMS?"
GOT QUESTIONS from the Workshop? You're in the right place! Post a question here and we'll get you answers.
Per a question from @navjyotnishant
"Question regarding virtual tables, specifically system_view.clients. Can this be considered as a table to monitor connection to a node at runtime? Something similar to session monitoring in usual RDBMS?"
Hi,
yes, the clients
virtual tables will list all connected clients, with information such as the number of issued requests or what username it is using.
Virtual tables will be introduced with Cassandra 4.0.
Here is a great blog about the new tables:
https://thelastpickle.com/blog/2019/03/08/virtual-tables-in-cassandra-4_0.html
Virtual tables are already in the version that underpins Astra, however the database permissions are insufficient to view these tables.
KVUser@cqlsh:system_views> select * from system_views.clients ; Unauthorized: Error from server: code=2100 [Unauthorized] message="User KVUser has no SELECT permission on <table system_views.clients> or any of its parents"
I hope this helps!
Thats great. I am looking forward to have this feature released which will solve long due session monitoring problem for cassandra.
[Follow up logged as question #6113]
it's a new feature, I'll have to research how this is implemented, will get back to you :)
To close the loop, I've responded to the follow-up question #6113 with details of how to take advantage of the client connection statistics introduced by virtual tables. Cheers!
9 People are following this question.
Will row cache store the data when the data is read for the first time?
What are the names of tables that store peer data?
Can we replace a node that is down with a new node to take over the same token range(s)?
Timeseries data modeling question
How do I handle a 2-phase commit since Cassandra does not support ACID?
DataStax Enterprise is powered by the best distribution of Apache Cassandra ™
© 2021 DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.
Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.
Privacy Policy Terms of Use