Amazon Relational Database Service for MySQL - Troubleshooting

In this course, you will learn how to gather information about Amazon Relational Database Service (Amazon RDS) for MySQL. You can use this information to help troubleshoot common issues and provide effective support case details if you need to escalate to Amazon Web Services (AWS) Support.

This course will empower you to independently address support issues and potentially expedite resolution through shared troubleshooting approaches. This training content will supplement, not supplant, existing customer-facing documentation. It is intended to proactively provide opportunities to familiarize yourself with available content and approaches before an emergency need arises.

•     Course level: Intermediate

•     Duration: 45 minutes

Activities

This course includes introductory materials and troubleshooting instructions.

Course objectives

In this course, you will learn to:

•     Recognize and resolve issues with Amazon RDS for MySQL.

•     Employ best-practice troubleshooting methodologies when investigating Amazon RDS for MySQL issues.

•     Locate and apply available AWS Support documentation for Amazon RDS for MySQL issues.

•     Recognize and record relevant information to escalate Amazon RDS for MySQL issues to the AWS Support team.

Intended audience

This course is intended for:

•     Systems engineers

•     Database administrators

Prerequisites

We recommend that attendees of this course have:

•     Experience with AWS Management Console

•     Experience with AWS Command Line Interface (AWS CLI)

•     Experience with Amazon RDS for MySQL

Course outline

Section 1: Introduction

•     Lesson 1: How to Use This Course

•     Lesson 2: Overview of Amazon RDS

•     Lesson 3: Gathering Information in the AWS Management Console

•     Lesson 4: Gathering Information using the AWS CLI

Section 2: Monitoring Amazon RDS

•     Lesson 5: Monitoring Amazon RDS

•     Lesson 6: Enhanced Monitoring

•     Lesson 7: Amazon RDS Performance Insight

Section 3: Troubleshooting

•     Lesson 8: Troubleshooting Slow Queries

•     Lesson 9: Troubleshooting Role Issues

•     Lesson 10: Troubleshooting Binary Log Replication

Section 4: Conclusion

•     Lesson 11: Support

•     Lesson 12: Feedback