RDS availability, read scaling, backup recovery, and database updates use different mechanisms. These sections explain which copy serves reads, which copy can become a writer, and when recovery needs a new DB instance.
Managed vs self-managed databases
AWS offers managed services for relational databases, NoSQL databases and blockchain networks. Amazon RDS handles common administration tasks for relational databases, while RDS Custom allows access to the database environment and operating system.
How it works
- Choose a database type for the data: relational databases include Amazon RDS and Amazon Aurora; NoSQL databases include key-value, document and graph databases. Amazon RDS, NoSQL databases
- Use Amazon RDS Custom when a managed database needs customization of its database environment or operating system.
- Before customizing an RDS Custom for SQL Server host, pause automation for the change so monitoring and recovery do not interfere. Automation resumes when the pause ends.
Examples of database types:
| Type | Service |
|---|---|
| Relational | Amazon RDS, Amazon Aurora |
| Key-value NoSQL | Amazon DynamoDB |
| Document | Amazon DocumentDB |
| Graph | Amazon Neptune |
Exam cues
- If the question says key-value, document or graph database, think NoSQL: DynamoDB, DocumentDB or Neptune, respectively.
- If the question says install an agent on a managed SQL Server host, think RDS Custom for SQL Server and pause automation before the change.
- If the question says managed Hyperledger Fabric networks or Ethereum nodes, think Amazon Managed Blockchain.
Remember
- NoSQL: DynamoDB, DocumentDB, Neptune. Relational: RDS, Aurora.
- Amazon Managed Blockchain stopped accepting new customers on October 29, 2026; access ends after September 29, 2027.
Trap: Aurora is relational, while DynamoDB, DocumentDB and Neptune are NoSQL databases.
From the AWS docs (9)
- Amazon RDS is a managed service that makes it easier to set up, operate and scale a relational database and manages common database administration tasks.
- Amazon RDS Custom gives database administrators access to customize the database environment and operating system for legacy, custom and packaged applications, while automating administration tasks.
- Key-value (DynamoDB), document (DocumentDB) and graph (Neptune) databases are NoSQL, non-relational databases.
- Amazon Timestream is the purpose-built time series database; Timestream for LiveAnalytics is serverless with a memory store for recent data and a magnetic store for history, and Timestream for InfluxDB runs managed InfluxDB.
- Amazon Timestream for LiveAnalytics closed to new customers on June 20, 2025; AWS points new workloads to Timestream for InfluxDB.
- Amazon Managed Blockchain provides Ethereum and Bitcoin public nodes and private Hyperledger Fabric networks; it stopped accepting new customers on October 29, 2026, and existing customers lose access after September 29, 2027.
- RDS Custom exists for Oracle and SQL Server and grants privileged access to the database and the host operating system.
- Before customizing an RDS Custom host, pause RDS Custom automation for a set period so monitoring and instance recovery do not interfere; it resumes when the pause ends.
- RDS instance usage is billed in one-second increments with a 10-minute minimum.
RDS availability and scaling basics
Amazon RDS improves availability with Multi-AZ standbys and scales reads with read replicas.
How it works
- Multi-AZ keeps a standby copy in another Availability ZoneAn isolated location within an AWS Region used to separate database copies from a local failure..
- If the primary fails, RDS fails over to the standby.
- Read replicas copy the data so applications can send reads to them.
Exam cues
- If the question says high availability for RDS, think Multi-AZ.
- If the question says too many reads, think read replicas.
Remember
- Multi-AZ: availability. Read replicas: read scaling.
Trap: Multi-AZ is for availability, not performance.
Database choices and costs
Amazon RDS manages common database tasks, so teams can run relational databases with less administration. Choosing between RDS and a database on Amazon EC2 depends on how much control the application needs.
How it works
- Choose RDS for a supported relational engine when you want AWS to handle installation, patching, backups, scaling and availability. The customer still optimizes the application.
- Consider EC2 when you need full control of the operating system or database software, or an engine RDS does not support. RDS Custom offers database and operating system customization while automating administration tasks.
- For a long-running RDS database, consider a reserved DB instance for a discount. For RDS for Oracle, choose License Included or Bring Your Own License (BYOL). Reserved DB instances, Oracle licensing
Exam cues
- If the question says a MySQL database needs less patching and backup work, think RDS because it manages those tasks.
- If the question says an existing Oracle license should be used, think RDS for Oracle BYOL because it offers that licensing model.
- If the question says timestamped sensor readings, think Amazon Timestream for time series data. New customers should evaluate Timestream for InfluxDB because LiveAnalytics is closed to them. Timestream, availability change
Remember
- RDS supports IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.
- Reserved DB instances offer one-year or three-year terms, with No Upfront, Partial Upfront or All Upfront payment.
- Timestream for LiveAnalytics closed to new customers on June 20, 2025.
Trap: RDS manages database tasks, but the customer still optimizes the application.
From the AWS docs (9)
- Amazon RDS manages backups, software patching, automatic failure detection and recovery, and offers high availability with a synchronous secondary instance and read replicas for read scaling.
- On premises the customer manages everything; on Amazon EC2, AWS manages server maintenance, hardware lifecycle and power, network and cooling; with Amazon RDS, AWS also manages scaling, high availability, backups, database and OS patching and installation, while the customer still optimizes the application.
- AWS recommends Amazon RDS as the default for most relational databases; running a database on EC2 means more time managing software and more risk of user error, for example when patching manually.
- Amazon RDS Custom gives database administrators access to customize the database environment and operating system for legacy, custom and packaged applications, while automating administration tasks.
- Amazon RDS supports IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.
- RDS reserved DB instances give a discount for a one-year or three-year term, with No Upfront, Partial Upfront or All Upfront payment.
- RDS for Oracle offers two licensing models, License Included and Bring Your Own License (BYOL), and you can switch between them by modifying the DB instance.
- Amazon Timestream is the purpose-built time series database; Timestream for LiveAnalytics is serverless with a memory store for recent data and a magnetic store for history, and Timestream for InfluxDB runs managed InfluxDB.
- Amazon Timestream for LiveAnalytics closed to new customers on June 20, 2025; AWS points new workloads to Timestream for InfluxDB.
Flashcards
Nothing to review here right now. Pick other topics or another filter.
·
All 15 cards as a list
Which of these AWS databases are NoSQL: Amazon DynamoDB, Amazon Neptune, Amazon DocumentDB, Amazon Aurora?
DynamoDB (key-value), Neptune (graph) and DocumentDB (document). Aurora is relational.
Which managed AWS service helps a company run a relational database without handling routine database administration?
Amazon RDS. It helps set up, operate and scale relational databases and manages common administration tasks.
A company needs a managed relational database but also needs to customize its operating system for a legacy application. Which Amazon RDS option fits?
Amazon RDS Custom provides access to customize the database environment and operating system while automating administration tasks.
An RDS database must survive the loss of an Availability Zone. Which feature fits?
Multi-AZ deployment, with a standby in another Availability Zone.
A database is overloaded by reporting queries. Which RDS feature takes the reads?
Read replicas, read-only copies that serve the queries.
Does an RDS Multi-AZ standby (one-standby deployment) serve read traffic?
No. It is for failover; read replicas serve reads.
What does Amazon RDS manage that a database on Amazon EC2 leaves to the customer?
Database and OS installation and patching, backups, scaling, high availability, and failure detection and recovery.
A team wants a relational MySQL database without patching or backing it up themselves. Should they run it on EC2 or Amazon RDS?
Amazon RDS, which AWS recommends as the default for relational databases.
When does running a database yourself on Amazon EC2 make sense instead of Amazon RDS?
When you need full control of the operating system or database software, or an engine RDS doesn't support. RDS Custom is the managed option when you need OS access for some engines.
Which database engines does Amazon RDS support (besides Aurora)?
IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.
With Amazon RDS, does AWS optimize the customer's application queries?
No. Application optimization stays with the customer on premises, on EC2 and on RDS.
A company runs an Amazon RDS database around the clock for the next three years. How can it lower the instance cost?
Buy RDS reserved DB instances for a three-year term (No, Partial or All Upfront).
An RDS production database will run for years. How can its instance cost drop?
Buy RDS reserved DB instances for a one- or three-year term. They are a billing discount applied to matching DB instances.
Which RDS engine lets a company bring its own existing database licenses?
RDS for Oracle, which offers Bring Your Own License as well as License Included.
A company needs a managed relational database that supports PostgreSQL. Which AWS service can it choose?
Amazon RDS supports PostgreSQL and manages tasks such as backups and software patching.