Huawei Cloud RDS MariaDB

Collect Metrics from Huawei Cloud RDS MariaDB

Configuration¶

Install Func¶

It is recommended to enable TrueWatch Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed, please proceed with the script installation.

If you want to deploy Func manually, refer to Manual Func Deployment

Install Script¶

Note: Please prepare the Huawei Cloud AK in advance (for simplicity, you can grant global read-only permissions ReadOnlyAccess)

1. Log in to the Func console, click 【Script Market】, enter the TrueWatch script market, and search for ID: integration_huaweicloud_rds_mariadb

2. Click 【Install】, then enter the corresponding parameters: Huawei Cloud AK, SK, and account name

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

4. After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. After a 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 automatic trigger configuration, and check the task records and logs for any exceptions
2. In TrueWatch, check if asset information exists in 「Infrastructure - Resource Catalog」
3. In TrueWatch, check if there are corresponding monitoring data in 「Metrics」

Metrics¶

Configure Huawei Cloud RDS MariaDB Metrics, you can collect more metrics by configuration Huawei Cloud RDS MariaDB Metrics Details

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

Object¶

The collected Huawei Cloud RDS MariaDB object data structure can be viewed 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 and standby 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, used as a unique identifier

Tip 2: The following fields are JSON serialized 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 to single instance, primary-standby instance, read-only instance, and distributed instance (Enterprise Edition) respectively.