Amazon Lightsail Database Monitoring
Amazon Lightsail Database - Overview
Amazon Lightsail Database is a fully managed relational database service offered by AWS Lightsail that provides preconfigured MySQL and PostgreSQL instances at a predictable monthly price. It handles routine database tasks such as hardware provisioning, patching, backups, and maintenance windows, allowing developers to focus on application development rather than database management.
Applications Manager's Amazon Lightsail Database monitoring tool provides real-time visibility into critical performance metrics, including CPU utilization, active database connections, disk queue depth, free storage space, and network throughput. With proactive alerting, historical performance trend analysis, and detailed configuration tracking, administrators can quickly detect bottlenecks, monitor storage consumption, and ensure consistent database availability.
Creating a new Amazon Lightsail Database monitor
To learn how to create a new Amazon Lightsail Database monitor, refer here.
Monitored Parameters
Go to the Monitors Category View by clicking the Monitors tab. Click on the Lightsail Database instance available under Amazon in the Cloud Apps section. Displayed below is the Amazon Lightsail Database bulk configuration view, distributed into three tabs:
- Availability tab gives the availability history for the past 24 hours or 30 days.
- Performance tab gives the health status and events for the past 24 hours or 30 days.
- List view tab enables you to perform bulk admin configurations.
By clicking a monitor from the list, you'll be taken to the Amazon Lightsail Database dashboard,d which includes the following tabs:
Performance Overview
| Parameter | Description |
|---|
| STATUS INFORMATION |
| Database State | The current operational state of the Lightsail-managed database at the time of polling. |
| Database Engine | The database engine software (e.g., MySQL). |
| Endpoint Address | The endpoint address for connecting to the database. |
| Endpoint Port | The port number for the database endpoint. |
| CPU UTILIZATION |
| CPU Utilization | The average CPU utilization of the database instance at the time of polling (in %). |
| DATABASE CONNECTIONS |
| Database Connections | The average number of active database connections at the time of polling. |
| DISK QUEUE DEPTH |
| Disk Queue Depth | The average number of outstanding read or write IOPS waiting to access the storage volume between poll intervals. |
| FREE STORAGE SPACE |
| Free Storage Space | The average amount of available storage space remaining on the database disk volume at the time of polling (in GB). |
| NETWORK RECEIVE THROUGHPUT |
| Network Receive Throughput | The average rate of incoming network traffic received by the database instance between poll intervals (in MB/s). |
| NETWORK TRANSMIT THROUGHPUT |
| Network Transmit Throughput | The average rate of outgoing network traffic sent by the database instance between poll intervals (in MB/s). |
Database History
| Parameter | Description |
|---|
| DATABASE HISTORY |
| Creation Time | The date and time when the operation was created. |
| Operation Type | The type of operation performed on the database. |
| Operation Status | The current status of the operation.
Possible values: Succeeded, Failed, NotStarted, Started, Waiting, Pending, or Running. |
| Status Changed Time | The date and time when the operation status was last changed. |
Database Configuration
| Parameter | Description |
|---|
| DATABASE CONFIGURATION |
| Creation Time | The date and time the managed database was created. |
| Database Engine | The database engine used by the managed database (e.g., MySQL). |
| Engine Version | The version of the database engine. |
| Master Username | The name of the master user for the managed database. |
| Master Database Name | The name of the default database for the managed database instance. |
| Blueprint ID | The ID of the database blueprint used to create the managed database. |
| Bundle ID | The bundle ID used to create the managed database, which defines its compute, storage, and memory capacity. |
| HARDWARE & NETWORK CONFIGURATION |
| Number of CPUs | The number of vCPUs allocated to the managed database instance. |
| Disk Size | The size of the disk attached to the managed database instance (in GB). |
| RAM Size | The amount of RAM allocated to the managed database instance (in GB). |
| Availability Zone | The AWS Availability Zone where the managed database is located. |
| Secondary Availability Zone | The Availability Zone for the secondary (standby) database instance, if high availability is enabled. |
| Publicly Accessible | Indicates whether the managed database is publicly accessible.
Possible values: Yes or No. |
| Parameter Apply Status | The status of parameter updates applied to the managed database. |
| BACKUP & MAINTENANCE CONFIGURATION |
| Preferred Backup Window | The daily time range during which automated backups are created for the managed database. |
| Latest Restorable Time | The latest point in time to which the managed database can be restored. |
| Preferred Maintenance Window | The weekly time range during which system maintenance can occur on the managed database. |
| Backup Retention Period | Indicates whether backup retention is enabled or disabled for the managed database. |
