Huawei Cloud RDS MariaDB

Collect Huawei Cloud RDS MariaDB Metrics data

Configuration¶

Install Func¶

It is recommended to activate the Guance Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed. Please proceed with the script installation.

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

Install Script¶

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

Automata Script Activation¶

1. Log in to the Guance console.
2. Click the [Integration] menu, then select [Cloud Account Management].
3. Click [Add Cloud Account], select [Huawei Cloud], and fill in the required information on the interface. If you have already configured the cloud account information, ignore this step.
4. Click [Test], and if the test is successful, click [Save]. If the test fails, please check the relevant configuration information and retest.
5. Click [Cloud Account Management] in the list to view the added cloud account. Click the corresponding cloud account to enter the details page.
6. Click the [Integration] button on the cloud account details page. Under the Not Installed list, find Huawei Cloud RDS MariaDB, and click the [Install] button. The installation interface will pop up for installation.

Manual Script Activation¶

1. Log in to the Func console, click [Script Market], and enter the Guance script market. Search for 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 the Startup script set and configure the corresponding startup script.

4. After activation, you can see the corresponding automatic trigger configuration in [Management / Automatic Trigger Configuration]. Click [Execute] to immediately execute once without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

Verification¶

1. In [Management / Automatic Trigger Configuration], confirm whether the corresponding task has the corresponding automatic trigger configuration. At the same time, you can check the corresponding task records and logs to see if there are any exceptions.
2. In Guance, [Infrastructure - Resource Catalog], check if there is asset information.
3. In Guance, [Metrics], check if there is corresponding monitoring data.

Metrics¶

Configure Huawei Cloud RDS MariaDB Metrics. You can collect more Metrics through 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-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, which serves 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 type field can be "Single", "Ha", "Replica", or "Enterprise", corresponding to single instance, primary-secondary instance, read-only instance, and distributed instance (Enterprise Edition) respectively.