Huawei Cloud RDS MariaDB

Collect Huawei Cloud RDS MariaDB Metrics data

Configuration¶

Install Func¶

It is recommended to activate the Guance integration - extension - hosted Func: all prerequisites are automatically installed, please continue with the script installation.

If you deploy Func on your own, refer to Self-deployed Func

It is recommended to deploy the GSE version

Install Script¶

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

To synchronize Huawei Cloud RDS MariaDB monitoring data, we install the corresponding collection script: "Guance Integration (Huawei Cloud-RDS-MariaDB Collection)" (ID: guance_huaweicloud_rds_mariadb)

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

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

After the script is installed, find the script "Guance Integration (Huawei Cloud-RDS-MariaDB Collection)" under "Development" in Func, expand and modify this script. Find and edit the contents of collector_configs and monitor_configs for region_projects, changing 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 "Manage / Automatic Trigger Configuration". Click 【Execute】 to immediately execute once without waiting for the regular time. After a short while, you can check the execution task records and corresponding logs.

Verification¶

1. Confirm in "Manage / Automatic Trigger Configuration" whether the corresponding task has the corresponding automatic trigger configuration, and at the same time, you can check the corresponding task records and logs for any abnormalities.
2. On the Guance platform, check in "Infrastructure - Resource Catalog" whether asset information exists.
3. On the Guance platform, check in "Metrics" whether there are corresponding monitoring data.

Metrics¶

Configure Huawei Cloud RDS MariaDB Metrics, which can collect more metrics through configuration Huawei Cloud RDS MariaDB Metrics Details

RDS for MariaDB instance performance monitoring metrics are as follows:

Objects¶

The collected Huawei Cloud RDS MariaDB object data structure can be seen in "Infrastructure - Resource Catalog"

{
  "measurement": "huaweicloud_rds_mariadb",
  "tags": {
    "RegionId"               : "cn-south-1",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "enterprise_project_id"  : "o78hhbss-xxxx-xxxx-xxxx-cba3d38cf2f9",
    "instance_id"            : "1d0c91561f4644dxxxxxx68304b0520din01",
    "instance_name"          : "rds-xxxx",
    "status"                 : "ACTIVE",
    "type"                   : "Ha",
    "engine"                 : "MariaDB"
  },
  "fields": {
    "security_group_id"      : "9e5bd45e-0564-445f-xxxx-2c8954e2d99c", 
    "security_group_id"      : "9e5bd45e-0564-445f-xxxx-2c8954e2d99c", 
    "time_zone"              : "China Standard Time", 
    "enable_ssl"             : "True",
    "charge_info.charge_mode": "postPaid",
    "engine_version"         : "10.5",
    "created_time"           : "2024-11-12T06:31:07+0000",
    "updated_time"           : "2024-11-12T07:45:54+0000",
    "private_ips"            : "[\"192.x.x.35\"]",
    "public_ips"             : "[]",
    "datastore"              : "{Instance JSON data}",
    "cpu"                    : "4",
    "mem"                    : "8",
    "volume"                 : "{Volume information}",
    "nodes"                  : "[{Primary/Secondary instance information}]",
    "related_instance"       : "[]",
    "backup_strategy"        : "{Backup strategy}",
    "datastore"              : {}
  }
}

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

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

Tip 2: The following fields are serialized JSON strings:

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

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