Optimize slow databases with Amazon Aurora

Languages Available: Español (Latinoamérica) | Français | Bahasa Indonesia | Italiano | 日本語 | 한국어 | Português (Brasil) | 中文（简体)

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

Level

Intermediate

Duration

2 Hours 0 Minutes

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