Huawei Cloud RDS MariaDB

Collect Huawei Cloud RDS MariaDB 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

Recommend deploying GSE version

Installation script¶

Tip: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 MariaDB, we install the corresponding collection script: 「Guance Cloud Integration (Huawei Cloud RDS-MariaDB Collection)」 (ID: guance_huaweicloud_rds_mariadb)

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 installing the script, find the script 「Guance Cloud Integration (Huawei Cloud RDS-MariaDB data collection)」 in the 「Development」 section of Func. Expand and modify the script, find collector_configs and monitor_configs, and edit the content in region_projects below. Change the region and Project ID to the actual region and Project ID, and then click save and publish.

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 the guance cloud platform, click 「Infrastructure / Custom」 to check whether asset information exists
3. On the guance cloud platform, press 「Metrics」 to check whether monitoring data exists

Metric¶

Configure Huawei Cloud RDS MariaDB metrics to collect more metrics through configuration Huawei Cloud RDS MariaDB Metric Details

The performance monitoring metrics for RDS for MariaDB instances are shown in the following table.

Object¶

The collected Huawei Cloud RDS MariaDB object data structure can be viewed in the 「Infrastructure Customization」 section for object data.

{
  "measurement": "huaweicloud_rds_mariadb",
  "tags": {
    "id"                     : "1d0c91561f4644dxxxxxx68304b0520din01",
    "instance_name"          : "rds-xxxx",
    "status"                 : "ACTIVE",
    "port"                   : "3306",
    "type"                   : "Ha",
    "RegionId"               : "cn-south-1",
    "security_group_id"      : "9e5bd45e-0564-445f-xxxx-2c8954e2d99c",
    "switch_strategy"        : "reliability",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "time_zone"              : "China Standard Time",
    "enable_ssl"             : "True",
    "charge_info.charge_mode": "postPaid",
    "engine"                 : "MariaDB",
    "engine_version"         : "10.5"
  },
  "fields": {
    "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 message}",
    "nodes"           : "[{Primary instance information}]",
    "related_instance": "[]",
    "backup_strategy" : "{Backup strategy}"
  }
}

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

Tips 1：The value of tags.name is the instance ID, which serves as a unique identifier

Tips 2：The following fields are JSON serialized strings

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

Tips 3：The value of type is "Single","Ha" or "Replica","Enterprise",corresponding to single machine instance, primary/backup instance, read-only instance, and distributed instance (Enterprise Edition), respectively.