More Info:
Your AWS RDS MySQL and PostgreSQL database instances should have Performance Insights feature enabled in order to allow you to obtain a better overview of your databases performanceRisk Level
LowAddress
Reliability, Operational MaturityCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the misconfiguration of the Performance Insights feature not being enabled for an AWS RDS instance using the AWS console, follow these step-by-step instructions:
- Login to AWS Console: Go to the AWS Management Console and log in with your credentials.
- Navigate to RDS Service: Click on the “Services” dropdown menu at the top left corner of the console and select “RDS” under the Database category.
- Select the RDS Instance: From the list of RDS instances, select the instance for which you want to enable Performance Insights by clicking on its identifier.
- Enable Performance Insights: In the RDS instance details page, scroll down to the “Performance Insights” section in the left-hand menu.
- Click on “Modify”: Click on the “Modify” button in the Performance Insights section to enable the feature for the selected RDS instance.
-
Configure Performance Insights: In the Modify DB instance page, under the “Performance Insights” section, you can configure the following settings:
- Enable Performance Insights: Check the box to enable Performance Insights for the RDS instance.
- Choose the Retention Period: Select the retention period for Performance Insights data.
- Choose the Monitoring Level: Select the monitoring level for Performance Insights data collection.
- Save Changes: Scroll down to the bottom of the page and click on the “Continue” button.
- Apply Changes: Review the changes you are about to make and click on the “Modify DB Instance” button to apply the changes.
- Monitor Performance Insights: Once the changes are applied, Performance Insights will be enabled for the selected RDS instance. You can now monitor the performance of the RDS instance using the Performance Insights dashboard.
Using CLI
Using CLI
To remediate the misconfiguration of enabling Performance Insights feature for AWS RDS using AWS CLI, follow these steps:
-
Enable Performance Insights on an RDS DB instance:
Run the following AWS CLI command to enable Performance Insights on an RDS DB instance:
Replace
your-db-instance-namewith the actual name of your RDS DB instance. -
Verify Performance Insights is enabled:
You can verify if Performance Insights is enabled for the DB instance by describing the DB instance using the following command:
Replace
your-db-instance-namewith the actual name of your RDS DB instance. - Access Performance Insights: Once Performance Insights is enabled, you can access it through the AWS Management Console or AWS CLI to monitor the performance of your RDS DB instance.
Using Python
Using Python
To remediate the misconfiguration of enabling the Performance Insights feature for an AWS RDS instance using Python, you can use the AWS SDK for Python (Boto3). Below are the step-by-step instructions to enable the Performance Insights feature for an AWS RDS instance:Replace
- Install Boto3: Ensure that you have the Boto3 library installed in your Python environment. You can install Boto3 using pip:
-
Configure AWS Credentials:
Make sure that you have configured your AWS credentials with the necessary permissions to modify the RDS instance. You can set up your AWS credentials by either setting environment variables or using the AWS CLI
aws configurecommand. - Write Python Script: Create a Python script with the following code to enable the Performance Insights feature for the desired RDS instance:
'your_rds_instance_identifier' with the actual identifier of your RDS instance. You can also specify the KMS key ID and retention period according to your requirements.- Run the Script: Execute the Python script in your terminal or IDE. This will make an API call to AWS to modify the RDS instance and enable the Performance Insights feature.