Huawei Cloud RDS MYSQL

Collect Huawei Cloud RDS MYSQL data

Configuration¶

Install Func¶

It is recommended to enable the Guance integration - extension - managed Func: all prerequisites will be automatically installed. Please continue with the script installation.

If you deploy Func yourself, refer to Self-deployed Func

Install 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 the monitoring data of Huawei Cloud RDS MYSQL, we install the corresponding collection scripts:

• guance_huaweicloud_rds: Collects monitoring Metrics data
• guance_huaweicloud_rds_slowlog_detail: Collects detailed slow query log data
• guance_huaweicloud_rds_slowlog: Collects statistical slow query log data

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

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

After the script is installed, find the script "Guance Integration (Huawei Cloud-RDS Collection)" / "Guance Integration (Huawei Cloud-RDS Slow Query Detail Log Collection)" / "Guance Integration (Huawei Cloud-RDS Slow Query Statistical Log Collection)" under "Development" in Func, expand and modify this script. Find collector_configs and monitor_configs, and edit the content under region_projects. Change the region and Project ID to the actual region and Project ID, then click Save and Publish.

In addition, you can see the corresponding automatic trigger configuration under "Management / Automatic Trigger Configuration". Click 【Execute】to immediately execute once without waiting for the regular time. After a while, you can view the execution task records and corresponding logs.

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding tasks have the corresponding automatic trigger configurations, and at the same time, you can view the corresponding task records and logs to check for any abnormalities.
2. On the Guance platform, under "Infrastructure - Resource Catalog", check if there is asset information.
3. On the Guance platform, under "Metrics", check if there are corresponding monitoring data.
4. On the Guance platform, under "Logs", check if there are corresponding slow log data.

Metrics¶

Configure Huawei Cloud RDS MYSQL monitoring Metrics, which can collect more Metrics through configuration Huawei Cloud RDS MYSQL Metrics Details

Instance Monitoring Metrics¶

RDS for MySQL instance performance monitoring Metrics are shown in the following table.

RDS for MySQL database proxy monitoring Metrics, as shown in Table 2.

Objects¶

The collected Huawei Cloud RDS MYSQL object data structure can be seen under "Infrastructure - Resource Catalog".

{
  "measurement": "huaweicloud_rds",
  "tags": {
    "RegionId"               : "cn-north-4",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "enterprise_project_id"  : "d13ebb59-d4fe-xxxx-xxxx-zc22bcea6f987",
    "instance_id"            : "1d0c91561f4644dxxxxxxd68304b0520din01",
    "instance_name"          : "rds-df54-xxxx",
    "status"                 : "ACTIVE",
    "type"                   : "Single",
    "engine"                 : "MySQL"
  },
  "fields": {
    "engine_version"         : "5.7",
    "port"                   : "3306",
    "security_group_id"      : "d13ebb59-d4fe-xxxx-xxxx-c22bcea6f987",
    "switch_strategy"        : "xxx",
    "enable_ssl"             : "False",
    "time_zone"              : "UTC+08:00",
    "created_time"           : "2022-06-21T06:17:27+0000",
    "updated_time"           : "2022-06-21T06:20:03+0000",
    "expiration_time"        : "2022-06-23T06:20:03+0000",
    "alias"                  : "xxx",
    "private_ips"            : "[\"192.xxx.x.144\"]",
    "public_ips"             : "[]",
    "cpu"                    : "2",
    "mem"                    : "4",
    "volume"                 : "{volume info}",
    "nodes"                  : "[{primary-secondary instance info}]",
    "related_instance"       : "[]",
    "backup_strategy"        : "{database info}"
  }
}

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

Tip 1: The value of tags.instance_id is the instance ID, used for unique identification.

Tip 2: The following fields are JSON serialized strings:

• fields.message
• fields.private_ips
• fields.public_ips
• fields.volume
• fields.nodes
• fields.related_instance
• fields.backup_strategy

Tip 3: The value of type is "Single", "Ha", "Replica", or "Enterprise", corresponding to single-instance, master-slave instance, read-only instance, and distributed instance (Enterprise Edition), respectively.