majiayu000 AWS RDS
Deploy managed relational databases with Amazon RDS.
Create Database
aws rds create-db-instance \
--db-instance-identifier mydb \
--db-instance-class db.t3.micro \
--engine postgres \
--engine-version 15 \
--master-username admin \
--master-user-password secretpassword \
--allocated-storage 20 \
--storage-encrypted \
--vpc-security-group-ids sg-xxx \
--db-subnet-group-name my-subnet-group \
--backup-retention-period 7 \
--multi-az
Parameter Groups
aws rds create-db-parameter-group \
--db-parameter-group-name custom-pg \
--db-parameter-group-family postgres15 \
--description "Custom PostgreSQL parameters"
aws rds modify-db-parameter-group \
--db-parameter-group-name custom-pg \
--parameters "ParameterName=max_connections,ParameterValue=200,ApplyMethod=pending-reboot"
Snapshots & Recovery
# Create snapshot
aws rds create-db-snapshot \
--db-instance-identifier mydb \
--db-snapshot-identifier mydb-snapshot
# Restore from snapshot
aws rds restore-db-instance-from-db-snapshot \
--db-instance-identifier mydb-restored \
--db-snapshot-identifier mydb-snapshot
Read Replicas
aws rds create-db-instance-read-replica \
--db-instance-identifier mydb-replica \
--source-db-instance-identifier mydb
Best Practices
- Enable Multi-AZ for production
- Use encryption at rest
- Implement automated backups
- Use read replicas for read scaling
- Store credentials in Secrets Manager
Related Skills
- terraform-aws - IaC deployment
- aws-secrets-manager - Credentials