HUAWEI RDS MYSQL

Collect Huawei Cloud RDS MYSQL metric data.

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 HUAWEI CLOUD RDS cloud resources, we install the corresponding collection script:

• guance_huaweicloud_rds: Collect monitoring indicator data
• guance_huaweicloud_rds_slowlog_detail: Collect slow query detailed log data
• guance_huaweicloud_rds_slowlog: Collect slow query statistical log data

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 the script is installed,Find the script in「Development」in Func「Guance Integration（HUAWEI CLOUD-RDS Collect）」/「Guance Integration（HUAWEI CLOUD-RDS slow query detailed log collection）」/「Guance Integration（Huawei Cloud RDS Slow Query Statistics Log Collection）」,Expand to modify this script,find collector_configs and monitor_configs. Edit the content in region_projects,Change the locale and Project ID to the actual locale and Project ID, Click Save Publish again.

In addition, in「Management / Automatic Trigger Configuration」 you can see the corresponding automatic trigger configuration. Click 【Execute】 to run it immediately, without waiting for the scheduled time. After a short moment, you can check the execution task records and corresponding logs.

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 Guance platform, click 「Infrastructure / Custom」 to check whether asset information exists.
3. On Guance platform, press 「Metrics」 to check whether monitoring data exists.
4. On Guance platform, check the 「Logs」 to see if there is corresponding slow log data

Metric¶

Configure HUAWEI CLOUD RDS MYSQL metric data. You can collect more metrics by configuring them HUAWEI CLOUD RDS MYSQL Metrics Details

Instance monitoring metric¶

RDS for MySQL instance performance monitoring metric,as shown in the table below.

RDS for MySQL database agent monitoring metrics,As shown in table 2.

Dimension¶

Object¶

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

{
  "measurement": "huaweicloud_rds",
  "tags": {
    "name"                   : "1d0c91561f4644daxxxxx68304b0520din01",
    "id"                     : "1d0c91561f4644dxxxxxxd68304b0520din01",
    "instance_name"          : "rds-df54-xxxx",
    "status"                 : "ACTIVE",
    "port"                   : "3306",
    "type"                   : "Single",
    "RegionId"               : "cn-north-4",
    "security_group_id"      : "d13ebb59-d4fe-xxxx-xxxx-c22bcea6f987",
    "switch_strategy"        : "xxx",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "time_zone"              : "UTC+08:00",
    "enable_ssl"             : "False",
    "charge_info.charge_mode": "postPaid",
    "engine"                 : "MySQL",
    "engine_version"         : "5.7"
  },
  "fields": {
    "created_time"    : "2022-06-21T06:17:27+0000",
    "updated_time"    : "2022-06-21T06:20:03+0000",
    "alias"           : "xxx",
    "private_ips"     : "[\"192.xxx.x.144\"]",
    "public_ips"      : "[]",
    "datastore"       : "{Database information}",
    "cpu"             : "2",
    "mem"             : "4",
    "volume"          : "{volume information}",
    "nodes"           : "[{Information about the active and standby Instance}]",
    "related_instance": "[]",
    "backup_strategy" : "{Backup strategy}",
    "message"         : "{Instance JSON data}"
  }
}

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

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

Tips 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

Tips 3：typeThe value is “Single”,“Ha” or “Replica”, "Enterprise",corresponding to stand-alone instance, active/standby instance, read-only instance, and distributed instance (enterprise edition) respectively.