hands-on lab

Mitigating Amazon RDS Performance Bottlenecks With a Read Replica

Beginner
1h 30m
113
3.6/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
Lab description

Amazon Relational Database Service (RDS) is a web service that allows you to create and manage a relational database in the AWS cloud. By using Amazon RDS, you can avoid the technical complexity of manually setting up and operating a highly available relational database.

By learning how to create a read-only replica instance, you can scale your applications and avoid performance bottlenecks.

In this hands-on lab, you will create a MySQL database and populate it with data. You will generate load and and run queries against the database and observe the affects.

Please note, this lab creates an Amazon RDS instance which can take up to 10 minutes to complete. Please make sure you have enough time available before starting this lab.

Learning Objectives

Upon completion of this beginner level lab, you will be able to:

  • Create a MySQL database schema and apply it to an instance
  • Run a timed query against a MySQL database instance
  • Generate synthetic load on a MySQL database instance
  • Create a read-only replica

Intended Audience

  • Candidates for the AWS Solutions Architect Associate certification
  • Cloud Architects
  • Data Engineers
  • DevOps Engineers

Prerequisites

Familiarity with the following will be beneficial but is not required:

  • The Bash terminal
  • MySQL
  • Amazon RDS

The following courses and labs can be used to fulfill the prerequisites:

Updates

December 12th, 2023 - Addressed user ban issue and promptly added a warning

May 16th, 2023 - Updated the RDS MySQL database to the latest version

Environment before
Environment after
About the author
Avatar
Andrew Burchill
Labs Developer
Students
65,357
Labs
161
Courses
2
Learning paths
4

Andrew is a Labs Developer with previous experience in the Internet Service Provider, Audio Streaming, and CryptoCurrency industries. He has also been a DevOps Engineer and enjoys working with CI/CD and Kubernetes.

He holds multiple AWS certifications including Solutions Architect Associate and Professional.

Covered topics
Lab steps
Logging In to the Amazon Web Services Console
Connecting to the Virtual Machine using EC2 Instance Connect
Testing the Amazon RDS Database Instance
Creating an Amazon RDS Read Replica