Amazon RDS basics

Topic: Cloud aws core

RDS is managed relational database (PostgreSQL, MySQL, MariaDB, etc). Create a DB instance in a VPC; connect with endpoint. Use when you want managed DB without handling backups and patches yourself.

Intent: How-to

Quick answer

  • Create DB instance in RDS. Choose engine, size, storage, VPC and subnet. Get endpoint and port. Connect from app in same VPC or via public access if enabled.
  • Automated backups and snapshots. Multi-AZ for failover. Read replicas for read scaling. Manage via console or CLI.
  • Secure with security groups; use IAM auth or username/password. Prefer private subnet and no public access in production.

Prerequisites

Steps

  1. Create DB instance

    RDS Create database. Engine, instance class, storage. VPC and subnet. Set master password. Create.

  2. Connect

    Use endpoint and port from RDS. Configure security group for app. Test from app or bastion.

  3. Backups and Multi-AZ

    Automated backups enabled by default. Enable Multi-AZ for failover. Create read replica if needed for reads.

Summary

RDS is managed relational database. Create instance in VPC; connect with endpoint. Use for managed DB without handling backups and patches.

Prerequisites

Steps

Step 1: Create DB instance

RDS Create database. Engine, instance class, storage. VPC and subnet. Master password. Create.

Step 2: Connect

Use endpoint and port from RDS. Configure security group for app. Test from app or bastion.

Step 3: Backups and Multi-AZ

Automated backups enabled by default. Enable Multi-AZ for failover. Read replica for reads if needed.

Verification

  • DB instance running. Can connect from app. Backups and Multi-AZ as configured.

Troubleshooting

Cannot connect — Check security group and subnet. High latency — Check instance size and Multi-AZ.

Next steps

Continue to