Contents
How to increase storage for Amazon RDS instances?
To increase storage for a DB instance Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/. In the navigation pane, choose Databases. Choose the DB instance that you want to modify. Choose Modify. Enter a new value for Allocated Storage. It must be greater than the current value.
When to use autoscaling for Amazon RDS instances?
With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage. Amazon RDS starts a storage modification for an autoscaling-enabled DB instance when these factors apply:
How can I tell if my AWS replication is lagging?
You can use CloudWatch metrics, Oldest Replication Slot Lag, and Transaction Logs Disk Usage to determine how far behind the most lagging replica, in regards to the WAL data received and how much storage is used for WAL data. To check the status of cross-region read replica, query pg_replication_slots.
When to change the rds.logical replication parameter?
If you set the rds.logical_replication parameter value to 1, AWS DMS sets the wal_level, max_wal_senders, max_replication_slots, and max_connections parameters. Changing these parameters can increase WAL generation, so it’s a best practice to set the rds.logical_replication parameter only when you are using logical slots.
How does the database load chart work in AWS?
The Database Load chart shows how the database load compares to DB instance capacity as represented by the Max vCPU line. By default, load is shown as active sessions grouped by wait states in a bar graph. You can choose to display load as active sessions grouped by waits, SQL, users, or hosts.
Where to find performance Insights Dashboard in AWS?
You can also drill into details for a particular wait state, SQL query, host, or user. To see the Performance Insights dashboard, use the following procedure. Open the Amazon RDS console at https://console.aws.amazon.com/rds/ .