AWS — RDS

What is RDS?

Managed relational database service supporting MySQL, PostgreSQL, Oracle, SQL Server.

Create database

aws rds create-db-instance \
  --db-instance-identifier mydb \
  --db-instance-class db.t2.micro \
  --engine mysql \
  --master-username admin \
  --master-user-password password123 \
  --allocated-storage 20

Connect

# Get endpoint
aws rds describe-db-instances \
  --db-instance-identifier mydb \
  --query "DBInstances[0].Endpoint.Address"

# Connect with MySQL
mysql -h mydb.xxxx.us-east-1.rds.amazonaws.com -u admin -p

Backup

# Create snapshot
aws rds create-db-snapshot \
  --db-instance-identifier mydb \
  --db-snapshot-identifier my-snapshot

# Restore from snapshot
aws rds restore-db-instance-from-db-snapshot \
  --db-instance-identifier mydb-restored \
  --db-snapshot-identifier my-snapshot

Scaling

# Scale vertically
aws rds modify-db-instance \
  --db-instance-identifier mydb \
  --db-instance-class db.t3.medium

# Scale storage
aws rds modify-db-instance \
  --db-instance-identifier mydb \
  --allocated-storage 100

Multi-AZ

aws rds modify-db-instance \
  --db-instance-identifier mydb \
  --multi-az

Read replicas

aws rds create-db-instance-read-replica \
  --db-instance-identifier mydb-replica \
  --source-db-instance-identifier mydb

Best practices

1. Enable automated backups
2. Use Multi-AZ for production
3. Use read replicas for scaling
4. Enable encryption

Mini Practice

1. Create a MySQL database
2. Connect and query
3. Create a snapshot
4. Enable Multi-AZ

Up Next

Continue with Lambda - Serverless Functions.