Mitigating Amazon RDS Performance Bottlenecks With a Read Replica

Lab Steps

lock
Logging in to the Amazon Web Services Console
lock
Connecting to the Virtual Machine using EC2 Instance Connect
lock
Testing the Amazon RDS Database Instance
lock
Creating an Amazon RDS Read Replica

Ready for the real environment experience?

DifficultyBeginner
Time Limit1h 30m
Students22

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:

Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students32689
Labs79
Courses2
Learning paths2

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 the Developer - Associate, Sysops Administrator - Associate, and Solutions Architect – Associate AWS certifications.