Skip to content

Huawei Cloud GaussDB-Influx

The displayed Metrics of Huawei Cloud GaussDB-Influx include write throughput, query latency, data retention policies, and scalability. These Metrics reflect the performance and reliability of GaussDB-Influx in handling large-scale time series data storage and queries.

Configuration

Install Func

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

If you need to deploy Func manually, refer to Manual Deployment of Func

Install Script

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

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

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

  3. Click 【Deploy Startup Script】, the system will automatically create a 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 for 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 corresponding task records and logs for any exceptions
  2. In TrueWatch, check if the asset information exists in 「Infrastructure / Custom」
  3. In TrueWatch, check if there is corresponding monitoring data in 「Metrics」

Metrics

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

Metric ID Metric Name Metric Description Value Range Measurement Object Monitoring Cycle (Original Metric)
nosql001_cpu_usage CPU Utilization This Metric is the CPU usage rate collected from the system level. Unit: % 0~100 % GaussDB(for Influx) Instance Node 1 minute
nosql002_mem_usage Memory Utilization This Metric is the memory usage rate collected from the system level. Unit: % 0~100 % GaussDB(for Influx) Instance Node 1 minute
nosql003_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 Influx) Instance Node 1 minute
nosql004_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 Influx) Instance Node 1 minute
nosql005_disk_usage Disk Utilization This Metric is used to count the disk usage rate of the measurement object. Unit: % 0~100 % GaussDB(for Influx) Instance Node 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 Influx) Instance Node 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 Influx) Instance Node 1 minute
influxdb001_series_num Time Series Count Describes the total number of time series. Unit: Counts ≥ 0 Counts GaussDB(for Influx) Instance Node 1 minute
influxdb002_query_req_ps Query Requests Per Second Describes the number of query requests per second. Unit: Counts/s ≥ 0 Counts/s GaussDB(for Influx) Instance Node 1 minute
influxdb003_write_req_ps Write Requests Per Second Describes the number of write requests per second. Unit: Counts/s ≥ 0 Counts/s GaussDB(for Influx) Instance Node 1 minute
influxdb004_write_points_ps Write Data Points Describes the number of data points written per second. Unit: Counts/s ≥ 0 Counts/s GaussDB(for Influx) Instance Node 1 minute
influxdb005_write_concurrency Write Concurrency Describes the number of concurrent write requests. Unit: Counts ≥ 0 Counts GaussDB(for Influx) Instance Node 1 minute
influxdb006_query_concurrency Query Concurrency Describes the number of concurrent query requests. Unit: Counts ≥ 0 Counts GaussDB(for Influx) Instance Node 1 minute

Object

The collected Huawei Cloud GaussDB-Influx 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, which serves as the unique identifier

Tip 2: The following fields are all JSON serialized strings

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

```