Skip to main content
DatabaseDatabaseBeginnerCLF-C02SAA-C03

RDS

Amazon Relational Database Service

A relational database whose operations are supported by AWS.

In one sentence

A relational database whose operations are supported by AWS.

Overview

A managed service for running relational databases such as MySQL and PostgreSQL. Provides settings such as backups and Multi-AZ.

Common use cases

  • Storing order and user data
  • Business applications that use SQL
  • Applications that require transactions

CLF-C02 exam points

  • Suitable for structured data and SQL
  • Use Multi-AZ to improve availability
  • Use Read Replicas to scale read performance

SAA-C03 exam points

  • Multi-AZ targets availability; Read Replicas target read performance
  • Consider backup retention period and storage costs
  • Design subnet groups and Security Groups

Practical Use

Amazon Relational Database Service (Amazon RDS) is a managed relational database service. AWS takes over operational tasks such as OS patching, minor version upgrades of the database engine, automated backups, snapshot creation, and automatic failover during failures, allowing users to focus on schema design, query tuning, and application-side logic. Supported database engines include Amazon Aurora (MySQL/PostgreSQL compatible), MySQL, PostgreSQL, MariaDB, Oracle Database, and Microsoft SQL Server, for a total of six engines. Instance type, storage type, and storage capacity can be chosen to fit the workload, and an option for automatic storage scaling based on usage is also available. Major features for availability and fault tolerance include Multi-AZ deployment (placing a primary and a synchronous standby in different AZs, with automatic failover during failures), read replicas (load balancing for read queries and certain cross-region configurations), point-in-time recovery via automated backups, and manual snapshots for point-in-time preservation. Pricing is based on a combination of DB instance running time multiplied by instance type, storage capacity, backup capacity, and data transfer volume. Long-term commitment discounts via Reserved Instances are also available. In CLF-C02, a frequent topic is the division of responsibilities under the shared responsibility model (who handles patching and backups) when comparing self-managed databases on EC2 with using RDS.

Official Documentation

Cost notes

  • Billed based on instance runtime and storage
  • Tends to become a fixed cost in personal MVPs

Security notes

  • Do not expose the DB to the public internet
  • Verify at-rest encryption and backup settings

Related services

Related comparison articles

Related architecture diagrams

Tags

databaserelational

Last updated: 2026-06-01