Amazon RDS Monitoring
Amazon RDS - An Overview
Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. Amazon RDS supports an array of database engines to store and organize data and helps with database management tasks, such as migration, backup, recovery and patching.
Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with the familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, SQL Server, etc. Refer to the AWS RDS supported Database Engines to know more.
In this help document, you will learn how to get started with AWS RDS Monitoring, along with the list of parameters that are monitored using Applications Manager.
Creating a new Amazon RDS monitor
To learn how to create a new Amazon RDS monitor, refer here.
Monitored Parameters
Amazon RDS Instances are monitored based on the parameters or the attributes listed below. These attributes provide information about the functioning of the RDS instance. You can also configure thresholds to the numerical attributes based on these details and get notified when the thresholds are violated.
Go to the Monitors Category View by clicking the Monitors tab. Click on the RDS Instance of Amazon monitors under the Cloud Apps table. Displayed is the Amazon RDS bulk configuration view distributed into three tabs:
- Availability tab displays the Availability history of the RDS instances for the past 24 hours or 30 days.
- Performance tab displays the Health Status and key performance indicators of an RDS instance such as CPU Utilization, Free Storage Space, Database Connections and Write Throughput along with the heat charts for these attributes for the past 24 hours or 30 days.
- List view displays all the RDS instances present in the Amazon account along with an overall idea of their availability and health status. The list view also enables you to perform bulk admin configurations.
The metrics monitored are categorized into 2 tabs for easy understanding. Below is an explanation of the metrics displayed in the different tabs:
Note: Applications Manager's AWS RDS monitor supports all engine types. However, the supported metrics vary based on the DB Engine types like 'Aurora PgSQL', 'Aurora MySQL' and 'Other engine types' (MySQL, MariaDB, PostgreSQL, Oracle, SQL Server, etc.). Refer to the AWS RDS supported Database Engines to know more.
Monitor Information
| Parameter | Description |
|---|---|
| Monitor Information | |
| Name | The name of the RDS instance. |
| Region | The ID of AWS region where the current RDS instance is running. |
| Region Name | The name of the region where the RDS instance is running. |
| Instance Type | Indicates the type of instance |
| Created Time | The time when the instance was created. |
| State | The current state of the instance. The values include:
|
| DB Engine Name | The name of the database engine associated with this instance |
| Last Polled at | Specifies the time at which the last poll was performed. |
| Next Poll at | Specifies the time at which the next poll is scheduled. |
| Associated Groups | The groups to which the monitor is associated. |
Overview
This tab provides a high-level overview of the RDS Instance as well as its resource utilization.
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| CPU Utilization | The percentage of CPU utilization (in %). |  | | |
| Database Connections | The number of database connections in use. | | | |
| Free Memory | The memory available for use in the RDS Instance (in GB). | | | |
| Free Memory | The memory available for use in the RDS Instance (in MB). | | | |
| Free Storage Space | The amount of available storage space (in %). |  | | |
| Free Local Storage | The amount of local storage that is free on an Aurora instance (in GB). | | | |
| Swap Usage | The amount of swap space used on the DB Instance (in MB). | | | |
Disk I/O
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| I/O THROUGHPUT | ||||
| Read Throughput | The average number of bytes read from disk per second (in Bytes/Sec). | | | |
| Write Throughput | The average number of bytes written to disk per second (in Bytes/Sec). | | | |
| I/O LATENCY | ||||
| Read Latency | The average amount of time taken per disk read I/O operations (in seconds). | | | |
| Write Latency | The average amount of time taken per disk write I/O operation (in Seconds). | | | |
| I/O OPERATIONS | ||||
| Read Ops | The average number of disk read I/O operations per second (in Ops/Sec). | | | |
| Write Ops | The average number of disk write I/O operations per second (in Ops/Sec). | | | |
| Pending IOs requests | The count of pending IO requests in the disk. | | | |
| CLUSTER VOLUME I/O | ||||
| Volume Read IOPs | The number of billed read I/O operations from a cluster volume, reported at 5-minute intervals (in Ops/Sec). | | | |
| Volume Write IOPs | The average number of write disk I/O operations to the cluster volume reported at 5-minute intervals (in Ops/Sec). | | | |
| CLUSTER VOLUME USAGE | ||||
| Used Volume | The amount of storage in bytes used by the Aurora database (in GB). | | | |
Network
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| Incoming traffic | The incoming (Receive) network traffic on the DB instance (in kB/s). | | | |
| Outgoing traffic | The outgoing (Transmit) network traffic on the DB instance (in kB/s). | | | |
Aurora DB
Amazon Aurora is a relational database engine from Amazon Web Services, available as part of the Amazon Relational Database Service (RDS). Being MySQL and PostgreSQL - compatible and built for the cloud, Amazon Aurora provides security, availability, and reliability with the simplicity of open source databases.
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| Active Transactions | The average number of current transactions executed on a DB instance. | | | |
| Blocked Transactions | The average number of transactions in the database that are blocked. | | | |
| Bin Logs Disk Usage | The amount of disk space occupied by binary logs on the master (in MB). | | | |
| Transaction Logs Disk Usage | The amount of disk space occupied by transaction logs (in MB). | | | |
| Buffer Cache Hit Ratio | The percentage of requests that are served by the Buffer cache (in %). | | | |
| ResultSet Cache Hit Ratio | The percentage of requests that are served by the Resultset cache (in %). | | | |
| Deadlocks | The average number of deadlocks in the database per second. | | | |
| Aurora ReplicaLag | The average lag when replicating updates from the primary instance (in ms). This metric will be populated only for Aurora cluster 'Reader' and similarly 'ReplicaLag Minimum and Maximum' will be populated only for Aurora Cluster 'Writer' role instances. | | | |
| ReplicaLag Maximum | The maximum amount of lag between the primary instance and each Aurora instance in the DB cluster (in ms). | | | |
| ReplicaLag Minimum | The minimum amount of lag between the primary instance and each Aurora instance in the DB cluster (in ms). | | | |
Note: The Aurora Replica Lag metric will be populated only for Aurora cluster 'Reader'. The ReplicaLag Minimum/Maximum will be populated only for Aurora Cluster 'Writer' role instances.
DB Operations
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| Commit Latency | The amount of latency for committed transactions (in ms). | | | |
| Commit Throughput | The average rate of committed transactions (in Ops/Sec). | | | |
| DDL Latency | The amount of latency for DDL requests (create/alter/drop) (in ms). | | | |
| DDL Throughput | The average rate of DDL requests per second (in Ops/Sec). | | | |
| Delete Latency | The average latency for delete queries (in ms). | | | |
| Delete Throughput | The average rate of delete queries (in Ops/Sec). | | | |
| Insert Latency | The amount of latency for insert queries (in ms). | | | |
| Insert Throughput | The average rate of insert queries (in Ops/Sec). | | | |
| Number of Queries | The average rate of queries executed per second (in Queries/sec). | | | |
| Select Latency | The average latency for select queries (in ms). | | | |
| Select Throughput | The average rate of select queries (in Ops/Sec). | | | |
| Update Latency | The average latency for update queries (in ms). | | | |
| Update Throughput | The average rate of update queries (in Ops/Sec). | | | |
Replication
This tab will be shown only if a RDS Instance has a source DB Instance identifier in the configuration details.
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| Replication lag | The amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read Replicas. | | | |
| Replication Source | The source DB instance. | | | |
| Source Region | The AWS Region that the encrypted Read Replica is created in. | | | |
| Source ARN | The Amazon Resource Name of the source. | | | |
| Replication Status Type | The replication type of the RDS replica instance. Default value is read replication. | | | |
| Replication Status | The status of the RDS instance. Possible values are replicating, replication stop point set, replication stop point reached, error, stopped, or terminated. | | | |
Configuration
This tab provides the configuration details of the RDS instance.
Metric | Description | Supported Engines | ||
|---|---|---|---|---|
Aurora PgSQL | Aurora MySQL | Other engine types | ||
| CONFIGURATION DETAILS | ||||
| Instance ID | The unique key that identifies the instance. | | | |
| DBInstance ARN | The Amazon Resource Name for the source DB instance. | | | |
| DB Engine Name | The name of the database engine used for this instance. | | | |
| Engine Version | The database engine version. | | | |
| Created Time | The time when the instance was created. | | | |
| DB Name | The name of the initial database created when the instance was created. | | | |
| Master User Name | The master username for the instance. | | | |
| License Model | The license model information for the DB instance. | | | |
| INSTANCE DETAILS | ||||
| Instance Type | The type of instance. | | | |
| Storage Type | The storage type to be associated with the DB instance. | | | |
| Allocated Storage | The storage space initially allocated to this instance (in GiB). | | | |
| Storage Encrypted | Specifies the encryption status of the DB instance. | | | |
| State | The current status of the instance. Valid values include available, backing-up, creating, deleted, deleting, failed, modifying, rebooting and resetting-master-credentials. | | | |
| Multi(A-Z) Deployment | Indicates if this is a Multi-AZ DB Instance. | | | |
| Region Name | The name of AWS region where the current DynamoDB table resides. | | | |
| SECURITY AND NETWORK | ||||
| Availability Zone | The instance's availability zone. | | | |
| Publicly Accessible | Specifies if the DB instance is marked as publicly accessible. | | | |
| Endpoint Address | The DNS Address of the DB instance. | | | |
| Endpoint Port | The port used to connect to the DB instance. | | | |
| MAINTENANCE DETAILS | ||||
| Preferred Maintenance Window | The period during which patching and instance modifications will be performed. | | | |
| Latest Restorable Time | The latest time to which a database can be restored using point-in-time restore. | | | |
| Backup Retention Period | The number of days that automated backups are retained before deletion. | | | |
| Preferred Backup Window | The daily period during which automated backups are created. | | | |
| CLUSTER CONFIGURATION | ||||
| Aurora Cluster Name | The name of the Aurora cluster to which the RDS instance belongs to. | | | |
| Cluster ARN | The Amazon Resource Name (ARN) for the DB cluster. | | | |
| Cluster Endpoint | The endpoint for an Aurora DB cluster that connects to the current primary DB instance for that DB cluster. | | | |
| Cluster Reader Endpoint | The endpoint for an Aurora DB cluster that connects to one of the available Aurora Replicas for that DB cluster. | | | |
| Cluster Created Time | The time when the DB cluster was created | | | |
| Cluster Instance Role | The role that is associated with the DB instance. [Reader/ Writer] | | | |
| Cluster Group status | The current state of this DB cluster group. | | | |
