Huawei Cloud RDS PostgreSQL

Collect Huawei Cloud RDS PostgreSQL Metrics data

Configuration¶

Install Func¶

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

If you are deploying Func yourself, refer to Self-deploying Func

Install Script¶

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

Automated Script Installation¶

1. Log in to the Guance console.
2. Click the 【Integration】 menu, and 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 before, you can skip this step.
4. Click 【Test】, and if the test is successful, click 【Save】. If the test fails, please check if the relevant configuration information is correct and retest.
5. Click 【Cloud Account Management】, and you can see the added cloud account in the list. Click the corresponding cloud account to enter the details page.
6. Click the 【Integration】 button on the cloud account details page, find Huawei Cloud RDS PostgreSQL under the Not Installed list, and click the 【Install】 button. A pop-up installation interface will appear for installation.

Manual Script Installation¶

1. Log in to the Func console, click 【Script Market】, and enter the Guance script market. Search for integration_huaweicloud_rds_postgresql.

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

3. Click 【Deploy Startup Script】, and 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 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. After a while, 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 view the corresponding task records and logs to check for any exceptions.
2. In Guance, check if asset information exists in 「Infrastructure - Resource Catalog」.
3. In Guance, check if there is corresponding monitoring data in 「Metrics」.

Metrics¶

Collect Huawei Cloud RDS PostgreSQL Metrics data. More Metrics can be collected through configuration Huawei Cloud RDS PostgreSQL Metrics Details

Instance Monitoring Metrics¶

RDS for PostgreSQL instance performance monitoring Metrics, as shown in the table below. For more Metrics, please refer to Table 1

Object¶

The collected Huawei Cloud RDS PostgreSQL object data structure can be seen in 「Infrastructure - Resource Catalog」.

{
  "measurement": "huaweicloud_rds_postgresql",
  "tags": {
    "name"                   : "1d0c91561f4644daxxxxx68304b0520din01",
    "id"                     : "1d0c91561f4644dxxxxxxd68304b0520din01",
    "instance_name"          : "rds-df54-xxxx",
    "status"                 : "ACTIVE",
    "port"                   : "5432",
    "type"                   : "Single",
    "RegionId"               : "cn-north-4",
    "security_group_id"      : "d13ebb59-d4fe-xxxx-xxxx-c22bcea6f987",
    "switch_strategy"        : "xxx",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "time_zone"              : "UTC+08:00",
    "enable_ssl"             : "False",
    "charge_info.charge_mode": "postPaid",
    "engine"                 : "PostgreSQL",
    "engine_version"         : "14"
  },
  "fields": {
    "created_time"    : "2022-06-21T06:17:27+0000",
    "updated_time"    : "2022-06-21T06:20:03+0000",
    "alias"           : "xxx",
    "private_ips"     : "[\"192.xxx.x.144\"]",
    "public_ips"      : "[]",
    "datastore"       : "{Database information}",
    "cpu"             : "2",
    "mem"             : "4",
    "volume"          : "{Volume information}",
    "nodes"           : "[{Primary and standby instance information}]",
    "related_instance": "[]",
    "backup_strategy" : "{Backup strategy}",
    "message"         : "{Instance JSON data}"
  }
}

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

Note 1: The value of tags.name is the instance ID, which is used as the 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 can be "Single", "Ha", "Replica", or "Enterprise", corresponding to single instance, primary and standby instances, read-only instances, and distributed instances (Enterprise Edition) respectively.