Alibaba Cloud PolarDB Distributed 1.0¶
Alibaba Cloud PolarDB Distributed 1.0 displays Metrics including CPU utilization, memory utilization, network bandwidth, and disk IOPS.
Configuration¶
Install Func¶
It is recommended to activate TrueWatch Integration - Extensions - DataFlux Func (Automata)
If deploying Func manually, refer to Deploy Func Manually
Activate 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)
Activate Script for DataFlux Func (Automata)¶
- Log in to the TrueWatch console
- Click the 【Integration】 menu and select 【Cloud Account Management】
- Click 【Add Cloud Account】, select 【Alibaba Cloud】, and fill in the required information on the interface. If the cloud account information has been configured before, ignore this step
- Click 【Test】, and after the test is successful, click 【Save】. If the test fails, please check if the relevant configuration information is correct and retest
- 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
- Click the 【Integration】 button on the cloud account details page, find
Alibaba Cloud PolarDB Distributed 1.0under theNot Installedlist, and click the 【Install】 button to pop up the installation interface and install it.
Activate Script Manually¶
-
Log in to the Func console, click 【Script Market】, enter the TrueWatch script market, and search for:
integration_alibabacloud_polardbx_1 -
Click 【Install】, and enter the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.
-
Click 【Deploy Startup Script】, the system will automatically create the
Startupscript set and automatically configure the corresponding startup scripts. -
After activation, 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. Wait a moment, and you can view the execution task records and corresponding logs.
Metrics¶
After configuring Alibaba Cloud PolarDB Distributed 1.0, the default Measurement is as follows. You can collect more Metrics by configuring Alibaba Cloud Cloud Monitor 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 |
Connection count | Average,Maximum | count |
MemoryUtilization |
Memory utilization | Average | % |
CPUUtilization |
CPU utilization | Average,Maximum | % |
cpu_usage |
Private RDS_MySQL CPU utilization | Average,Maximum | % |
disk_usage |
Private RDS_MySQL disk utilization | 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 network input bandwidth | Average | bits/s |
output_traffic_ps |
Private RDS_MySQL network output bandwidth | Average | bits/s |
Object¶
The collected Alibaba Cloud PolarDB Distributed 1.0 object data structure can be seen in 「Infrastructure - Custom」
{
"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",
}
}