Huawei Cloud RDS MYSQL

Collect Huawei Cloud RDS MYSQL data

Configuration¶

Install Func¶

It is recommended to activate the TrueWatch integration - extension - DataFlux Func (Automata): all preconditions are automatically installed, please proceed with the script installation.

If you deploy Func yourself, refer to Deploy Func Yourself

Install Script¶

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

To synchronize the monitoring data of Huawei Cloud RDS MYSQL, we install the corresponding collection script:

• integration_huaweicloud_rds: Collect monitoring Metrics data
• integration_huaweicloud_rds_slowlog_detail: Collect slow query detail log data
• integration_huaweicloud_rds_slowlog: Collect slow query statistics log data

After clicking [Install], enter the corresponding parameters: Huawei Cloud AK, Huawei Cloud account name.

Click [Deploy Startup Script], the system will automatically create the Startup script set and automatically configure the corresponding startup script.

After the script is installed, find the script "TrueWatch Integration (Huawei Cloud-RDS Collection)" / "TrueWatch Integration (Huawei Cloud-RDS Slow Query Detail Log Collection)" / "TrueWatch Integration (Huawei Cloud-RDS Slow Query Statistics Log Collection)" in the "Development" section of Func, expand and modify this script, find collector_configs and monitor_configs respectively, edit the content in region_projects, change the region and Project ID to the actual region and Project ID, and then click Save and Publish.

In addition, you can see the corresponding automatic trigger configuration in "Management / Automatic Trigger Configuration". Click [Execute] to execute it immediately without waiting for the scheduled time. Wait a moment, you can view the execution task record and corresponding log.

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding task has the corresponding automatic trigger configuration, and you can also check the corresponding task record and log to check for any exceptions.
2. In TrueWatch, check whether asset information exists in "Infrastructure - Resource Catalog".
3. In TrueWatch, check whether there is corresponding monitoring data in "Metrics".
4. In TrueWatch, check whether there is corresponding slow log data in "Logs".

Metrics¶

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

Instance Monitoring Metrics¶

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

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

Object¶

The collected Huawei Cloud RDS MYSQL object data structure can be seen in "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 information}",
    "nodes"                  : "[{primary and standby instance information}]",
    "related_instance"       : "[]",
    "backup_strategy"        : "{database information}"
  }
}

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

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

Tip 2: The following fields are all 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, primary-standby instance, read-only instance, and distributed instance (enterprise edition) respectively.