AWS Aurora Serverless V2¶
AWS Aurora Serverless V2 this includes aspects such as connection count, IOPS (Input/Output Operations Per Second), queues, read/write latency, and network throughput.
config¶
Install Func¶
Recommend opening 「Integrations - Extension - DataFlux Func (Automata)」: All preconditions are installed automatically, Please continue with the script installation
If you deploy Func yourself,Refer to Self-Deployment of Func
Installation script¶
Tip:Please prepare AWS AK that meets the requirements in advance(For simplicity's sake,,You can directly grant the global read-only permission
ReadOnlyAccess
)
To synchronize the monitoring data of AWS Aurora Serverless V2, we install the corresponding collection script:「Guance Integration(AWS-RDS-Aurora-postgresql
Collect)」(ID:guance_aws_rds_aurora_postgresql
)
Click 【Install】 and enter the corresponding parameters: Aws AK, Aws account name.。
tap【Deploy startup Script】,The system automatically creates Startup
script sets,And automatically configure the corresponding startup script。
After this function is enabled, you can view the automatic triggering configuration in「Management / Crontab Config」. Click【Run】,you can immediately execute once, without waiting for a regular time。After a while, you can view task execution records and corresponding logs。
If you want to collect logs, you must enable the corresponding log collection script. If you want to collect bills, start the cloud bill collection script.
Verify¶
- In「Management / Crontab Config」check whether the automatic triggering configuration exists for the corresponding task,In addition, you can view task records and logs to check whether exceptions exist
- On the Guance platform, click 「Infrastructure / Custom」 to check whether asset information exists
- On the Guance platform, press 「Metrics」 to check whether monitoring data exists
Metric¶
Configure AWS Aurora Serverless V2 monitoring. The default metric set is as follows. You can collect more metrics by configuring them Aws Cloud Monitor Metrics Details
Metric | Console name | Description | Applies to | Units |
---|---|---|---|---|
CPUUtilization |
CPU Utilization (Percent) | The percentage of CPU used by an Aurora DB instance. | Aurora MySQL and Aurora PostgreSQL | Percentage |
DatabaseConnections |
DB Connections (Count) | The number of client network connections to the database instance.The number of database sessions can be higher than the metric value because the metric value don't include the following:Sessions that no longer have a network connection but which the database hasn't cleaned upSessions created by the database engine for its own purposesSessions created by the database engine's parallel execution capabilitiesSessions created by the database engine job schedulerAmazon Aurora connections | Aurora MySQL and Aurora PostgreSQL | Count |
FreeableMemory |
Freeable Memory (MB) | The amount of available random access memory. | Aurora MySQL and Aurora PostgreSQL | Bytes |
WriteIOPS |
Write IOPS (Count/Second) | The number of Aurora storage write records generated per second. This is more or less the number of log records generated by the database. These do not correspond to 8K page writes, and do not correspond to network packets sent. | Aurora MySQL and Aurora PostgreSQL | Count per second |
ReadIOPS |
Read IOPS (Count/Second) | The average number of disk I/O operations per second but the reports read and write separately, in 1-minute intervals. | Aurora MySQL and Aurora PostgreSQL | Count per second |
DiskQueueDepth |
Queue Depth (Count) | The number of outstanding read/write requests waiting to access the disk. | Aurora MySQL and Aurora PostgreSQL | Count |
WriteThroughput |
Write Throughput (MB/Second) | The average number of bytes written to persistent storage every second. | Aurora MySQL and Aurora PostgreSQL | Bytes per second |
ReadThroughput |
Read Throughput (MB/Second) | The average number of bytes read from disk per second. | Aurora MySQL and Aurora PostgreSQL | Bytes per second |
SwapUsage |
Swap Usage (MB) | The amount of swap space used. This metric isn't available for the following DB instance classes:db.r3.* , db.r4.* , and db.r7g.* (Aurora MySQL)db.serverless and db.r7g.* (Aurora PostgreSQL) |
Aurora MySQL and Aurora PostgreSQL | Bytes |
WriteLatency |
Write Latency | The average amount of time taken per disk I/O operation. | Aurora MySQL and Aurora PostgreSQL | Seconds |
ReadLatency |
Read Latency | The average amount of time taken per disk I/O operation. | Aurora MySQL and Aurora PostgreSQL | Seconds |
NetworkReceiveThroughput |
Network Receive Throughput (MB/Second) | The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster. This throughput don't include network traffic between instances in the Aurora DB cluster and the cluster volume. | Aurora MySQL and Aurora PostgreSQL | Bytes per second (console shows Megabytes per second) |
NetworkTransmitThroughput |
Network Transmit Throughput (MB/Second) | The amount of network throughput sent to clients by each instance in the Aurora DB cluster. This throughput don't include network traffic between instances in the DB cluster and the cluster volume. | Aurora MySQL and Aurora PostgreSQL | Bytes per second (console shows Megabytes per second) |
TransactionLogsDiskUsage |
Transaction Logs Disk Usage (MB) | The amount of disk space consumed by transaction logs on the Aurora PostgreSQL DB instance.This metric is generated only when Aurora PostgreSQL is using logical replication or Amazon Database Migration Service. By default, Aurora PostgreSQL uses log records, not transaction logs. When transaction logs aren't in use, the value for this metric is -1 . |
Primary for Aurora PostgreSQL | Bytes |
EBSIOBalance% |
EBS IO Balance (Percent) | The percentage of I/O credits remaining in the burst bucket of your RDS database. This metric is available for basic monitoring only.To find the instance sizes that support this metric, see the instance sizes with an asterisk (* ) in the EBS optimized by default table in Amazon EC2 User Guide for Linux Instances . The Sum statistic is not applicable to this metric.This metric is different from BurstBalance . To learn how to use this metric, see Improving application performance and reducing costs with Amazon EBS-Optimized Instance burst capability. |
Aurora MySQL and Aurora PostgreSQL | Percent |
EBSIOBalance% |
EBS IO Balance (Percent) | The percentage of I/O credits remaining in the burst bucket of your RDS database. This metric is available for basic monitoring only.To find the instance sizes that support this metric, see the instance sizes with an asterisk (* ) in the EBS optimized by default table in Amazon EC2 User Guide for Linux Instances . The Sum statistic is not applicable to this metric.This metric is different from BurstBalance . To learn how to use this metric, see Improving application performance and reducing costs with Amazon EBS-Optimized Instance burst capability. |
Aurora MySQL and Aurora PostgreSQL | Percent |
FreeLocalStorage |
Free Local Storage (Bytes) | The amount of local storage available.Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance. This value depends on the DB instance class (for pricing information, see the Amazon RDS pricing page). You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance.(This doesn't apply to Aurora Serverless v2.) | Aurora MySQL and Aurora PostgreSQL | Bytes |
EngineUptime |
Engine Uptime (Seconds) | The amount of time that the instance has been running. | Aurora MySQL and Aurora PostgreSQL | Seconds |
StorageNetworkReceiveThroughput |
Network Receive Throughput (MB/Second) | The amount of network throughput received from the Aurora storage subsystem by each instance in the DB cluster. | Aurora MySQL and Aurora PostgreSQL | Bytes per second |
StorageNetworkThroughput |
Network Throughput (Byte/Second) | The amount of network throughput received from and sent to the Aurora storage subsystem by each instance in the Aurora MySQL DB cluster. | Aurora MySQL and Aurora PostgreSQL | Bytes per second |
StorageNetworkTransmitThroughput |
Network Transmit Throughput (MB/Second) | The amount of network throughput sent to the Aurora storage subsystem by each instance in the Aurora MySQL DB cluster. | Aurora MySQL and Aurora PostgreSQL | Bytes per second |