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.
Activities
- Presentations
- Video
- Knowledge Assessments
Course objectives
- 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
- Architects
- Cloud Operators
- Data Engineers
- Developers
Recommended Skills
- None
Course outline
Course 1: Introduction to Amazon Aurora with 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
