Skip to content

Alibaba Cloud PolarDB Distributed 1.0

Alibaba Cloud PolarDB Distributed 1.0 Metrics include CPU utilization, memory utilization, network bandwidth, and disk IOPS.

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 on your own, refer to Self-deployed Func

Installation Script

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

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

After clicking [Install], enter the corresponding parameters: Alibaba Cloud AK and Alibaba Cloud account name.

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

Once enabled, 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 view the execution task records and corresponding logs.

We collect some configurations by default. For details, see the metrics section Customize Cloud Object Metrics

Verification

  1. In "Manage / Automatic Trigger Configuration", confirm whether the corresponding tasks have the corresponding automatic trigger configuration, and you can also check the corresponding task records and logs for any anomalies.
  2. On the TrueWatch platform, in "Infrastructure / Custom", check if there is asset information.
  3. On the TrueWatch platform, in "Metrics", check if there is corresponding monitoring data.

Metrics

After configuring Alibaba Cloud PolarDB Distributed 1.0, the default metric sets are as follows. You can collect more metrics through configuration Alibaba Cloud Monitoring Metric Details

Metric Description Statistics Unit
LogicQPS Average logical requests per second Average count
PhysicsQPS Average physical requests per second Average count
NetworkInputTraffic Network input traffic Average bit/s
NetworkOutputTraffic Network output traffic Average bit/s
ConnectionCount Number of connections Average,Maximum count
MemoryUtilization Memory usage rate Average %
CPUUtilization CPU usage rate Average,Maximum %
cpu_usage Private RDS_MySQL CPU utilization Average,Maximum %
disk_usage Private RDS_MySQL disk usage rate Average,Maximum %
mem_usage Private RDS_MySQL memory utilization Average,Maximum %
iops_usage Private RDS_MySQL IOPS utilization Average %
input_traffic_ps Private RDS_MySQL inbound network bandwidth Average bits/s
output_traffic_ps Private RDS_MySQL outbound network bandwidth Average bits/s

Objects

The collected Alibaba Cloud PolarDB Distributed 1.0 object data structure can be seen in the "Infrastructure-Custom" objects data.

{
  "measurement": "aliyun_polardbx_1",
  "tags": {
    "account_name": "Aliyun",
    "class": "aliyun_polardbx_1",
    "Description": "xxxxx",
    "DrdsInstanceId": "xxxxx",
    "RegionId": "cn-hangzhou",
    "name": "xxxxx",
    "NetworkType": "CLASSIC",
    "OrderInstanceId": "xxxxx",
    "ProductVersion": "V1",
    "Status": "RUN",
    "Type": "PRIVATE"
  }
}