1. Login to AWS Console: Go to the AWS Management Console (https://aws.amazon.com/console/) and login using your credentials.
2. Navigate to RDS Service: Click on the “Services” dropdown in the top left corner of the console, then select “RDS” under the “Database” category.
3. Select RDS Instance: In the Amazon RDS dashboard, select the RDS instance for which you want to enable Enhanced Monitoring.
4. Enable Enhanced Monitoring: Click on the RDS instance name to open the details page. In the navigation pane on the left, click on “Configuration” to expand the configuration options.
5. Modify Instance: Click on the “Modify” button at the top of the page to modify the instance settings.
6. Enable Enhanced Monitoring: Scroll down to the “Monitoring” section of the Modify DB Instance page. Look for the “Enhanced monitoring” option and select the desired monitoring level (e.g., Basic, Enhanced, or Performance Insights).
7. Save Changes: Scroll to the bottom of the page and click on the “Continue” button. Review the changes you are about to make, and then click on the “Modify DB Instance” button to apply the changes.
8. Monitor Status: Once the modification is complete, the status of the RDS instance will change to “modifying.” You can monitor the progress of the modification in the RDS console.
9. Verify Enhanced Monitoring: After the modification is completed, go back to the RDS instance details page and check the monitoring section to ensure that Enhanced Monitoring is enabled for the instance.

​

1. Install Boto3: If you haven’t already installed the Boto3 library, you can do so using pip:
   pip install boto3
   
2. Configure AWS Credentials: Ensure that you have configured your AWS credentials either by setting environment variables or using the AWS CLI aws configure command.
3. Write a Python script: Create a Python script with the following code to enable Enhanced Monitoring for your RDS instance:
   import boto3
   
   # Initialize the RDS client
   rds_client = boto3.client('rds')
   
   # Specify the RDS instance identifier for which you want to enable Enhanced Monitoring
   instance_identifier = 'your_rds_instance_identifier'
   
   # Enable Enhanced Monitoring for the specified RDS instance
   try:
       response = rds_client.modify_db_instance(
           DBInstanceIdentifier=instance_identifier,
           MonitoringInterval=60,  # Monitoring interval in seconds (1 minute)
           MonitoringRoleArn='arn:aws:iam::123456789012:role/monitoringRole',  # Replace with your IAM role ARN
           EnableEnhancedMonitoring=True
       )
       print(f"Enhanced Monitoring enabled for RDS instance {instance_identifier}")
   except Exception as e:
       print(f"Error enabling Enhanced Monitoring: {str(e)}")
   
4. Replace the placeholders:
   • Replace 'your_rds_instance_identifier' with the actual RDS instance identifier for which you want to enable Enhanced Monitoring.
   • Replace 'arn:aws:iam::123456789012:role/monitoringRole' with the ARN of the IAM role that has permissions to publish monitoring data to CloudWatch.
5. Run the Python script: Execute the Python script in your terminal or IDE to enable Enhanced Monitoring for the specified RDS instance. Make sure to review the output for any errors.

resource "aws_iam_role" "rds_monitoring_role" {
  name = "rds-monitoring-role"

  assume_role_policy = jsonencode({
    Version = "2012-10-17"
    Statement = [
      {
        Effect = "Allow"
        Principal = {
          Service = "monitoring.rds.amazonaws.com"
        }
        Action = "sts:AssumeRole"
      }
    ]
  })
}

resource "aws_iam_role_policy_attachment" "rds_monitoring_role_attach" {
  role       = aws_iam_role.rds_monitoring_role.name
  policy_arn = "arn:aws:iam::aws:policy/service-role/AmazonRDSEnhancedMonitoringRole"
}

resource "aws_db_instance" "rds_instance" {
  # EXISTING ARGUMENTS HERE
  # e.g. identifier = "YOUR_RDS_INSTANCE_IDENTIFIER"

  identifier = "YOUR_RDS_INSTANCE_IDENTIFIER" # replace with your DB instance identifier

  monitoring_interval = 60
  monitoring_role_arn = "arn:aws:iam::YOUR_AWS_ACCOUNT_ID:role/rds-monitoring-role" # replace YOUR_AWS_ACCOUNT_ID

  # OTHER REQUIRED RDS ARGUMENTS ...
}

• aws_iam_role.rds_monitoring_role and aws_iam_role_policy_attachment.rds_monitoring_role_attach being created (if not already managed), and
• aws_db_instance.rds_instance updated in-place with monitoring_interval = 60 and the specified monitoring_role_arn.