AWS Fundamentals: RDS/RDS Custom Flashcards
What is AWS RDS?
AWS RDS (Relational Database Service) is a managed service that allows you to run and manage relational databases in the cloud. It supports several SQL-based database engines and automates tasks such as provisioning, patching, backups, and scaling.
What are the database engines supported by AWS RDS?
PostgreSQL
MySQL
MariaDB
Oracle
Microsoft SQL Server
IBM DB2
Amazon Aurora (AWS proprietary database)
Why use AWS RDS over deploying a database on EC2?
Automated provisioning and OS patching
Continuous backups with Point in Time Restore
Monitoring dashboards
Read replicas for improved read performance
Multi-AZ deployments for disaster recovery
Scaling capabilities (vertical and horizontal)
EBS-backed storage
What is RDS Storage Auto Scaling?
RDS Storage Auto Scaling automatically increases the storage capacity of your database when it is running out of space. This happens without any downtime, and the scaling is done based on pre-defined thresholds.
How does RDS Storage Auto Scaling work?
RDS Storage Auto Scaling is triggered when the free storage space falls below 10% of the allocated storage, and this condition persists for more than 5 minutes. It will only trigger if 6 hours have passed since the last storage modification. You can set a maximum storage threshold to prevent unlimited scaling.
What are the benefits of RDS Storage Auto Scaling?
Prevents manual intervention: No need to manually increase storage.
Supports unpredictable workloads: Automatically scales when needed.
No downtime: RDS handles storage scaling without requiring database downtime.
Works with all RDS database engines.
What is Point in Time Restore in AWS RDS?
Point in Time Restore allows you to restore an RDS database to a specific timestamp. This is useful for recovering from unintended data loss or corruption.
What is Multi-AZ in AWS RDS?
Multi-AZ is a deployment option in AWS RDS that automatically replicates your database to a standby instance in a different Availability Zone (AZ) for high availability and failover. This helps improve disaster recovery.
What is the maximum storage threshold in RDS?
The maximum storage threshold is the upper limit that you can define for the automatic storage scaling in RDS. It prevents the storage from growing beyond a specified capacity.
Can you SSH into RDS instances?
No, you cannot SSH into RDS instances. AWS manages the underlying infrastructure and prevents direct access to the EC2 instances running the RDS databases.
What are the scaling capabilities of AWS RDS?
AWS RDS supports both vertical scaling (changing instance size) and horizontal scaling (using read replicas). You can increase the database instance size or add read replicas to improve read performance.
Does AWS RDS provide automatic backups?
Yes, AWS RDS automatically creates backups of your database. These backups are stored for a retention period that you can configure, and you can restore the database to any point within this retention period.
What are Read Replicas in AWS RDS?
RDS Read Replicas are used to scale reads in applications. They provide additional read capacity by asynchronously replicating data from the primary database instance. They help offload read-heavy workloads without impacting the performance of the primary database.
How many Read Replicas can you create in AWS RDS?
You can create up to 15 Read Replicas in AWS RDS.
What is the replication method for RDS Read Replicas?
RDS Read Replicas use asynchronous replication, meaning changes made in the primary database are eventually propagated to the replicas. This results in eventual consistency, where there may be a delay in data appearing on the Read Replicas.
Can Read Replicas be promoted to independent databases?
Yes, a Read Replica can be promoted to its own independent database instance, allowing it to accept write operations and function as a standalone database.
What types of operations can be performed on RDS Read Replicas?
RDS Read Replicas are read-only by design. They can only handle SELECT queries, and not INSERT, UPDATE, or DELETE operations.
What are the networking cost implications of using RDS Read Replicas?
Same region, different Availability Zones (AZs): No additional networking cost (managed service).
Cross-region Read Replicas: There is a network cost for replicating data across regions.
What is the primary use case for RDS Read Replicas?
RDS Read Replicas are typically used for offloading read-heavy workloads such as reporting or analytics. By using a Read Replica, you can avoid overloading the primary database with read traffic.
Can RDS Read Replicas be used for scaling writes?
No, RDS Read Replicas are designed for read scaling only. They cannot handle write operations, which must be directed to the primary database.
What is RDS Multi-AZ used for?
RDS Multi-AZ is designed for disaster recovery. It provides a synchronous replication between the primary database instance and a standby instance in a different Availability Zone. This ensures high availability and failover protection.
How does RDS Multi-AZ handle failover?
If the primary database instance in RDS Multi-AZ fails (due to an AZ failure or database issues), the standby instance is automatically promoted to become the new primary database. The DNS name of the database remains the same, so applications continue to work with minimal disruption.
What is the replication method for RDS Multi-AZ?
RDS Multi-AZ uses synchronous replication, meaning that every write to the primary database is also replicated immediately to the standby instance. Both databases stay in sync.
Can you perform read operations on the standby instance in RDS Multi-AZ?
No, it cannot be used for read or write operations unless it is promoted to become the primary instance.