Amazon RDS
What is it?
Amazon RDS is a managed service that runs relational databases like PostgreSQL or MySQL for you, handling setup, backups, and maintenance.
Explain like I'm 5
Why was it created?
Running a database yourself means patching, backups, and failover work. RDS was created to take that operational burden off your hands.
Where is it used?
- Managed relational databases on AWS
- Web and app backends
- Automated backups and failover
- Reducing database operations work
Why should developers care?
RDS is a common way teams run databases on AWS, so cloud developers frequently use it instead of self-managing.
How does it work?
You choose a database engine and instance size; RDS provisions it and manages patching, automated backups, and optional standby replicas for failover. You still design schemas and queries, but skip the server upkeep.
Real-world example
A team runs PostgreSQL on RDS with automated daily backups and a standby in another zone, so they never manually patch or babysit the database server.
Common use cases
- Managed SQL databases
- Automated backups and patching
- High-availability with standby replicas
- Offloading database ops
Advantages
- Managed maintenance and backups
- Easy high availability
- Multiple engine choices
- Less operational burden
Disadvantages
- Less low-level control
- Costs more than raw self-hosting
- Some engine features limited
- Vendor lock-in
When should you use it?
When you want a relational database on AWS without managing servers yourself.
When should you avoid it?
When you need full control of the database host, or a NoSQL store fits better.
Alternatives
Related terms
Interview questions
Beginner
- What is Amazon RDS?
- What does 'managed' mean here?
Intermediate
- What does RDS handle for you?
- How does RDS provide high availability?
Senior
- When would you choose RDS over self-managing on EC2?
- How do read replicas help scale RDS?
Common misconceptions
- "RDS designs your database for you" — it manages the server, but you still design schemas and queries.
- "RDS is a database engine" — it runs engines like PostgreSQL and MySQL; it isn't one itself.
Fun facts
- RDS stands for Relational Database Service.
- It supports several engines, including PostgreSQL, MySQL, and others.
Timeline
- 2009 — Amazon RDS launches
Learning resources
Quick summary
Amazon RDS runs managed relational databases (PostgreSQL, MySQL, and more), handling backups, patching, and failover so you skip server upkeep.
Cheat sheet
- Managed relational databases
- Handles backups + patching
- Easy high availability
- You still design schema/queries