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¶
- 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.
- On the TrueWatch platform, in "Infrastructure / Custom", check if there is asset information.
- 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"
}
}