Amazon Aurora MySQL and Amazon RDS MySQL

In this eight-course curriculum, you will learn about best practices and recommendations for using MySQL. The course provides an overview of managed MySQL through Amazon Aurora MySQL and Amazon Relational Database Service (Amazon RDS) MySQL. You will learn about detailed instructions on setting up, configuring, and managing MySQL instances, and also advanced topics such as migration, replication, and performance.

• Course level: Intermediate

• Duration: 8 hours

Activities

This curriculum includes courses with presentations, videos, and knowledge assessments.

Curriculum objectives

In this curriculum, you will learn to:

• Set up, configure, and use MySQL in Aurora and Amazon RDS

• Move data to a MySQL instance

• Manage a MySQL instance

• Understand how to handle security, monitoring, and backups of a MySQL instance

• Scale and migrate a MySQL instance

Intended audience

This curriculum is intended for:

• Database professionals

• Students

• Anyone curious about MySQL databases

Prerequisites

We recommend that attendees of this course have:

• None 

Curriculum outline

Course 1: Introduction to Amazon Aurora MySQL

• Aurora Features, Advantages, and Architecture

• Comparing Amazon RDS and Aurora

• High Availability with Aurora Global Databases

• Amazon Aurora Serverless v1

Course 2: Understanding MySQL

• Describe MySQL Architecture

• MySQL Internal Configurations

• Overview of MySQL Metadata and Data Dictionaries

Course 3: MySQL Storage Processing and Backup and Recovery

• Storage Engines and Transactions

• Backup and Recovery

• Backup Strategy with Aurora

Course 4: Managing MySQL Security and User Access

• Common Security Features

• Security Best Practices

• Creating and Managing IAM Users

Course 5: Replication and Data Assurance in MySQL

• Aurora Replication and Availability

• Increasing Availability and Access with Replication

Course 6: Migration to Aurora MySQL

• Migration Overview

• External MySQL DB Migration with Percona XtraBackup

• External MySQL DB Migration with mysqldump

• Internal Amazon RDS for MySQL Database Migration

• AWS Database Migration Service (AWS DMS)

Course 7: MySQL Performance Troubleshooting and Advanced Security Risk

• Monitoring and Performance Overview

• Monitoring Tools: DB Activity Stream

• Advanced Monitoring Tools

• Integrated and Manual Monitoring Tools

Course 8: Advanced Aurora MySQL Features

• Aurora Machine Learning

• Reserved Instances

• Aurora Cloning