How to monitor Cassandra database query

Question

Hi Experts, 
 
 Is there availability to execute and monitor Cassandra database query using obm and operation agent and what is the appropriate policy for it

Thnaks

Duncan Wood · Answer

Hello, 
 I had a quick google shows there is a Management Pack (MP): 
 https://www.microfocus.com/marketplace/itom/content/operations-bridge-unified-content-for-cassandra whic is documented here: https://docs.microfocus.com/doc/UC_Cassandra/24.3/ReleaseNotes 
 This is also Opentext supported, but this will need to be added to your contract so please speak to your Opentext Sales Representative. I hope this answers your question. 
 However, if you did not want to use the MP... Firstly, I know nothing about this DB. Assuming you don't want to use the Opentext MP, managing anything with OA12 you follow the same method... 
 Decide which parts of hte application you want to manage and why (that's the difficult part), then how you can get this data and then if you want to create metrics how to store them so OA12 can use them. 
 To get this data you could use cqlsh or nodetool which is documented here: https://cassandra.apache.org/doc/stable/cassandra/tools/nodetool/nodetool.html . For example: 
 Table health monitoring (cqlsh): SELECT address, data_center, rack, load FROM system_views.nodes; 
 Table size and space (cqlsh): SELECT keyspace_name, table_name, space_used_live, space_used_total FROM system_views.size_estimates; 
 notetool commands would include: 
 nodetool status 
 nodetool tpstats 
 There are some samples commands here: https://www.pythian.com/blog/technical-track/cassandra-information-using-nodetool and/or https://docs.datastax.com/en/developer/python-driver/3.29/index.html . 
 You can store metrics using this method: Easily collect custom metrics using Perl and visualize in OBM 
 All the best.

Menu

Operations Bridge Discussions

Verified Answers

How to monitor Cassandra database query

Tags:

Top Replies

Resources