hands-on lab

Improving Application Performance and Resiliency Using Amazon RDS Proxy

Difficulty: Beginner
Duration: Up to 1 hour and 15 minutes
Students: 3,950
Rating: 4.1/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.

Description

Amazon RDS Proxy is a highly available proxying service for use with MySQL and PostgreSQL Amazon RDS databases. Using Amazon RDS Proxy, you can increase the scalability and resilience of your Amazon RDS database-backed applications.

Learning how to create and configure an Amazon RDS Proxy will make you more effective at deploying performant and fault-tolerant applications in the public AWS cloud.

In this hands-on lab, you will create a new Amazon RDS Proxy and test its connection pooling feature.

Please note, this lab creates an Amazon Aurora MySQL cluster from scratch which takes over ten minutes to complete. You will also create an RDS proxy which typically takes up to 5 minutes, but can take up to 20 minutes. Please make sure you have enough time available before starting the lab.

Learning Objectives

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

  • Create an Amazon RDS Proxy
  • Inspect an RDS Proxy using the AWS command-line interface
  • Run a connection load test

Intended Audience

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

Prerequisites

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

  • Amazon RDS and Amazon RDS Proxy
  • The AWS command-line interface
  • The Bash command-line shell

The following content can be used to fulfill the prerequisites:

Updates

September 19th, 2023 - Updated the instructions and screenshots to reflect the latest UI

March 1st, 2023 - Resolved Environment Error

Environment before

Environment after

Covered topics

Lab steps

Logging In to the Amazon Web Services Console
Creating an RDS Proxy
Connecting to the Virtual Machine using EC2 Instance Connect
Testing the RDS Proxy