What services have you used with Amazon RDS?

• Amazon EC2: Deployment of applications that interact with the RDS database.
• Amazon S3: Storage of data backups from RDS, database snapshots, or export results.
• Amazon CloudWatch: Monitoring RDS performance metrics (CPU Utilization, FreeableMemory, DatabaseConnections, etc.), setting alarms.
• Amazon KMS: Encrypting RDS data to ensure security both at rest and in transit.
• AWS Lambda: Executing automated tasks, such as scheduled database snapshots, old snapshot cleanup, RDS event notifications.
• AWS Secrets Manager / AWS Systems Manager Parameter Store: Secure storage of credentials for RDS access.
• Amazon VPC: Hosting RDS instances in a private network for controlled access.
• AWS Config: Tracking changes in RDS instance configurations and ensuring policy compliance.
• AWS Database Migration Service (DMS): Migrating databases to RDS or between RDS instances.
• AWS Glue: ETL processes, extracting data from RDS, transformations.
• Amazon EKS / ECS: Hosting containerized applications using RDS as a backend.
• Terraform / CloudFormation: Automating deployment and management of RDS instances and related resources.

# Example AWS CLI command to create a database snapshot
aws rds create-db-snapshot \
    --db-instance-identifier my-rds-instance \
    --db-snapshot-identifier my-snapshot-$(date +%Y-%m-%d-%H-%M)

# Example Python code to query CloudWatch metrics
import boto3

client = boto3.client('cloudwatch')

response = client.get_metric_statistics(
    Namespace='AWS/RDS',
    MetricName='CPUUtilization',
    Dimensions=[
        {
            'Name': 'DBInstanceIdentifier',
            'Value': 'my-rds-instance'
        },
    ],
    StartTime='2023-01-01T00:00:00Z',
    EndTime='2023-01-01T23:59:59Z',
    Period=300,
    Statistics=['Average']
)

print(response)