Skip to content

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)

  1. Log in to the TrueWatch console
  2. Click the 【Integration】 menu and select 【Cloud Account Management】
  3. 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
  4. 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
  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 Alibaba Cloud PolarDB Distributed 1.0 under the Not Installed list, and click the 【Install】 button to pop up the installation interface and install it.

Activate Script Manually

  1. Log in to the Func console, click 【Script Market】, enter the TrueWatch script market, and search for: integration_alibabacloud_polardbx_1

  2. Click 【Install】, and enter the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.

  3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and automatically configure the corresponding startup scripts.

  4. 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",
  }
}