AWS RDS — Managed Database Guide

Sanjeev SharmaSanjeev Sharma
1 min read

Advertisement

AWS RDS — Managed Database Guide

AWS RDS provides managed relational databases with automated backups and scaling.

Creating Instances

# Create PostgreSQL instance
aws rds create-db-instance \
  --db-instance-identifier mydb \
  --db-instance-class db.t3.micro \
  --engine postgres \
  --master-username admin \
  --master-user-password MyPassword123 \
  --allocated-storage 20 \
  --backup-retention-period 7

# Create MySQL instance
aws rds create-db-instance \
  --db-instance-identifier mydb \
  --db-instance-class db.t3.small \
  --engine mysql \
  --engine-version 8.0.35

Backups and Restoration

# Create manual 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

FAQ

Q: What's the benefit of RDS over self-hosted? A: Automated backups, patches, and high availability without maintenance burden.

Q: Can I scale RDS vertically? A: Yes, modify instance class with minimal downtime.

Advertisement

Sanjeev Sharma

Written by

Sanjeev Sharma

Full Stack Engineer · E-mopro