Supported Versions
311x or higher

Apache Cassandra is an open-source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.

Prerequisites

  • Install gateway version 5.0.0 or later.
  • Map a suitable gateway management profile to a resource.
  • Create credentials with type JMX before assigning a template to a resource. The Port, Connection Time-out, and Is Secure values are not used to create credentials.
  • Configure JMX in the end device.

Discovery using the gateway

The administrator can deploy a gateway to support Cassandra agentless monitoring. The gateway establishes a connection to the database using the management profile, collects metrics from the templates, and starts monitoring.

To monitor Cassandra:

  • Associate appropriate database credentials to the discovered database.
  • Assign one or more database-specific global templates on the device.

Choose one of the following management mechanisms to discover Cassandra servers and add them to your inventory:

  • WMI

  • SSH

  • SNMP

  • (Optional)Manually add a database server to the infrastructure inventory.

    1. Select Infrastructure.
    2. Click Settings > Resource > Add.
    3. From the Add Device window, enter the required details such as Device Type and Management Profile.
    4. Click Save.

View resource metrics

The gateway monitors the application using the assigned templates and displays the results in graphical format. To view resource metrics, click the desired Database Resource Name > Resource Details > Metrics.

Troubleshooting

Verify the following if the graphs are generated incorrectly:

  • The resource is accessible and Telnet is established for the IP address and port.
  • Valid credentials are used for the resource.

If you experience Cassandra monitoring issues, try the following troubleshooting steps:

  1. Verify server and gateway connectivity using Ping - ping IP Address

Example - ping 12.26.105.173

  1. Verify Telnet-to-server listening port connectivity - telnet IP Address Port

Example - telnet 172.26.105.173 9988

Supported templates

  • Cassandra ClientReq Storage Threadpool Template
  • Cassandra ColumnFamily Template
  • Cassandra Jvm Template
  • Cassandra Keyspace Template

After selecting the templates, you can:

  • Assign Cassandra templates from Setup or at the device level.
  • Customize default configuration parameter values while assigning the template.

Resource template configuration parameters

Configuration ParameterDescription
Connection Time-outMaximum database connect time. The driver waits for the specified time before timing out due to connection failure. The default time is 15000 milliseconds(ms).
Service Transport TypeThe secure database end-point. The default type is In-secure. The connection is Secure when the data sent between the client and server is encrypted.
Service PortThe port number where the database is running. The connection is made to the specified port if you specify the port and the database name. The default ports are 8091 and 9988.
API URLThe URL establishes the network connection to the Cassandra cluster. Use the following format while connecting to the database: service:jmx:rmi:///jndi/rmi://${jmx.rmi.host}:${jmx.rmi.port}/jmxrmi
Application TypeThe application type value to identify the adapter. For example, APACHE_CASSANDRA. Do not change the default application type value.

Supported metrics

MetricMetric Display NameUnitDescription
cassandra.clientrequest.latency.75th_percentileCassandra 75th Percentile Clientrequest LatencymicrosecondThe client request latency - p75
cassandra.clientrequest.latency.95th_percentileCassandra 95th Percentile Clientrequest LatencymicrosecondThe client request latency - p95
cassandra.clientrequest.latency.one_minute_rateCassandra One Minute Rate Percentile Clientrequest LatencyRequests per SecThe number of client requests
cassandra.columnfamily.bloomfilter.falseratioCassandra Columnfamily Bloomfilter False RatiopercentThe ratio of bloom filter false positives to total checks
cassandra.columnfamily.bytesflushed.countCassandra Columnfamily Bytes Flushed CountbytesThe amount of data flushed since (re)start
cassandra.columnfamily.compaction_bytes_written_countCassandra Columnfamily Compaction Bytes Written CountbytesCassandra Columnfamily compaction bytes written count
cassandra.columnfamily.compression_ratioCassandra Columnfamily Compression RatiopercentThe compression ratio for all SSTables. A low value means a high compression contrary to the name./td>
cassandra.columnfamily.live_disk_space_usedCassandra Columnfamily Live Disk Space UsedbytesThe disk space used by "live" SSTables (only counts in use files)
cassandra.columnfamily.max_row_sizeCassandra Columnfamily Max Row SizebytesThe size of the largest compacted row.
cassandra.columnfamily.mean_row_sizeCassandra Columnfamily Mean Row SizebytesThe average size of the compacted rows
cassandra.columnfamily.overall.range_latency.75th_percentileCassandra Columnfamily 75th Percentile Overall Range LatencymicrosecondCassandra Columnfamily 75th percentile overall range latency
cassandra.columnfamily.overall.range_latency.95th_percentileCassandra Columnfamily 95th Percentile Overall Range LatencymicrosecondThe local range request latency - p95
cassandra.columnfamily.overall.range_latency.one_minute_rateCassandra Columnfamily One Minute Rate Overall Range LatencycountThe number of local range requests
cassandra.columnfamily.overall.read_latency.75th_percentileCassandra Columnfamily 75th Percentile Overall Read LatencymicrosecondThe local read latency - p75
cassandra.columnfamily.overall.read_latency.95th_percentileCassandra Columnfamily 95th Percentile Overall Read LatencymicrosecondThe local read latency - p95
cassandra.columnfamily.overall.read_latency.99th_percentileCassandra Columnfamily 99th Percentile Overall Read LatencymicrosecondThe local read latency - p99
cassandra.columnfamily.overall.read_latency.one_minute_rateCassandra Columnfamily One Minute Rate Overall Read LatencycountThe number of local read requests
cassandra.columnfamily.overall.write_latency.75th_percentileCassandra Columnfamily 75th Percentile Overall Write LatencymicrosecondThe local write latency - p75
cassandra.columnfamily.overall.write_latency.95th_percentileCassandra Columnfamily 95th Percentile Overall Write LatencymicrosecondThe local write latency - p95
cassandra.columnfamily.overall.write_latency.99th_percentileCassandra Columnfamily 99th Percentile Overall Write LatencymicrosecondThe local write latency - p99
cassandra.columnfamily.overall.write_latency.one_minute_rateCassandra Columnfamily One Minute Rate Overall Write LatencycountThe number of local write requests
cassandra.columnfamily.pending_compactionsCassandra Columnfamily Pending CompactionscountThe number of pending compactions
cassandra.columnfamily.pending_flushesCassandra Columnfamily Pending FlushescountThe number of pending flushes
cassandra.columnfamily.row_cache_hit.countCassandra Columnfamily Row Cache Hit CountcountThe number of row cache hits
cassandra.columnfamily.row_cache_hit_out_of_range_countCassandra Columnfamily Row Cache Hit Out Of Range CountcountThe number of row cache hits that do not satisfy the query filter and moved to disk
cassandra.columnfamily.row_cache_miss_countCassandra Columnfamily Row Cache Miss CountcountThe number of table row cache misses
cassandra.columnfamily.view_read_time.75th_percentileCassandra Columnfamily 75th Percentile View Read TimemicrosecondThe time taken during the local read of a materialized view update - p75
cassandra.columnfamily.view_read_time.95th_percentileCassandra Columnfamily 95th Percentile View Read TimemicrosecondThe time taken during the local read of a materialized view update - p95
cassandra.columnfamily.view_read_time.one_minute_rateCassandra Columnfamily One Minute Rate View Read TimerpsThe number of local reads for a materialized view update
cassandra.db.columnfamilies.droppable_tombstone_ratioCassandra DB Columnfamilies Droppable Tombstone RatiopercentThe estimate of the droppable tombstone ratio
cassandra.keyspace.cas.commit.latency.75th_percentileCassandra Keyspace CAS 75th Percentile Commit LatencymicrosecondThe latency of paxos commit round - p75
cassandra.keyspace.cas_commit_latency.one_minute_rateCassandra Keyspace CAS One Minute Rate Commit Latencyper secondThe number of paxos commit round per second
cassandra.keyspace.cas_prepare_latency.75th_percentileCassandra Keyspace CAS 75th Percentile Commit LatencymicrosecondThe latency of paxos commit round - p75
cassandra.keyspace.cas_commit_latency.95th_percentileCassandra Keyspace CAS 95th Percentile Commit LatencymicrosecondThe latency of paxos commit round - p95
cassandra.keyspace.cas_commit_latency.one_minute_rateCassandra Keyspace CAS One Minute Rate Commit Latencyper secondThe number of paxos commit round per second
cassandra.keyspace.cas_prepare_latency.75th_percentileCassandra Keyspace CAS 75th Percentile Prepare LatencymicrosecondThe latency of paxos prepare round - p75
cassandra.keyspace.cas_prepare_latency.95th_percentileCassandra Keyspace CAS 95th Percentile Prepare LatencymicrosecondThe latency of paxos prepare round - p95
cassandra.keyspace.cas_prepare_latency.one_minute_rateCassandra Keyspace CAS One Minute Rate Prepare Latencyper secondThe number of paxos prepare round per second
cassandra.keyspace.cas_propose_latency.75th_percentileCassandra Keyspace CAS 75th Percentile Propose LatencymicrosecondThe latency of paxos propose round - p75
cassandra.keyspace.cas_propose_latency.95th_percentileCassandra Keyspace CAS 95th Percentile Propose LatencymicrosecondThe latency of paxos propose round - p95
cassandra.keyspace.cas_propose_latency.one_minute_rateCassandra Keyspace CAS One Minute Rate Propose Latencyper secondThe number of paxos propose round per second
cassandra.keyspace.total_disk_space_usedCassandra Keyspace Total Disk Space UsedbytesTotal disk space used by SSTables including obsolete ones waiting to be GC’d
cassandra.storage.exceptions.countCassandra Storage Exceptions CountcountThe number of exceptions thrown from ‘Storage’ metrics
cassandra.threadpools.currently_blocked_tasks_countCassandra Threadpools Currently Blocked TaskscountThe number of currently blocked tasks for the thread pool
cassandra.threadpools.interrnal.total_blocked_tasksCassandra Threadpools Total Internal Blocked TaskscountTotal count of blocked tasks
cassandra.threadpools.pending_tasksCassandra Threadpools Pending TaskscountThe number of pending tasks for the thread pool