Skip to content

Huawei Cloud GaussDB-Cassandra

The displayed metrics of Huawei Cloud GaussDB-Cassandra include read/write throughput, latency, data consistency, and scalability. These metrics reflect the performance and reliability of GaussDB-Cassandra in handling large-scale distributed data storage and access.

Configuration

Install Func

It is recommended to activate the TrueWatch Integration - Extension - DataFlux Func (Automata): All prerequisites are automatically installed. Please proceed with the script installation.

If deploying Func manually, refer to Manual Func Deployment

Install Script

Note: Please prepare the required Huawei Cloud AK in advance (for simplicity, you can directly grant the global read-only permission ReadOnlyAccess)

  1. Log in to the Func console, click on 【Script Market】, enter the TrueWatch Script Market, and search for ID: integration_huaweicloud_gaussdb_cassandra

  2. Click 【Install】, then enter the corresponding parameters: Huawei Cloud AK, SK, and account name

  3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup scripts

  4. After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs

Verification

  1. In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration, and check the task records and logs for any exceptions
  2. In TrueWatch, check if asset information exists in 「Infrastructure / Custom」
  3. In TrueWatch, check if there are corresponding monitoring data in 「Metrics」

Metrics

After configuring Huawei Cloud Cloud Monitor, the default Measurement is as follows. You can collect more metrics through configuration Huawei Cloud Cloud Monitor Metrics Details

Metric ID Metric Name Metric Description Value Range Measurement Object Monitoring Period (Original Metric)
cassandra001_cpu_usage CPU Utilization This metric is the CPU usage rate collected from the system level. Unit: % 0~100 % GaussDB(for Cassandra) instance nodes 1 minute
cassandra002_mem_usage Memory Utilization This metric is the memory usage rate collected from the system level. Unit: % 0~100 % GaussDB(for Cassandra) instance nodes 1 minute
cassandra003_bytes_out Network Output Throughput Statistics on the average traffic output per second from all network adapters of the measurement object. Unit: kb/s ≥ 0 kb/s GaussDB(for Cassandra) instance nodes 1 minute
cassandra004_bytes_in Network Input Throughput Statistics on the average traffic input per second from all network adapters of the measurement object. Unit: kb/s ≥ 0 kb/s GaussDB(for Cassandra) instance nodes 1 minute
nosql005_disk_usage Disk Utilization This metric is used to count the disk utilization of the measurement object. Unit: % 0~100 % GaussDB(for Cassandra) instance nodes 1 minute
nosql006_disk_total_size Total Disk Size This metric is used to count the total disk size of the measurement object. Unit: GB ≥ 0 GB GaussDB(for Cassandra) instance nodes 1 minute
nosql007_disk_used_size Disk Used Size This metric is used to count the total used disk size of the measurement object. Unit: GB ≥ 0 GB GaussDB(for Cassandra) instance nodes 1 minute
cassandra014_connections Active Connections This metric is used to count the current number of active connections of the Cassandra instance nodes. Unit: Counts ≥ 0 Counts GaussDB(for Cassandra) instance nodes 1 minute
cassandra015_read_latency Query Requests per Second This metric is used to count the average time consumed by database read requests. Unit: ms ≥ 0 ms GaussDB(for Cassandra) instance nodes 1 minute
cassandra016_write_latency Write Requests per Second This metric is used to count the average time consumed by database write requests. Unit: ms ≥ 0 ms GaussDB(for Cassandra) instance nodes 1 minute
cassandra037_pending_write Pending Write Tasks Describes the number of write tasks currently queued. Unit: Counts ≥ 0 Counts GaussDB(for Cassandra) instance nodes 1 minute
cassandra038_pending_read Pending Read Tasks Describes the number of read tasks currently queued. Unit: Counts ≥ 0 Counts GaussDB(for Cassandra) instance nodes 1 minute

Object

The collected Huawei Cloud GaussDB-Cassandra object data structure can be seen in 「Infrastructure - Custom」

{
  "measurement": "huaweicloud_gaussdb_nosql",
  "tags": {
    "RegionId"          : "cn-north-4",
    "db_user_name"      : "rwuser",
    "engine"            : "rocksDB",
    "instance_id"       : "1236a915462940xxxxxx879882200in02",
    "instance_name"     : "nosql-efa7",
    "name"              : "1236a915462940xxxxxx879882200in02",
    "pay_mode"          : "0",
    "port"              : "8635",
    "project_id"        : "15c6ce1c12dxxxx0xxxx2076643ac2b9",
    "security_group_id" : "7aa51dbf-xxxx-xxxx-xxxx-dad3c4828b58",
    "status"            : "normal",
    "subnet_id"         : "f1df08c5-xxxx-xxxx-xxxx-de435a51007b",
    "vpc_id"            : "674e9b42-xxxx-xxxx-xxxx-5abcc565b961"
  },
  "fields": {
    "actions"         : "[]",
    "create_time"     : "2023-08-01T14:17:40+0800",
    "update_time"     : "2023-08-01T14:17:42+0800",
    "backup_strategy" : "{Instance JSON Data}",
    "datastore"       : "{Instance JSON Data}",
    "groups"          : "[{Instance JSON Data}]",
    "time_zone"       : "",
    "message"         : "{Instance JSON Data}"
  }
}

Note: The fields in tags and fields may change with subsequent updates

Tip 1: The value of tags.name is the instance ID, used as a unique identifier

Tip 2: The following fields are all JSON serialized strings

  • fields.message
  • fields.backup_strategy
  • fields.datastore
  • fields.groups
  • fields.actions

```