Questions and Answers
Which type of storage is ideal for I/O intensive workloads?
Automated backups can take place if a DB snapshot is running in the same AWS region for the same database.
False
What type of storage is not recommended for current use in DB Instances?
Magnetic (standard)
AWS recommends exporting long-term backups to an ______ bucket.
Signup and view all the answers
Match the types of DB Instance storage with their descriptions:
Signup and view all the answers
What is the maximum allowed storage for Magnetic (standard) DB Instances?
Signup and view all the answers
What happens to automated backups when a DB is deleted?
Signup and view all the answers
The first snapshot of a DB instance contains only incremental data.
Signup and view all the answers
What is one benefit of using AWS Outposts for RDS?
Signup and view all the answers
A DB instance can contain only one database.
Signup and view all the answers
Name one of the DB engines currently supported by AWS.
Signup and view all the answers
A DB Instance Class determines the ______ and ______ capacity of a DB instance.
Signup and view all the answers
Which DB instance class is described as having balanced compute, memory, and networking?
Signup and view all the answers
The application servers and RDS DB instances must reside in the same Availability Zone (AZ).
Signup and view all the answers
What happens if both the application and DB instance are in the same AZ when the DB goes down?
Signup and view all the answers
Match the DB instance type with its capability:
Signup and view all the answers
What does AWS RDS stand for?
Signup and view all the answers
AWS RDS fully manages CPU, memory, and IOPS configurations for databases without user intervention.
Signup and view all the answers
Name two database products that can be used with Amazon RDS.
Signup and view all the answers
AWS RDS manages __________, automatic failure detection, and recovery.
Signup and view all the answers
What is one advantage of using Amazon RDS over an on-premise server?
Signup and view all the answers
Match the following functionalities with Amazon RDS features:
Signup and view all the answers
AWS manages all database administrative tasks when using Amazon EC2.
Signup and view all the answers
What does IAM stand for in the context of Amazon RDS?
Signup and view all the answers
Study Notes
AWS RDS Overview
- AWS RDS (Relational Database Service) simplifies setting up, operating, and scaling relational databases in the cloud.
- It offers cost-efficient, resizable database capacity and handles common administration tasks, allowing users to focus on applications rather than management.
- Key tasks managed by AWS include scaling, high availability, backups, power, and cooling.
Database Deployment Options
- Databases can be run on Amazon EC2, which provides scalable computing capacity.
- With EC2, users customize CPU, memory, and IOPS allocations according to needs, while AWS manages infrastructure below the OS layer.
RDS vs. EC2 Managed Databases
- Amazon RDS is a managed database service that automates most management tasks, freeing up resources for application development.
- Compatible database engines include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
- RDS automates backups, failure detection, and recovery, ensuring reliable data restoration and read scaling through read replicas.
- IAM (Identity and Access Management) is utilized to restrict database access.
Custom RDS Services
- Amazon RDS offers Custom service for Oracle and Microsoft SQL Server, merging EC2 flexibility with RDS automation.
- RDS can extend operations to AWS Outposts, utilizing the same hardware as public AWS regions for on-premises applications.
DB Instances
- A DB instance is an isolated database environment that can contain multiple user-created databases.
- Interactions with application servers take place within different Availability Zones (AZs) while residing in the same Virtual Private Cloud (VPC).
DB Engines
- Supported DB engines include Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL.
- Each engine has unique features based on its version.
DB Instance Classes
- Class selection determines computational and memory capacity, impacting performance.
- Types include:
- General purpose for balanced compute and memory
- Memory optimized for high compute and memory needs
- Compute optimized for intensive workloads (multi-AZ only)
- Burstable performance for short high-performance bursts
Storage Options
- DB instances utilize AWS EBS volumes for storage. Three storage types include:
- Provisioned IOPS SSD for I/O intensive workloads.
- General Purpose SSD for medium-sized DB instances, ideal for development and testing.
- Magnetic storage is legacy and not recommended, with a max of 3 TiB.
Backup Management
- Amazon RDS performs automatic backups during user-defined windows; default is a random 30-minute window within an 8-hour period.
- Backups encompass the entire DB instance, and automated backups require the DB to be in "available" state.
- Manual snapshots can be created and do not expire; they are crucial for long-term backup strategies.
- Snapshots are incremental after the initial full database snapshot.
- Automated backups are deleted when the DB is deleted unless a retention period is specified; manual snapshots remain unaffected.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz introduces you to AWS RDS, a service that simplifies the setup, operation, and scaling of relational databases in the cloud. Learn about its features, including cost-effective scalability and automated administration tasks, making database management efficient and reliable.
