Huawei Cloud GaussDB SYS.GAUSSDBV5¶

Huawei Cloud GaussDB SYS.GAUSSDBV5 provides data on CPU, memory, disk, deadlocks, SQL response time metrics, and more.

Configuration¶

Install Func¶

It is recommended to activate the TrueWatch integration - extensions - hosted Func: all prerequisites are automatically installed, please proceed with the script installation.

For self-deploying Func, refer to Self-deploying Func

Install Script¶

Note: Please prepare the Huawei Cloud AK that meets the requirements 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

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 script

4. After enabling, you can see the corresponding automatic trigger configuration in 「Management / 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 「Management / 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 asset information exists in 「Infrastructure / Custom」
3. In TrueWatch, check if there is corresponding monitoring data in 「Metrics」

Metrics¶

After configuring GaussDB SYS.GAUSSDBV5, the default measurement sets are as follows. More metrics can be collected through configuration Huawei Cloud Cloud Monitoring Metrics Details

Objects¶

The collected GaussDB SYS.GAUSSDBV5 object data structure can be seen in 「Infrastructure - Custom」

{
  "measurement": "huaweicloud_gaussdb",
  "tags": {
    "RegionId"                : "cn-north-4",
    "db_user_name"            : "root",
    "name"                    : "2e10f990e139xxxxxx5fac6b59de7eein07",
    "port"                    : "3306",
    "project_id"              : "c631f046252d4xxxxxxx5f253c62d48585",
    "status"                  : "BUILD",
    "type"                    : "Cluster",
    "instance_id"             : "1236a915462940xxxxxx879882200in02",
    "instance_name"           : "xxxxx-efa7"
  },
  "fields": {
    "charge_info"          : "{Billing type information, supporting pay-as-you-go and subscription}",
    "flavor_info"          : "{Specification information}",
    "volume"               : "{Volume information}",
    "create_time"          : "2023-08-01T14:17:40+0800",
    "update_time"          : "2023-08-01T14:17:42+0800",
    "public_ips"           : "[\"192.168.0.223\"]",
    "nodes"                : "[]",
    "message"              : "{Instance JSON data}",
    "time_zone"            : "UTC+08:00"
  }
}

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

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

Tip 2: fields.message, fields.charge_info, fields.flavor_info, fields.volume, fields.public_ips, fields.nodes are all JSON serialized strings

```