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 MetricMetric Display NameUnit
cassandra_BloomFilterDiskSpaceUsed

Disk space used by bloom filter
Bloom Filter Disk Space UsedMB
cassandra_BloomFilterFalsePositives

Number of false positives on tables bloom filter
Bloom Filter False PositivesEvents
cassandra_BloomFilterFalseRatio

False positive ratio of tables bloom filter
Bloom Filter False RatioFraction
cassandra_Cache_HitRate

All time cache hit rate
Cache Hit RateCache hit rate
cassandra_Cache_Hits

Total number of cache hits
Hits CountCache hits / second
cassandra_Cache_Requests

Total number of cache requests
Requests CountCache requests / second
cassandra_Cache_Size

Total size of occupied cache
Cache SizeMB
cassandra_Cache_Capacity

Capacity of Cache
Cache CapacityMB
cassandra_ClientRequest_Latency_Read

Read latency while reading
Read Request Latencymilliseconds
cassandra_ClientRequest_TotalLatency_Read

Total latency while reading
Total Read Request Latencymilliseconds
cassandra_ClientRequest_TotalLatency_Write

Read latency while writing
Total Write Request Latencymilliseconds
cassandra_ClientRequest_Latency_Write

Write latency while reading
Write Request Latencymilliseconds
cassandra_CommitLog_CompletedTasks

Total number of commit log messages written since [re]start
Commitlog Completed TasksTasks / second
cassandra_CommitLog_PendingTasks

Number of commit log messages written but yet to be fsyncd
Commitlog Pending TasksTasks
cassandra_TotalCommitLogSize

Current size used by all the commit log segments
Commitlog SizeMB
cassandra_Compaction_CompletedTasks

Number of completed compactions since server [re]start
Compaction Completed TasksTasks / second
cassandra_Compaction_PendingTasks

Estimated number of compactions remaining to perform
Compaction Pending TasksTasks
cassandra_BytesCompacted

Total number of bytes compacted since server [re]start
Compacted BytesMB
cassandra_TotalCompactionsCompleted

Throughput of completed compactions since server [re]start
Compactions CompletedCompactions / sec
cassandra_CompressionRatio

Current compression ratio for all SSTables
CompressionRatio
cassandra_Connection_TotalTimeouts

Number of timeouts occurred for this node per second
Connection TimeoutsTimeouts / second
cassandra_DroppedMessage_Dropped

Number of dropped messages
Dropped MessagesDrops / second
cassandra_Storage_Exceptions

Number of internal exceptions caught. Note: Under normal exceptions this should be zero
Storage ExceptionsErrors
cassandra_CurrentlyBlockedTasks_internal

Number of tasks that are currently blocked due to queue saturation but will be unblocked on retry
Currently Blocked Tasks internal
cassandra_PendingTasks_internal

Number of queued tasks queued up on thread pool
Internal Pending TasksPending Tasks
cassandra_ActiveTasks_internal

Number of tasks being actively worked on thread pool
Internal Active TasksActive Tasks
cassandra_TotalBlockedTasks_internal

Number of tasks that were blocked due to queue saturation
Internal Blocked TasksTasks / second
cassandra_CompletedTasks_internal

Number of tasks that were completed due to queue saturation
Internal Completed TasksTasks / second
cassandra_jvm_GarbageCollector_CollectionCount

Number of garbage objects collected
JVM GC collection countObjects collected
cassandra_jvm_GarbageCollector_CollectionTime

Time taken for collection of the garbage objects
JVM GC collection timeseconds
cassandra_jvm_HeapMemoryUsage_committed

Heap memory committed for the server
JVM Mem heap committedMB
cassandra_jvm_HeapMemoryUsage_used

Heap memory usage of the server
JVM Mem heap usedMB
cassandra_jvm_NonHeapMemoryUsage_committed

Non-heap memory committed for the server
JVM Mem non heap committedMB
cassandra_jvm_NonHeapMemoryUsage_used

Non-heap memory usage of the server
JVM Mem non heap usedMB
cassandra_jvm_OpenFileDescriptorCount

Number of Open file descriptors of the server
JVM OpenFDs CountOpen FDs
cassandra_jvm_Threading_ThreadCount

Total number of threads.
JVM Threads CountThreads
cassandra_jvm_Runtime_Uptime

Uptime of the server
Uptimeminutes
cassandra_LiveDiskSpaceUsed

Disk space used by SSTables belonging to this table
Live Disk Space Used CountMB
cassandra_LiveSSTableCount

Number of SSTables on disk for this table
Live SS Table Countfiles
cassandra_Storage_Load

Size of the on disk data size this node manages
Load StorageMB
cassandra_MaxRowSize

Size of the largest compacted row
Max Row SizeMB
cassandra_MeanRowSize

Average size of compacted rows
Mean Row SizeMB
cassandra_MemtableColumnsCount

Total number of columns present in the memtable
Memtable Columns CountColomns
cassandra_MemtableLiveDataSize

Total amount of live data stored in the memtable, excluding any data structure overhead
Memtable Live Data SizeMB
cassandra_MemtableSwitchCount

Number of times flush has resulted in the memtable being switched out
Memtable Switch CountEvents
cassandra_MinRowSize

Size of the smallest compacted row
Min Row SizeMB
cassandra_Timeouts_Read

Number of timeouts encountered while reading
Timeouts Read
cassandra_Unavailables_Read

Number of unavailable exceptions encountered while reading
Unavailables Read
cassandra_Latency_Read_OneMinuteRate

Read latency rate per minute
Read Latency OneMinuteRatemilliseconds
cassandra_Streaming_ActiveOutboundStreams

Currently active outbound streams
Streaming Active Outbound StreamsMBps
cassandra_Streaming_TotalIncomingBytes

Number of bytes streamed to this node from the peer shown
Streaming Total Incoming BytesMBps
cassandra_Streaming_TotalOutgoingBytes

Number of bytes streamed to the peer endpoint from this node shown in MBps
Streaming Total Outgoing BytesMBps
cassandra_ActiveTasks

Approximate number of tasks thread pool is actively executing on path - request
Active Tasks
cassandra_TotalBlockedTasks

Number of blocked tasks per second on path - request
Total Blocked Tasks
cassandra_CompletedTasks

Approximate number of tasks on which the thread pool has completed execution per second on path - request
Completed Tasks
cassandra_CurrentlyBlockedTasks

Number of currently blocked tasks on path - request
Currently Blocked Tasks
cassandra_PendingTasks_request

Approximate number of pending tasks thread pool has on path - request
Pending Tasks request
cassandra_TotalDiskSpaceUsed

Total disk space used by SSTables belonging to this table, including obsolete ones waiting to be GCd
Total Disk Space UsedMB
cassandra_Timeouts_Write

Number of timeouts encountered while writing
Timeouts Write
cassandra_Unavailables_Write

Number of unavailable exceptions encountered while writing
Unavailables Write
cassandra_Latency_Write_OneMinuteRate

Write latency OneMinuteRate
Latency Write One Minute Ratemilliseconds
cassandra_BytesFlushed

Total number of bytes flushed since server [re]start
Bytes Flushedbytes
cassandra_CasCommitLatency_75thPercentile

Latency of paxos commit round 75th percentile
Cas Commit Latency 75th Percentile
cassandra_CasCommitLatency_95thPercentile

Latency of paxos commit round 95th percentile
Cas Commit Latency 95thPercentile
cassandra_CasCommitLatency_OneMinuteRate

Latency of paxos commit round OneMinuteRate
Cas Commit Latency OneMinuteRate
cassandra_CasPrepareLatency_75thPercentile

Latency of paxos prepare round 75th Percentile
Cas Prepare Latency 75th Percentile
cassandra_CasPrepareLatency_95thPercentile

Latency of paxos prepare round 95th Percentile
Cas Prepare Latency 95thPercentile
cassandra_CasPrepareLatency_OneMinuteRate

Latency of paxos prepare round OneMinuteRate
Cas Prepare Latency OneMinuteRate
cassandra_CasProposeLatency_75thPercentile

Latency of paxos propose round.75th Percentile
Cas Propose Latency 75th Percentile
cassandra_CasProposeLatency_95thPercentile

Latency of paxos propose round. 95th Percentile
Cas Propose Latency 95thPercentile
cassandra_CasProposeLatency_OneMinuteRate

Latency of paxos propose round. OneMinuteRate
Cas Propose Latency OneMinuteRate
cassandra_ColUpdateTimeDeltaHistogram_75thPercentile

Histogram of column update time delta on this table 75th Percentile
Col Update Time Delta Histogram 75th Percentile
cassandra_ColUpdateTimeDeltaHistogram_95thPercentile

Histogram of column update time delta on this table 95th Percentile
Col Update Time Delta Histogram 95thPercentile
cassandra_ColUpdateTimeDeltaHistogram_Min

Histogram of column update time delta on this table Minimum value
Col Update Time Delta Histogram Min
cassandra_db_DroppableTombstoneRatio

Estimate of the droppable tombstone ratio
db Droppable Tombstone RatioFraction
cassandra_KeyCacheHitRate

Key cache hit rate for this table
Key Cache Hit RateFraction
cassandra_Latency_75thPercentile

Client request latency 75th Percentile
Latency 75th PercentileCache hit rate
cassandra_Latency_95thPercentile

Client request latency 95th Percentile
Latency 95thPercentile
cassandra_Latency_OneMinuteRate

Client request latency OneMinuteRate
Latency OneMinuteRate
cassandra_MaxPartitionSize

Size of the largest compacted partition
Max Partition SizeMB
cassandra_MeanPartitionSize

Size of the largest compacted row
Mean Partition SizeMB
cassandra_FailureDetector_DownEndpointCount

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.
Failure Detector Down Endpoint CountNodes
cassandra_FailureDetector_UpEndpointCount

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.
Failure Detector Up Endpoint CountNodes
cassandra_PendingFlushes

Estimated number of flush tasks pending for this table
PendingFlushesTasks
cassandra_RangeLatency_75thPercentile

Local range scan latency for this table 75th Percentile
RangeLatency 75th Percentile
cassandra_RangeLatency_95thPercentile

Local range scan latency for this table 95th Percentile
RangeLatency 95thPercentile
cassandra_RangeLatency_OneMinuteRate

Local range scan latency for this table OneMinuteRate
Range Latency One Minute Rate
cassandra_ReadLatency_75thPercentile

Local read latency for this table 75th Percentile
Read Latency 75th Percentile
cassandra_ReadLatency_95thPercentile

Local read latency for this table 95th Percentile
Read Latency 95th Percentile
cassandra_ReadLatency_99thPercentile

Local read latency for this table 99th Percentile
Read Latency 99th Percentile
cassandra_ReadLatency_OneMinuteRate

Local read latency for this table OneMinuteRate
Read Latency One Minute Rate
cassandra_RowCacheHitOutOfRange

Number of rows of table cache hits that do not satisfy the query filter
Row Cache Hit Out Of Range
cassandra_RowCacheHit

Number of table row cache hits
Row Cache HitCache hits
cassandra_RowCacheMiss

Number of table row cache misses
Row Cache MissCache miss
cassandra_SnapshotsSize

Disk space truly used by snapshots
Snapshots SizeMB
cassandra_SSTablesPerReadHistogram_75thPercentile

Number of SSTable data files accessed per read 75th Percentile
SSTables Per Read Histogram 75th Percentile
cassandra_SSTablesPerReadHistogram_95thPercentile

Number of SSTable data files accessed per read 95th Percentile
SSTables Per Read Histogram 95th Percentile
cassandra_TombstoneScannedHistogram_75thPercentile

Histogram of tombstones scanned in queries on this table 75th Percentile
Tombstone Scanned Histogram 75th Percentile
cassandra_TombstoneScannedHistogram_95thPercentile

Histogram of tombstones scanned in queries on this table 95th Percentile
Tombstone Scanned Histogram 95th Percentile
cassandra_ViewLockAcquireTime_75thPercentile

Time taken acquiring a partition lock for materialized view updates on this table 75th Percentile
View Lock Acquire Time 75th Percentile
cassandra_ViewLockAcquireTime_95thPercentile

Time taken acquiring a partition lock for materialized view updates on this table 95th Percentile
View Lock Acquire Time 95th Percentile
cassandra_ViewLockAcquireTime_OneMinuteRate

Time taken acquiring a partition lock for materialized view updates on this table OneMinuteRate
View Lock Acquire Time One Minute Rate
cassandra_ViewReadTime_75thPercentile

Time taken during the local read of a materialized view update 75th Percentile
View Read Time 75th Percentile
cassandra_ViewReadTime_95thPercentile

Time taken during the local read of a materialized view update 95th Percentile
View Read Time 95th Percentile
cassandra_ViewReadTime_OneMinuteRate

Time taken during the local read of a materialized view update OneMinuteRate
View Read Time One Minute Rate
cassandra_WaitingOnFreeMemtableSpace_75thPercentile

Histogram of time spent waiting for free memtable space, either on- or off-heap 75th Percentile
Waiting On Free Memtable Space 75th Percentile
cassandra_WaitingOnFreeMemtableSpace_95thPercentile

Histogram of time spent waiting for free memtable space, either on-heap or off-heap 95th Percentile
Waiting On Free Memtable Space 95th Percentile
cassandra_WriteLatency_75thPercentile

Local write latency 75th Percentile
Write Latency 75th Percentile
cassandra_WriteLatency_95thPercentile

Local write latency 95th Percentile
Write Latency 95th Percentile
cassandra_WriteLatency_99thPercentile

Local write latency 99th Percentile
Write Latency 99th Percentile
cassandra_WriteLatency_OneMinuteRate

Number of local write requests per minute
Write Latency One Minute Rate