Huawei Cloud RDS MYSQL

Collect Huawei Cloud RDS MYSQL data

Configuration¶

Install Func¶

It is recommended to activate TrueWatch integration - extension - hosted version of Func: all preconditions are automatically installed, please continue with 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 scripts:

• 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 statistical 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 a Startup script set and automatically configure the corresponding startup scripts.

After the script is installed, find the script in Func "Development" 「TrueWatch Integration (Huawei Cloud-RDS Collection)」/「TrueWatch Integration (Huawei Cloud-RDS Slow Query Detail Log Collection)」/「TrueWatch Integration (Huawei Cloud-RDS Slow Query Statistical Log Collection)」, expand and modify this script, find collector_configs and monitor_configs and edit the content under region_projects respectively, 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 in "Management / Automatic Trigger Configuration". Click [Execute] to execute it immediately without waiting for the scheduled time. After a while, you can check the execution task record and corresponding logs.

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 logs to check for any exceptions
2. In TrueWatch, "Infrastructure - Resource Catalog", check whether asset information exists
3. In TrueWatch, "Metrics", check whether there is corresponding monitoring data
4. In TrueWatch, "Logs", check whether there is corresponding slow log data

Metrics¶

Configure Huawei Cloud RDS MYSQL monitoring Metrics, you can collect more Metrics by 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

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

Note 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

Note 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.