Huawei Cloud GaussDB SYS.GAUSSDBV5¶

Huawei Cloud GaussDB SYS.GAUSSDBV5 provides data for cpu, memory, disk, deadlock, and SQL response time metrics.

Configuration¶

Install Func¶

It is recommended to enable Guance integration - extension - DataFlux Func (Automata): all prerequisites are automatically installed. Please continue with the script installation.

If you deploy Func on your own, refer to Self-deployed Func

Installation Script¶

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

To synchronize monitoring data of GaussDB SYS.GAUSSDBV5, we install the corresponding collection script: 「Guance Integration (Huawei Cloud - GaussDB Collection)」(ID: guance_huaweicloud_gaussdb)

After clicking 【Install】, enter the corresponding parameters: Huawei Cloud AK, Huawei Cloud account name.

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

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

We default collect some configurations, details are listed under metrics.

Configure custom cloud object metrics

Verification¶

1. In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has an automatic trigger configuration, and at the same time, you can check the corresponding task records and logs for any abnormalities.
2. On the Guance platform, in 「Infrastructure / Custom」, check if there is asset information.
3. On the Guance platform, in 「Metrics」, check if there are corresponding monitoring data.

Metrics¶

After configuring GaussDB SYS.GAUSSDBV5, the default metric set is as follows. You can collect more metrics through configuration. Huawei Cloud Monitoring Metric 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, supports on-demand and package cycles}",
    "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: Fields in tags and fields may change with subsequent updates.

Note 1: The value of tags.name is the instance ID, used as unique identification.

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