Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. You can migrate existing applications and tools that utilize a relational database to Amazon Web Services because Amazon RDS offers access to the capabilities of a MySQL, Oracle, SQL Server, and the PostgreSQL database engine. Amazon RDS provides cost-efficient and resizable capacity while managing time-consuming database administration tasks. This efficiency frees you to focus on your applications and business.
Lab Objectives
Upon completion of this lab, you will be able to:
- Use the AWS Management Console to create RDS subnet groups
- Create RDS database clusters
- Manage access to RDS clusters using security group rules
- Connect to your RDS cluster and edit tables
Lab Prerequisites
You should be familiar with:
- The basics of working with Linux at the command line
- Networking rules and database concepts familiarity is helpful but not required
Updates
May 2nd, 2024 - Resolved AWS Systems Manager issue
March 21st, 2024 - Resolved RDS database creation issue
August 30th, 2023 - Updated the instructions and screenshots to reflect the latest UI
February 3rd, 2023 - Updated the instructions and screenshots to reflect the latest UI
March 29th, 2022 - Added instructions for clarity
December 28th, 2021 - Updated screenshots to reflect the latest UI
December 24th, 2020 - Added a warning to prevent a bug in the AWS Console that doesn't allow the selection of availability zones when creating the subnet group
November 3rd, 2020 - Updated db instance type screenshot and instruction
August 11th, 2020 - Resolved an issue causing the MySQL security group inbound access check to fail
August 10th, 2020 - Updated the steps to create a VPC security group to associate to the RDS DB
April 19th, 2020 - Updated the lab to reflect the latest Console interface
March 12th, 2020 - Inserted a lab step that instructs the user to destroy an RDS instance
September 13th, 2019 - Updated the lab IAM policy to allow the RDS DB instance to be created after recent changes AWS' made to IAM condition processing for creating RDS DB instances
August 20th, 2019 - Updated the lab to reflect AWS's newest user interface
July 3rd, 2019 - Updated database creation instructions to include the storage autoscaling option
May 31st, 2019 - Replaced SSH connection with a browser-based Session Manager shell
May 30th, 2019 - Updated the formatting of this lab to improve quality
May 2nd, 2019 - Updated screenshots and instructions to improve the lab's quality
March 7th, 2019 - Updated screenshots and instructions because of AWS dashboard changes
November 27th, 2018 - Added a validation lab step to check the work you perform in the lab
May 14th, 2018 - Updated screenshots and improved instruction clarity for connecting to the EC2 instance
April 9th, 2018 - Updated screenshots to match the new UI
Environment before
Environment after
Matt has worked for multiple Fortune 500 companies as a DevOps Engineer and Solutions Architect. He is an AWS Certified DevOps Engineer - Professional, and an AWS Certified Solution Architect - Associate. He enjoys reading and learning new technologies.