AWS Cloud DBA

AWS Cloud DBA Course Overview

Welcome to this amazing course on Cloud MySQL Database Administration. You will learn all aspects of MySQL Server including setting GTID-based Master/Slave Replication, creating EC2 MySQL replica, migrating the backup to AWS S3 bucket, creating RDS DB instance from “Restore from S3” method.

Creating & managing Multi-AZ DB instance, Multi-AZ DB cluster, RDS Read Replicas.

Managing RDS Automated Backups, Copying/Upgrading/Migrating/Exporting/Replication DB Snapshots.

Upgrading your RDS instance by leveraging Blue/Green Deployments.

Performance Tuning & Enhanced Monitoring the RDS instance

Learning about RDS for MySQL new features

All with real-world, practical exercises & examples.

Topics Covered in AWS  Cloud DBA Course

1. MySQL Community Server installation on Red Hat Enterprise Linux
2. GTID-based Replication Setup
3. AWS Virtual Private Cloud (VPC), Subnets, Security Group, IGW
4. AWS Command Line Interface Tool (AWS CLI)
5. XtraBackup
6. AWS S3 buckets
7. RDS for MySQL
8. DB Subnet Groups
9. DB Parameter Groups
10. Multi-AZ DB Instance & Clusters
11. RDS Read Replicas
12. RDS Automated Backups & DB Snapshots
13. RDS Events
14. RDS Proxy
15. Performance Insight & Enhanced Monitoring
16. Blue/Green Deployments

Course Content

1. Course Introduction
2. On Premises MySQL Setup
3. Setting Up AWS EC2 Replica
4. AWS S3 Setup
5. Creating AWS RDS for MySQL
6. Setting Up  RDS Replica
7. AWS CLI MasterClass
8. Application Migration to RDS for MySQL
9. Multi-AZ RDS Setup
10. RDS Backup & Recovery
11. RDS Monitoring & Performance Tuning
12. Amazon RDS for MySQL Features
13. Course Wrap-Up

Course Prerequisites

Basic understanding of any RDBMS, especially MySQL. It is highly recommended that prior to enrolling in this course, you should have taken Becoming a Production MySQL DBA course.

Who is this course for

• Database Administrators
• Cloud Administrators
• Junior DBAs
• MySQL Database Administrators

COURSE UPDATES:

* DBA interview questions added per section