Alibaba Cloud PolarDB Oracle¶

Alibaba Cloud PolarDB Oracle Metrics display, including CPU usage, memory usage, network traffic, connections, IOPS, TPS, data disk size, etc.

Configuration¶

Install Func¶

It is recommended to enable TrueWatch Integration - Extensions - DataFlux Func (Automata)

If you want to deploy Func by yourself, refer to Deploy Func by yourself

Enable Script¶

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

Enable 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 you have already configured the cloud account information before, you can ignore this step
Click 【Test】, and click 【Save】 after the test is successful. If the test fails, please check whether the relevant configuration information is correct and test again
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 Oracle under the Not Installed list, and click the 【Install】 button to pop up the installation interface and install it.

Enable Script Manually¶

Log in to the Func console, click 【Script Market】, enter the TrueWatch script market, and search for: integration_alibabacloud_polardb
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 Startup script set and automatically configure the corresponding startup script.
After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to execute it immediately without waiting for the scheduled time. After a while, you can view the execution task record and the corresponding log.

Metrics¶

After configuring Alibaba Cloud Cloud Monitor, the default Measurement is as follows. You can collect more Metrics through configuration Alibaba Cloud Cloud Monitor Metrics Details

Metric Id	Metric Name	Dimensions	Statistics	Unit
`active_connections`	Active Connections	userId,clusterId,instanceId	Average	`count`
`blks_read_delta`	Data Blocks Read	userId,clusterId,instanceId	Average	`count`
`conn_usage`	Connection Usage	userId,clusterId,instanceId	Average	`%`
`cpu_total`	CPU Usage	userId,clusterId,instanceId	Average	`%`
`db_age`	Database Max Age	userId,clusterId,instanceId	Average	`xids`
`mem_usage`	Memory Usage	userId,clusterId,instanceId	Average	`%`
`pls_data_size`	Data Disk Size	userId,clusterId,instanceId	Value	`Mbyte`
`pls_iops`	IOPS	userId,clusterId,instanceId	Average	`frequency`
`pls_iops_read`	Read IOPS	userId,clusterId,instanceId	Average	`frequency`
`pls_iops_write`	Write IOPS	userId,clusterId,instanceId	Average	`frequency`
`pls_pg_wal_dir_size`	WAL Log Size	userId,clusterId,instanceId	Value	`Mbyte`
`pls_throughput`	IO Throughput	userId,clusterId,instanceId	Average	`Mbyte/s`
`pls_throughput_read`	Read IO Throughput	userId,clusterId,instanceId	Average	`Mbyte/s`
`pls_throughput_write`	Write IO Throughput	userId,clusterId,instanceId	Average	`Mbyte/s`
`rollback_ratio`	Transaction Rollback Rate	userId,clusterId,instanceId	Average	`%`
`swell_time`	Swell Point	userId,clusterId,instanceId	Average	`s`
`tps`	TPS	userId,clusterId,instanceId	Average	`frequency`

Object¶

The collected Alibaba Cloud PolarDB object data structure, you can see the object data in 「Infrastructure - Custom」

{
  "measurement": "aliyun_polardb",
  "tags": {
    "name"                : "pc-xxxx",
    "RegionId"            : "cn-hangzhou",
    "VpcId"               : "vpc-xxxx",
    "DBNodeNumber"        : "2",
    "PayType"             : "Postpaid",
    "DBType"              : "MySQL",
    "LockMode"            : "Unlock",
    "DBVersion"           : "8.0",
    "DBClusterId"         : "pc-xxxx",
    "DBClusterNetworkType": "VPC",
    "ZoneId"              : "cn-hangzhou-i",
    "Engine"              : "POLARDB",
    "Category"            : "Normal",
    "DBClusterDescription": "pc-xxxx",
    "DBNodeClass"         : "polar.mysql.x4.medium"
  },
  "fields": {
    "DBNodes"   : "{Node list JSON data}",
    "Database"  : "[Database details JSON data]",
    "ExpireTime": "",
    "CreateTime": "2022-06-17T06:07:19Z",
    "message"   : "{Instance JSON data}"
  }
}