HUAWEI CLOUD GaussDB for MySQL¶

HUAWEI CLOUD GaussDB for MySQL includes metrics related to CPU, memory, network, buffer pool, storage, slow logs, and InnoDB performance.

Config¶

Install Func¶

Recommend opening 「Integrations - Extension - DataFlux Func (Automata)」: All preconditions are installed automatically, Please continue with the script installation

If you deploy Func yourself,Refer to Self-Deployment of Func

Installation script¶

Tip：Please prepare HUAWEI CLOUD AK that meets the requirements in advance（For simplicity's sake,You can directly grant the global read-only permissionReadOnlyAccess）

To synchronize the monitoring data of GaussDB for MySQL , we install the corresponding collection script：「Guance Integration（HUAWEI CLOUD-CBRCollect）」(ID：guance_huaweicloud_ddm_gaussdb_mysql)

Click 【Install】 and enter the corresponding parameters: HUAWEI CLOUD AK, HUAWEI CLOUD account name.

tap【Deploy startup Script】,The system automatically creates Startup script sets,And automatically configure the corresponding startup script.

After this function is enabled, you can view the automatic triggering configuration in「Management / Crontab Config」.Click【Run】,you can immediately execute once, without waiting for a regular time.After a while, you can view task execution records and corresponding logs.

We collected some configurations by default, as described in the Metrics column Configure custom cloud object metrics

Verify¶

1. In「Management / Crontab Config」check whether the automatic triggering configuration exists for the corresponding task,In addition, you can view task records and logs to check whether exceptions exist
2. On the observation cloud platform, click 「Infrastructure / Custom」 to check whether asset information exists
3. On the observation cloud platform, press 「Metrics」 to check whether monitoring data exists

Metric¶

Configure HUAWEI CLOUD SYS.CBR monitoring. The default metric set is as follows. You can collect more metrics by configuring them HUAWEI CLOUD Monitor Metrics Details

Object¶

The collected HUAWEI CLOUD OBS object data structure can see the object data from 「Infrastructure-Custom」

{
  "measurement": "huaweicloud_gaussdb_mysql",
  "tags": {
    "RegionId"                : "cn-north-4",
    "db_user_name"            : "root",
    "name"                    : "2e10f990e139xxxxxx5fac6b59de7eein07",
    "port"                    : "3306",
    "project_id"              : "c631f046252d4xxxxxxx5f253c62d48585",
    "status"                  : "BUILD",
    "type"                    : "Cluster",
    "vpc_id"                  : "f6bc2c55-2a95-xxxx-xxxx-7b09e9a8de13",
    "instance_id"             : "2e10f990e139xxxxxx5fac6b59de7eein07",
    "instance_name"           : "nosql-efa7"
  },
  "fields": {
    "charge_info"          : "{The value can be yearly or monthly or on-demand. The default value is on-demand}",
    "create_time"          : "2023-08-01T14:17:40+0800",
    "update_time"          : "2023-08-01T14:17:42+0800",
    "private_ips"          : "[\"192.168.0.223\"]",
    "proxy_ips"            : "[]",
    "readonly_private_ips" : "[Instance Reads the Intranet IP address list]",
    "message"              : "{Instance JSON data}"
  }
}

notice：tags、fieldsThe fields in this section may change with subsequent updates

Tips 1：tags.nameThe value serves as the instance ID for unique identification

Tips 2：fields.message、fields.charge_info、fields.private_ips、fields.proxy_ips、fields.readonly_private_ips、are all JSON-serialized string representations.