1. Navigate to RDS Console:
   • Open the AWS Management Console and navigate to the Amazon RDS service.
2. Select the RDS Instance:
   • From the list of RDS instances, select the instance for which you want to enable logging.
3. Enable Enhanced Monitoring:
   • In the navigation pane, choose “Logs & events” and then select “Enable Enhanced Monitoring”.
   • Choose the monitoring role that you want to associate with this DB instance.
   • Select the “Enable Enhanced Monitoring” checkbox and choose the monitoring level (0 to 4) that you want to enable.
4. Enable Performance Insights (Optional):
   • If you want to enable Performance Insights for the RDS instance, you can do so by selecting “Enable Performance Insights” in the “Logs & events” section.
5. Configure Enhanced Monitoring Data Granularity (Optional):
   • You can configure the data granularity for Enhanced Monitoring by selecting the “Configure” link next to the monitoring level.
6. Save Changes:
   • Click on the “Apply immediately” button to save the changes and enable logging for the RDS instance.
7. Verify Logging:
   • You can verify that logging has been enabled by checking the logs in the “Logs & events” section of the RDS instance.

​

1. Enable RDS Enhanced Monitoring: Enhanced Monitoring provides detailed visibility into the performance of your RDS instance. You can enable Enhanced Monitoring for your RDS instance by running the following AWS CLI command:

aws rds modify-db-instance --db-instance-identifier your-db-instance-name --monitoring-interval 60 --monitoring-role-arn arn:aws:iam::123456789012:role/service-role/AmazonRDSEnhancedMonitoringRole

2. Enable RDS Performance Insights: Performance Insights helps you detect performance problems in your RDS instance. You can enable Performance Insights by running the following AWS CLI command:

aws rds modify-db-instance --db-instance-identifier your-db-instance-name --enable-performance-insights --performance-insights-retention-period 7

3. Enable RDS Audit Logging: RDS Audit Logging allows you to capture database activities to help meet compliance requirements. You can enable Audit Logging by running the following AWS CLI command:

aws rds modify-db-instance --db-instance-identifier your-db-instance-name --enable-cloudwatch-logs-exports '["audit"]'

4. Verify the Changes: After making these changes, verify that RDS logging is enabled by checking the RDS instance configuration:

aws rds describe-db-instances --db-instance-identifier your-db-instance-name --query "DBInstances[0].[DBInstanceIdentifier,DBInstanceArn,MonitoringInterval,PerformanceInsightsEnabled,EnabledCloudwatchLogsExports]" --output table

1. Install Boto3:

pip install boto3

2. Use the following Python script to enable logging for your RDS instance. Replace <your_rds_instance_identifier> with the actual identifier of your RDS instance.

import boto3

# Specify the region where your RDS instance is located
region = 'us-east-1'

# Specify the identifier of your RDS instance
rds_instance_identifier = '<your_rds_instance_identifier>'

# Create a RDS client
rds_client = boto3.client('rds', region_name=region)

# Enable logging for the RDS instance
response = rds_client.modify_db_instance(
    DBInstanceIdentifier=rds_instance_identifier,
    EnableCloudwatchLogsExports=['error', 'general', 'slowquery']
)

# Print the response
print(response)

3. Run the Python script. After successful execution, logging should be enabled for your RDS instance.