Interview › Databases & Caching

What is Amazon RDS, and what does it manage for you versus self-managed databases?

Databases & Caching · Basic level

Answer

Amazon RDS is AWS managed relational database service. AWS handles provisioning, backups, patching, storage operations, monitoring integration, and HA primitives, while the customer still owns schema design, query tuning, access control, data correctness, capacity choices, and application connection behavior.

Technical explanation

RDS removes much of the undifferentiated DBA work but it does not remove database engineering accountability.

The shared responsibility line matters: AWS manages the platform; the team manages workload design, users, queries, parameters, and safe changes.

A strong SRE answer mentions both managed-service benefits and remaining operational risks such as bad SQL, connection storms, and poor indexing.

Hands-on example

Create a small encrypted PostgreSQL instance, then validate what remains your responsibility:

$ aws rds create-db-instance --db-instance-identifier app-dev-pg --engine postgres --db-instance-class db.t4g.micro --allocated-storage 20 --backup-retention-period 7 --storage-encrypted

After creation: create least-privilege app users, restrict the security group to app subnets, enable slow query logging, test restore, and baseline CPU, connections, and query latency.

More Databases & Caching interview questions

• What database engines does RDS support?
• What is the difference between RDS and Aurora?
• What is Multi-AZ in RDS, and how does automatic failover work?
• How long does an RDS Multi-AZ failover typically take, and what triggers it?
• What is the difference between Multi-AZ and a read replica?
• When would you use a read replica, and can it become a standalone database?
• Can a read replica be in a different region, and why would you do that?
• What is the difference between automated backups and manual snapshots in RDS?

← All Databases & Caching questions