Optimize slow databases with Amazon Aurora

Students will investigate and optimize slow database with available AWS RDS tools.

Level

Intermediate

Duration

Course Objectives

In this course, you will learn how to:

• Enable slow query logs in Amazon RDS to investigate underperforming MySQL queries
• Investigate performance with Amazon RDS Performance Insights
• Use best practice to optimize MySQL queries
• Use Aurora read replica auto-scaling feature to address the sudden increase in load

Intended Audience

This course is intended for:

• Data Engineers
• Developers
• DevOps Engineers

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Access to a notebook computer with Wi-Fi and Microsoft Windows, macOS X, or Linux (Ubuntu, SuSE, or Red Hat)

• **Note** The lab environment is not accessible using an iPad or tablet device, but you can use these devices to access the student guide

• An internet browser such as Chrome, Firefox, or Internet Explorer 9 (previous versions of Internet Explorer are not supported)

• Familiarity with MySQL database syntax and operation

• An SSH client such as PuTTY

• For Microsoft Windows users: Administrator access to the computer

Course Outline

• Task 1: Activate slow query logging in Aurora cluster
• Task 2: Creating CloudWatch Metrics for data visualization
• Task 3: RDS Performance Insights
• Task 4: Query optimization
• Task 5: Auto scaling