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. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for all clients. Apache Cassandra is the only NoSQL solution that can accommodate the complex requirements of today’s modern line-of-business applications. It’s architected from the ground up for real-time enterprise databases that require vast scalability, high-velocity performance, flexible schema design, and continuous availability.
Prerequisite
For Virtual Machines, install the Linux Agent.
Configuring the credentials
Configure the credentials in the directory /opt/opsramp/agent/conf/app.d/creds.yaml
cassandra:
- name: cassandra
user: <username>
pwd: <Password>
encoding-type: plain
labels:
key1: val1
key2: val2
Configuring the application
Virtual machine
Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-detection.yaml
- name: cassandra
instance-checks:
service-check:
- cassandra
process-check:
- cassandra
port-check:
- 9042
- 9160
- 7000
mon-type: "jmx"
misc:
jmx-port: "7199"
Docker environment
Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-container-detection.yaml
- name: cassandra
container-checks:
image-check:
- cassandra
port-check:
- 9042
- 9160
- 7000
mon-type: "jmx"
misc:
jmx-port: "7199"
Kubernetes environment
Configure the application in config.yaml
- name: cassandra
container-checks:
image-check:
- cassandra
port-check:
- 9042
- 9160
- 7000
mon-type: "jmx"
misc:
jmx-port: "7199"
Validate
Go to Resources under the Infrastructure tab to check if your resources are onboarded and the metrics are collected.
Metrics
| OpsRamp Metric | Metric Display Name | Unit | Description |
|---|---|---|---|
| cassandra_BloomFilterDiskSpaceUsed | Bloom Filter Disk Space Used | MB | Disk space used by bloom filter |
| cassandra_BloomFilterFalsePositives | Bloom Filter False Positives | Events | Number of false positives on tables bloom filter |
| cassandra_BloomFilterFalseRatio | Bloom Filter False Ratio | Fraction | False positive ratio of tables bloom filter |
| cassandra_Cache_HitRate | Cache Hit Rate | Cache hit rate | All time cache hit rate |
| cassandra_Cache_Hits | Hits Count | Cache hits / second | Total number of cache hits |
| cassandra_Cache_Requests | Requests Count | Cache requests / second | Total number of cache requests |
| cassandra_Cache_Size | Cache Size | MB | Total size of occupied cache |
| cassandra_Cache_Capacity | Cache Capacity | MB | Capacity of Cache |
| cassandra_ClientRequest_Latency_Read | Read Request Latency | milliseconds | Read latency while reading |
| cassandra_ClientRequest_TotalLatency_Read | Total Read Request Latency | milliseconds | Total latency while reading |
| cassandra_ClientRequest_TotalLatency_Write | Total Write Request Latency | milliseconds | Read latency while writing |
| cassandra_ClientRequest_Latency_Write | Write Request Latency | milliseconds | Write latency while reading |
| cassandra_CommitLog_CompletedTasks | Commitlog Completed Tasks | Tasks / second | Total number of commit log messages written since [re]start |
| cassandra_CommitLog_PendingTasks | Commitlog Pending Tasks | Tasks | Number of commit log messages written but yet to be fsyncd |
| cassandra_TotalCommitLogSize | Commitlog Size | MB | Current size used by all the commit log segments |
| cassandra_Compaction_CompletedTasks | Compaction Completed Tasks | Tasks / second | Number of completed compactions since server [re]start |
| cassandra_Compaction_PendingTasks | Compaction Pending Tasks | Tasks | Estimated number of compactions remaining to perform |
| cassandra_BytesCompacted | Compacted Bytes | MB | Total number of bytes compacted since server [re]start |
| cassandra_TotalCompactionsCompleted | Compactions Completed | Compactions / sec | Throughput of completed compactions since server [re]start |
| cassandra_CompressionRatio | CompressionRatio | Current compression ratio for all SSTables | |
| cassandra_Connection_TotalTimeouts | Connection Timeouts | Timeouts / second | Number of timeouts occurred for this node per second |
| cassandra_DroppedMessage_Dropped | Dropped Messages | Drops / second | Number of dropped messages |
| cassandra_Storage_Exceptions | Storage Exceptions | Errors | Number of internal exceptions caught. Note: Under normal exceptions this should be zero |
| cassandra_CurrentlyBlockedTasks_internal | Currently Blocked Tasks internal | Number of tasks that are currently blocked due to queue saturation but will be unblocked on retry | |
| cassandra_PendingTasks_internal | Internal Pending Tasks | Pending Tasks | Number of queued tasks queued up on thread pool |
| cassandra_ActiveTasks_internal | Internal Active Tasks | Active Tasks | Number of tasks being actively worked on thread pool |
| cassandra_TotalBlockedTasks_internal | Internal Blocked Tasks | Tasks / second | Number of tasks that were blocked due to queue saturation |
| cassandra_CompletedTasks_internal | Internal Completed Tasks | Tasks / second | Number of tasks that were completed due to queue saturation |
| cassandra_jvm_GarbageCollector_CollectionCount | JVM GC collection count | Objects collected | Number of garbage objects collected |
| cassandra_jvm_GarbageCollector_CollectionTime | JVM GC collection time | seconds | Time taken for collection of the garbage objects |
| cassandra_jvm_HeapMemoryUsage_committed | JVM Mem heap committed | MB | Heap memory committed for the server |
| cassandra_jvm_HeapMemoryUsage_used | JVM Mem heap used | MB | Heap memory usage of the server |
| cassandra_jvm_NonHeapMemoryUsage_committed | JVM Mem non heap committed | MB | Non-heap memory committed for the server |
| cassandra_jvm_NonHeapMemoryUsage_used | JVM Mem non heap used | MB | Non-heap memory usage of the server |
| cassandra_jvm_OpenFileDescriptorCount | JVM OpenFDs Count | Open FDs | Number of Open file descriptors of the server |
| cassandra_jvm_Threading_ThreadCount | JVM Threads Count | Threads | Total number of threads. |
| cassandra_jvm_Runtime_Uptime | Uptime | minutes | Uptime of the server |
| cassandra_LiveDiskSpaceUsed | Live Disk Space Used Count | MB | Disk space used by SSTables belonging to this table |
| cassandra_LiveSSTableCount | Live SS Table Count | files | Number of SSTables on disk for this table |
| cassandra_Storage_Load | Load Storage | MB | Size of the on disk data size this node manages |
| cassandra_MaxRowSize | Max Row Size | MB | Size of the largest compacted row |
| cassandra_MeanRowSize | Mean Row Size | MB | Average size of compacted rows |
| cassandra_MemtableColumnsCount | Memtable Columns Count | Colomns | Total number of columns present in the memtable |
| cassandra_MemtableLiveDataSize | Memtable Live Data Size | MB | Total amount of live data stored in the memtable, excluding any data structure overhead |
| cassandra_MemtableSwitchCount | Memtable Switch Count | Events | Number of times flush has resulted in the memtable being switched out |
| cassandra_MinRowSize | Min Row Size | MB | Size of the smallest compacted row |
| cassandra_Timeouts_Read | Timeouts Read | Number of timeouts encountered while reading | |
| cassandra_Unavailables_Read | Unavailables Read | Number of unavailable exceptions encountered while reading | |
| cassandra_Latency_Read_OneMinuteRate | Read Latency OneMinuteRate | milliseconds | Read latency rate per minute |
| cassandra_Streaming_ActiveOutboundStreams | Streaming Active Outbound Streams | MBps | Currently active outbound streams |
| cassandra_Streaming_TotalIncomingBytes | Streaming Total Incoming Bytes | MBps | Number of bytes streamed to this node from the peer shown |
| cassandra_Streaming_TotalOutgoingBytes | Streaming Total Outgoing Bytes | MBps | Number of bytes streamed to the peer endpoint from this node shown in MBps |
| cassandra_ActiveTasks | Active Tasks | Approximate number of tasks thread pool is actively executing on path - request | |
| cassandra_TotalBlockedTasks | Total Blocked Tasks | Number of blocked tasks per second on path - request | |
| cassandra_CompletedTasks | Completed Tasks | Approximate number of tasks on which the thread pool has completed execution per second on path - request | |
| cassandra_CurrentlyBlockedTasks | Currently Blocked Tasks | Number of currently blocked tasks on path - request | |
| cassandra_PendingTasks_request | Pending Tasks request | Approximate number of pending tasks thread pool has on path - request | |
| cassandra_TotalDiskSpaceUsed | Total Disk Space Used | MB | Total disk space used by SSTables belonging to this table, including obsolete ones waiting to be GCd |
| cassandra_Timeouts_Write | Timeouts Write | Number of timeouts encountered while writing | |
| cassandra_Unavailables_Write | Unavailables Write | Number of unavailable exceptions encountered while writing | |
| cassandra_Latency_Write_OneMinuteRate | Latency Write One Minute Rate | milliseconds | Write latency OneMinuteRate |
| cassandra_BytesFlushed | Bytes Flushed | bytes | Total number of bytes flushed since server [re]start |
| cassandra_CasCommitLatency_75thPercentile | Cas Commit Latency 75th Percentile | Latency of paxos commit round 75th percentile | |
| cassandra_CasCommitLatency_95thPercentile | Cas Commit Latency 95thPercentile | Latency of paxos commit round 95th percentile | |
| cassandra_CasCommitLatency_OneMinuteRate | Cas Commit Latency OneMinuteRate | Latency of paxos commit round OneMinuteRate | |
| cassandra_CasPrepareLatency_75thPercentile | Cas Prepare Latency 75th Percentile | Latency of paxos prepare round 75th Percentile | |
| cassandra_CasPrepareLatency_95thPercentile | Cas Prepare Latency 95thPercentile | Latency of paxos prepare round 95th Percentile | |
| cassandra_CasPrepareLatency_OneMinuteRate | Cas Prepare Latency OneMinuteRate | Latency of paxos prepare round OneMinuteRate | |
| cassandra_CasProposeLatency_75thPercentile | Cas Propose Latency 75th Percentile | Latency of paxos propose round.75th Percentile | |
| cassandra_CasProposeLatency_95thPercentile | Cas Propose Latency 95thPercentile | Latency of paxos propose round. 95th Percentile | |
| cassandra_CasProposeLatency_OneMinuteRate | Cas Propose Latency OneMinuteRate | Latency of paxos propose round. OneMinuteRate | |
| cassandra_ColUpdateTimeDeltaHistogram_75thPercentile | Col Update Time Delta Histogram 75th Percentile | Histogram of column update time delta on this table 75th Percentile | |
| cassandra_ColUpdateTimeDeltaHistogram_95thPercentile | Col Update Time Delta Histogram 95thPercentile | Histogram of column update time delta on this table 95th Percentile | |
| cassandra_ColUpdateTimeDeltaHistogram_Min | Col Update Time Delta Histogram Min | Histogram of column update time delta on this table Minimum value | |
| cassandra_db_DroppableTombstoneRatio | db Droppable Tombstone Ratio | Fraction | Estimate of the droppable tombstone ratio |
| cassandra_KeyCacheHitRate | Key Cache Hit Rate | Fraction | Key cache hit rate for this table |
| cassandra_Latency_75thPercentile | Latency 75th Percentile | Cache hit rate | Client request latency 75th Percentile |
| cassandra_Latency_95thPercentile | Latency 95thPercentile | Client request latency 95th Percentile | |
| cassandra_Latency_OneMinuteRate | Latency OneMinuteRate | Client request latency OneMinuteRate | |
| cassandra_MaxPartitionSize | Max Partition Size | MB | Size of the largest compacted partition |
| cassandra_MeanPartitionSize | Mean Partition Size | MB | Size of the largest compacted row |
| cassandra_FailureDetector_DownEndpointCount | Failure Detector Down Endpoint Count | Nodes | Number of unhealthy nodes in the cluster. Note: They represent each individual node's view of the cluster and thus should not be summed across reporting nodes. |
| cassandra_FailureDetector_UpEndpointCount | Failure Detector Up Endpoint Count | Nodes | Number of healthy nodes in the cluster. Note: They represent each individual node's view of the cluster and thus should not be summed across reporting nodes. |
| cassandra_PendingFlushes | PendingFlushes | Tasks | Estimated number of flush tasks pending for this table |
| cassandra_RangeLatency_75thPercentile | RangeLatency 75th Percentile | Local range scan latency for this table 75th Percentile | |
| cassandra_RangeLatency_95thPercentile | RangeLatency 95thPercentile | Local range scan latency for this table 95th Percentile | |
| cassandra_RangeLatency_OneMinuteRate | Range Latency One Minute Rate | Local range scan latency for this table OneMinuteRate | |
| cassandra_ReadLatency_75thPercentile | Read Latency 75th Percentile | Local read latency for this table 75th Percentile | |
| cassandra_ReadLatency_95thPercentile | Read Latency 95th Percentile | Local read latency for this table 95th Percentile | |
| cassandra_ReadLatency_99thPercentile | Read Latency 99th Percentile | Local read latency for this table 99th Percentile | |
| cassandra_ReadLatency_OneMinuteRate | Read Latency One Minute Rate | Local read latency for this table OneMinuteRate | |
| cassandra_RowCacheHitOutOfRange | Row Cache Hit Out Of Range | Number of rows of table cache hits that do not satisfy the query filter | |
| cassandra_RowCacheHit | Row Cache Hit | Cache hits | Number of table row cache hits |
| cassandra_RowCacheMiss | Row Cache Miss | Cache miss | Number of table row cache misses |
| cassandra_SnapshotsSize | Snapshots Size | MB | Disk space truly used by snapshots |
| cassandra_SSTablesPerReadHistogram_75thPercentile | SSTables Per Read Histogram 75th Percentile | Number of SSTable data files accessed per read 75th Percentile | |
| cassandra_SSTablesPerReadHistogram_95thPercentile | SSTables Per Read Histogram 95th Percentile | Number of SSTable data files accessed per read 95th Percentile | |
| cassandra_TombstoneScannedHistogram_75thPercentile | Tombstone Scanned Histogram 75th Percentile | Histogram of tombstones scanned in queries on this table 75th Percentile | |
| cassandra_TombstoneScannedHistogram_95thPercentile | Tombstone Scanned Histogram 95th Percentile | Histogram of tombstones scanned in queries on this table 95th Percentile | |
| cassandra_ViewLockAcquireTime_75thPercentile | View Lock Acquire Time 75th Percentile | Time taken acquiring a partition lock for materialized view updates on this table 75th Percentile | |
| cassandra_ViewLockAcquireTime_95thPercentile | View Lock Acquire Time 95th Percentile | Time taken acquiring a partition lock for materialized view updates on this table 95th Percentile | |
| cassandra_ViewLockAcquireTime_OneMinuteRate | View Lock Acquire Time One Minute Rate | Time taken acquiring a partition lock for materialized view updates on this table OneMinuteRate | |
| cassandra_ViewReadTime_75thPercentile | View Read Time 75th Percentile | Time taken during the local read of a materialized view update 75th Percentile | |
| cassandra_ViewReadTime_95thPercentile | View Read Time 95th Percentile | Time taken during the local read of a materialized view update 95th Percentile | |
| cassandra_ViewReadTime_OneMinuteRate | View Read Time One Minute Rate | Time taken during the local read of a materialized view update OneMinuteRate | |
| cassandra_WaitingOnFreeMemtableSpace_75thPercentile | Waiting On Free Memtable Space 75th Percentile | Histogram of time spent waiting for free memtable space, either on- or off-heap 75th Percentile | |
| cassandra_WaitingOnFreeMemtableSpace_95thPercentile | Waiting On Free Memtable Space 95th Percentile | Histogram of time spent waiting for free memtable space, either on-heap or off-heap 95th Percentile | |
| cassandra_WriteLatency_75thPercentile | Write Latency 75th Percentile | Local write latency 75th Percentile | |
| cassandra_WriteLatency_95thPercentile | Write Latency 95th Percentile | Local write latency 95th Percentile | |
| cassandra_WriteLatency_99thPercentile | Write Latency 99th Percentile | Local write latency 99th Percentile | |
| cassandra_WriteLatency_OneMinuteRate | Write Latency One Minute Rate | Number of local write requests per minute |