Alibaba Cloud PolarDB Oracle¶

Alibaba Cloud PolarDB Oracle Metrics Display, including CPU usage, memory usage, network traffic, connection count, IOPS, TPS, data disk size, etc.

Configuration¶

Install Func¶

It is recommended to enable Guance Integration - Extension - Hosted Func

If you deploy Func yourself, refer to Self-deployed Func

Enable Script¶

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

Hosted Version Enable Script¶

Log in to the Guance console
Click on the 【Integration】 menu, select 【Cloud Account Management】
Click 【Add Cloud Account】, select 【Alibaba Cloud】, fill in the required information on the interface; if you have already configured cloud account information, ignore this step
Click 【Test】, after a successful test click 【Save】, if the test fails, check whether the related configuration information is correct and retest
In the 【Cloud Account Management】 list, you can see the added cloud accounts, click on the corresponding cloud account to enter the details page
Click the 【Integration】 button on the cloud account details page, under the Not Installed list, find Alibaba Cloud PolarDB Oracle, click the 【Install】 button, and install it from the pop-up installation interface.

Manual Enable Script¶

Log in to the Func console, click 【Script Market】, go to the official script market, search for:guance_aliyun_polardb
After clicking 【Install】, input the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.
Click 【Deploy Start Script】, the system will automatically create a Startup script set and automatically configure the corresponding start scripts.
After enabling, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute once without waiting for the scheduled time. Wait a moment, you can view the execution task records and corresponding logs.

We default collect some configurations, detailed in the metrics section.

Metrics¶

After configuring Alibaba Cloud - Cloud Monitor, the default metric sets are as follows, more metrics can be collected through configuration Alibaba Cloud Cloud Monitor Metric 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 Time	userId,clusterId,instanceId	Average	`s`
`tps`	TPS	userId,clusterId,instanceId	Average	`frequency`

Objects¶

The collected Alibaba Cloud PolarDB object data structure can be seen from 「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"   : "{JSON data of node list}",
    "Database"  : "[JSON data of database details]",
    "ExpireTime": "",
    "CreateTime": "2022-06-17T06:07:19Z",
    "message"   : "{JSON data of instance}"
  }
}