Alibaba Cloud PolarDB Distributed 2.0¶

Alibaba Cloud PolarDB Distributed 2.0 displays Metrics for the compute layer and storage nodes, including CPU utilization, connection usage, disk usage volume, disk usage rate, memory utilization, network bandwidth, etc.

Configuration¶

Install Func¶

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

If you deploy Func yourself, refer to Self-deploy Func

Installation Script¶

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

To synchronize monitoring data of PolarDB Distributed 2.0, we install the corresponding collection script: TrueWatch Integration (Alibaba Cloud-PolarDB-X 2.0 Collection)

After clicking [Install], enter the corresponding parameters: Alibaba Cloud AK ID, Alibaba Cloud AK SECRET, and Account Name.

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

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

We have collected some configurations by default, details can be found in the Metrics section Customize cloud object Metrics

Verification¶

1. In [Manage / Automatic Trigger Configuration]confirm 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 TrueWatch platform, under [Infrastructure / Custom]check if there is any asset information.
3. On the TrueWatch platform, under [Metrics]check if there is any corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud PolarDB Distributed 2.0, the default Measurement sets are as follows, and more Metrics can be collected through configuration.

Alibaba Cloud Cloud Monitoring - Cloud Native Distributed Database PolarDB-X 2.0 Compute Node Metrics Details Alibaba Cloud Cloud Monitoring - Cloud Native Distributed Database PolarDB-X 2.0 Storage Node Metrics Details

Compute Node Metrics¶

Storage Node Metrics¶

Objects¶

The Alibaba Cloud PolarDB Distributed 2.0 object data structure collected can be viewed under [Infrastructure - Custom]

{
  "measurement": "aliyun_polardbx_2",
  "tags": {
    "ClassCode": "",
    "CommodityCode": "drds_polarxpost_public_cn",
    "DBInstanceName": "pxc-s-hzr1ch4n3icc3w",
    "DBType": "polarx",
    "DnNodeClassCode": "mysql.n2.medium.25",
    "Engine": "polarx",
    "Id": "pxc-xdb-s-shzr1ch4n3icc3wbf04",
    "LockMode": "Unlock",
    "MinorVersion": "polarx-kernel_standard_xcluster-20230508",
    "Network": "VPC",
    "NodeClass": "mysql.n2.medium.25",
    "PayType": "Postpaid",
    "Series": "standard",
    "Status": "Running",
    "Type": "ReadWrite",
    "VPCId": "vpc-bp1uhj8mimgturv8c0gg6",
    "ZoneId": "cn-hangzhou-k;cn-hangzhou-k;cn-hangzhou-k",
    "name": "pxc-xdb-s-shzr1ch4n3icc3wbf04"
  },
  "fields": {
    "CnNodeCount": 0,
    "CreateTime": "2023-08-16T06:57:41.000+0000",
    "Description": "",
    "DnNodeCount": 1,
    "ExpireTime": "2123-08-16T16:00:00.000+0000",
    "Expired": false,
    "NodeCount": 1,
    "ReadDBInstances": "[]",
    "ResourceGroupId": "rg-acfmv3ro3xnfwaa",
    "StorageUsed": 2343567360,
    "message": "{instance json data}}"
  }
}

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

Tip 1: The value of tags.name is the instance ID, used as unique identification.

Tip 2: The fields.message are all JSON serialized strings.