Relational Database Service (RDS) Flashcards
What are the 6 available database options for RDS
MySQL
Oracle
MariaDB
Amazon Aurora
PostgreSQL
Microsoft SQL Server
True or False, ALL RDS engines support encryption (except for some older versions)
True, by Key Management Service (KMS)
What are the 2 RDS backup options?
- Automated Backups
It’s activated by default and it’s stored inside S3 (Choose a retention period between 0 and 35 days) - Manual Snapshots
They persist even if you delete the Original RDS instance
Which type of RDS backup persists even if you delete the original instance?
Manual Snapshot
Backup data is never restored overtop of an existing instance.
What happens when restoring a RDS backup?
Backup always results…
… in creation of a new RDS instance
RDS allows point-in-time recovery targeted down to how long inside the retention period?
1 Second
When recovering AWS will take the most recent daily backup, and apply transaction log data relevant to that day. This allows point-in-time recovery down to a second inside the retention period.
This RDS feature ensures a database remains available, even if an availability zone goes down.
RDS Multi-AZ Deployment
The standby slave is there as a backup, If one AZ goes Down failover will occur and the standby slave will be promoted to master
When using read replicas, the primary database copy is referred to as what?
Master
Do RDS Read Replicas happen synchronously, or asynchronously?
asynchronously
Which RDS feature reduces loads to the database?
Read Replias
- Read-Replicas allow you to run multiples copies of your database, these copies only allows reads (no writes) and is intended to alleviate the workload of your primary database to improve performance
- You can have up to 5 replicas of a database Each Read Replica will have its own DNS Endpoint
- You can have Multi-AZ replicas, replicas in another region, or even replicas of other read replicas
- Replicas can be promoted to their own database, but this breaks replication No automatic failover, if primary copy fails you must manually update urls to point at copy.
Multi-AZ Deployments
VS
Read Replicas
A. Only database engine on primary instance is active
A. Always span two Availability Zones within a single Region
A. Automatic failover to standby when a problem is detected
B. All read replicas are accessible and can be used for read scaling
B. Can be within an Availability Zone, Cross-AZ, or Cross-Region
B. Can be manually promoted to a standalone database instance
Where can you find Performance Insights
AWS RDS
Performance Insights expands on existing Amazon RDS monitoring features to illustrate your database’s performance and help you analyze any issues that affect it. With the Performance Insights dashboard, you can visualize the database load and filter the load by waits, SQL statements, hosts, or users.
What are reserved Instances In RDS?
Amazon RDS Reserved Instances give you the option to reserve a DB instance for a one or three year term and in turn receive a significant discount compared to the On-Demand Instance pricing for the DB instance.
What does a Migration allow to do in RDS?
You can migrate your RDS PostgreSQL to Aurora
What is an on-demand, auto-scaling configuration for Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. It enables you to run your database in the cloud without managing any database capacity.
Amazon Aurora Serverless
