RDS Databases Should Have Free Storage Space
More Info:
If your RDS databases are running low on disk space, they introduce a high risk of hurting your performance and availability.Risk Level
HighAddress
Operational Maturity, Reliability, SecurityCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the issue of RDS databases not having free storage space in AWS, you can follow these steps using the AWS Management Console:
- Login to AWS Console: Go to the AWS Management Console (https://aws.amazon.com/) and login to your account.
- Navigate to RDS Service: Click on the “Services” dropdown menu at the top left corner of the console, then select “RDS” under the Database category.
- Select the RDS Instance: From the list of RDS instances, identify the database that is running low on storage space and click on its name to open its details.
- Modify the Instance: In the RDS instance details page, click on the “Modify” button at the top right corner.
- Increase Storage: In the Modify DB Instance page, locate the “Allocated Storage” setting and increase the storage capacity to add more free space to the database. You can do this by either entering the desired storage size directly or by adjusting the slider.
- Apply Changes: Scroll down to the bottom of the page and click on the “Continue” button.
- Review and Apply Changes: Review the changes you are about to make, including the storage increase, and then click on the “Modify DB Instance” button to apply the changes.
- Monitor the Operation: The modification process will begin, and you can monitor the progress in the RDS console. Once the modification is complete, the database will have more free storage space available.
Using CLI
Using CLI
To remediate the misconfiguration of RDS databases not having free storage space in AWS using AWS CLI, follow these steps:
-
Identify the affected RDS instances:
Run the following AWS CLI command to list all the RDS instances that have storage space running out:
-
Modify the allocated storage for the affected RDS instance:
Run the following AWS CLI command to modify the allocated storage for the affected RDS instance. Replace
<DBInstanceIdentifier>with the identifier of the affected RDS instance and<newStorageSize>with the desired new storage size in GB: -
Monitor the modification progress:
Run the following AWS CLI command to monitor the status of the modification:
-
Verify the free storage space:
Once the modification is complete, verify that the RDS instance now has free storage space by running the following AWS CLI command:
Using Python
Using Python
To remediate the misconfiguration of RDS databases not having free storage space in AWS using Python, you can follow these steps:
-
Install Boto3: Boto3 is the AWS SDK for Python. You can install it using pip:
-
Create a Python script: Create a Python script to connect to AWS using Boto3 and check for RDS instances with no free storage space. Below is an example script to get you started:
- Modify the script: Update the script with the appropriate AWS credentials and the desired new storage size for the RDS instances.
- Run the script: Execute the Python script to identify RDS instances with no free storage space and modify them to increase the storage.