[ SRE_ARENA ]
← BACK TO ROADMAP
RELATIONAL DBS (RDS & AURORA)

Relational Databases: RDS, Aurora & Proxies

DOWNLOADING CONCEPT: 1. THE MANAGED DATABASE (RDS)...

↳Historically, DBAs would launch a server, install PostgreSQL, set up cron jobs for backups, and panic when the hard drive ran out of space.

Amazon RDS (Relational Database Service)
  • ↳is a fully managed service for Postgres, MySQL, MariaDB, Oracle, and SQL Server.
  • ↳You just click a button and AWS provisions the underlying EC2 instance, installs the database engine, handles OS patching, takes daily automated snapshots, and manages storage scaling.
  • ↳You lose root SSH access to the OS, but you gain peace of mind.
▲ LIVE INCIDENTA massive marketing email just went out. Your RDS PostgreSQL primary database CPU is pegged at 100%. The application is crashing because queries are timing out.
sre@arena:~/cloud-rds
sre@arena:~$ psql -h primary-db.cluster-xxxx.us-east-1.rds.amazonaws.com -U admin -c "SELECT * FROM pg_stat_activity WHERE state = 'active';"