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.
- Select Infrastructure.
- Click Settings > Resource > Add.
- From the Add Device window, enter the required details such as Device Type and Management Profile.
- 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:
- Verify server and gateway connectivity using Ping -
ping IP Address
Example -
ping 12.26.105.173
- 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 Parameter | Description |
---|---|
Connection Time-out | Maximum 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 Type | The 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 Port | The 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 URL | The 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 Type | The application type value to identify the adapter. For example, APACHE_CASSANDRA. Do not change the default application type value. |
Supported metrics
Metric | Metric Display Name | Unit | Description |
---|---|---|---|
cassandra.clientrequest.latency.75th_percentile | Cassandra 75th Percentile Clientrequest Latency | microsecond | The client request latency - p75 |
cassandra.clientrequest.latency.95th_percentile | Cassandra 95th Percentile Clientrequest Latency | microsecond | The client request latency - p95 |
cassandra.clientrequest.latency.one_minute_rate | Cassandra One Minute Rate Percentile Clientrequest Latency | Requests per Sec | The number of client requests |
cassandra.columnfamily.bloomfilter.falseratio | Cassandra Columnfamily Bloomfilter False Ratio | percent | The ratio of bloom filter false positives to total checks |
cassandra.columnfamily.bytesflushed.count | Cassandra Columnfamily Bytes Flushed Count | bytes | The amount of data flushed since (re)start |
cassandra.columnfamily.compaction_bytes_written_count | Cassandra Columnfamily Compaction Bytes Written Count | bytes | Cassandra Columnfamily compaction bytes written count |
cassandra.columnfamily.compression_ratio | Cassandra Columnfamily Compression Ratio | percent | The compression ratio for all SSTables. A low value means a high compression contrary to the name./td> |
cassandra.columnfamily.live_disk_space_used | Cassandra Columnfamily Live Disk Space Used | bytes | The disk space used by "live" SSTables (only counts in use files) |
cassandra.columnfamily.max_row_size | Cassandra Columnfamily Max Row Size | bytes | The size of the largest compacted row. |
cassandra.columnfamily.mean_row_size | Cassandra Columnfamily Mean Row Size | bytes | The average size of the compacted rows |
cassandra.columnfamily.overall.range_latency.75th_percentile | Cassandra Columnfamily 75th Percentile Overall Range Latency | microsecond | Cassandra Columnfamily 75th percentile overall range latency |
cassandra.columnfamily.overall.range_latency.95th_percentile | Cassandra Columnfamily 95th Percentile Overall Range Latency | microsecond | The local range request latency - p95 |
cassandra.columnfamily.overall.range_latency.one_minute_rate | Cassandra Columnfamily One Minute Rate Overall Range Latency | count | The number of local range requests |
cassandra.columnfamily.overall.read_latency.75th_percentile | Cassandra Columnfamily 75th Percentile Overall Read Latency | microsecond | The local read latency - p75 |
cassandra.columnfamily.overall.read_latency.95th_percentile | Cassandra Columnfamily 95th Percentile Overall Read Latency | microsecond | The local read latency - p95 |
cassandra.columnfamily.overall.read_latency.99th_percentile | Cassandra Columnfamily 99th Percentile Overall Read Latency | microsecond | The local read latency - p99 |
cassandra.columnfamily.overall.read_latency.one_minute_rate | Cassandra Columnfamily One Minute Rate Overall Read Latency | count | The number of local read requests |
cassandra.columnfamily.overall.write_latency.75th_percentile | Cassandra Columnfamily 75th Percentile Overall Write Latency | microsecond | The local write latency - p75 |
cassandra.columnfamily.overall.write_latency.95th_percentile | Cassandra Columnfamily 95th Percentile Overall Write Latency | microsecond | The local write latency - p95 |
cassandra.columnfamily.overall.write_latency.99th_percentile | Cassandra Columnfamily 99th Percentile Overall Write Latency | microsecond | The local write latency - p99 |
cassandra.columnfamily.overall.write_latency.one_minute_rate | Cassandra Columnfamily One Minute Rate Overall Write Latency | count | The number of local write requests |
cassandra.columnfamily.pending_compactions | Cassandra Columnfamily Pending Compactions | count | The number of pending compactions |
cassandra.columnfamily.pending_flushes | Cassandra Columnfamily Pending Flushes | count | The number of pending flushes |
cassandra.columnfamily.row_cache_hit.count | Cassandra Columnfamily Row Cache Hit Count | count | The number of row cache hits |
cassandra.columnfamily.row_cache_hit_out_of_range_count | Cassandra Columnfamily Row Cache Hit Out Of Range Count | count | The number of row cache hits that do not satisfy the query filter and moved to disk |
cassandra.columnfamily.row_cache_miss_count | Cassandra Columnfamily Row Cache Miss Count | count | The number of table row cache misses |
cassandra.columnfamily.view_read_time.75th_percentile | Cassandra Columnfamily 75th Percentile View Read Time | microsecond | The time taken during the local read of a materialized view update - p75 |
cassandra.columnfamily.view_read_time.95th_percentile | Cassandra Columnfamily 95th Percentile View Read Time | microsecond | The time taken during the local read of a materialized view update - p95 |
cassandra.columnfamily.view_read_time.one_minute_rate | Cassandra Columnfamily One Minute Rate View Read Time | rps | The number of local reads for a materialized view update |
cassandra.db.columnfamilies.droppable_tombstone_ratio | Cassandra DB Columnfamilies Droppable Tombstone Ratio | percent | The estimate of the droppable tombstone ratio |
cassandra.keyspace.cas.commit.latency.75th_percentile | Cassandra Keyspace CAS 75th Percentile Commit Latency | microsecond | The latency of paxos commit round - p75 |
cassandra.keyspace.cas_commit_latency.one_minute_rate | Cassandra Keyspace CAS One Minute Rate Commit Latency | per second | The number of paxos commit round per second |
cassandra.keyspace.cas_prepare_latency.75th_percentile | Cassandra Keyspace CAS 75th Percentile Commit Latency | microsecond | The latency of paxos commit round - p75 |
cassandra.keyspace.cas_commit_latency.95th_percentile | Cassandra Keyspace CAS 95th Percentile Commit Latency | microsecond | The latency of paxos commit round - p95 |
cassandra.keyspace.cas_commit_latency.one_minute_rate | Cassandra Keyspace CAS One Minute Rate Commit Latency | per second | The number of paxos commit round per second |
cassandra.keyspace.cas_prepare_latency.75th_percentile | Cassandra Keyspace CAS 75th Percentile Prepare Latency | microsecond | The latency of paxos prepare round - p75 |
cassandra.keyspace.cas_prepare_latency.95th_percentile | Cassandra Keyspace CAS 95th Percentile Prepare Latency | microsecond | The latency of paxos prepare round - p95 |
cassandra.keyspace.cas_prepare_latency.one_minute_rate | Cassandra Keyspace CAS One Minute Rate Prepare Latency | per second | The number of paxos prepare round per second |
cassandra.keyspace.cas_propose_latency.75th_percentile | Cassandra Keyspace CAS 75th Percentile Propose Latency | microsecond | The latency of paxos propose round - p75 |
cassandra.keyspace.cas_propose_latency.95th_percentile | Cassandra Keyspace CAS 95th Percentile Propose Latency | microsecond | The latency of paxos propose round - p95 |
cassandra.keyspace.cas_propose_latency.one_minute_rate | Cassandra Keyspace CAS One Minute Rate Propose Latency | per second | The number of paxos propose round per second |
cassandra.keyspace.total_disk_space_used | Cassandra Keyspace Total Disk Space Used | bytes | Total disk space used by SSTables including obsolete ones waiting to be GC’d |
cassandra.storage.exceptions.count | Cassandra Storage Exceptions Count | count | The number of exceptions thrown from ‘Storage’ metrics |
cassandra.threadpools.currently_blocked_tasks_count | Cassandra Threadpools Currently Blocked Tasks | count | The number of currently blocked tasks for the thread pool |
cassandra.threadpools.interrnal.total_blocked_tasks | Cassandra Threadpools Total Internal Blocked Tasks | count | Total count of blocked tasks |
cassandra.threadpools.pending_tasks | Cassandra Threadpools Pending Tasks | count | The number of pending tasks for the thread pool |