hands-on lab

Improving Application Performance and Resiliency Using Amazon RDS Proxy

Beginner

Up to 1h 15m

3,414

4.1/5

Start lab

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 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

About the author

Andrew Burchill, opens in a new tab

Labs Developer

Students

66,517

Labs

164

Courses

Learning paths

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

Creating an RDS Proxy