AWS Cloud DBA
What you’ll learn
- Migrate on-premises MySQL database to the RDS for MySQL on the AWS cloud
- Manage RDS for MySQL Multi-AZ DB Cluster
- Master AWS Command Line Interface – AWS CLI
- Learn how to create RDS DB instance by Restore from S3 Method
- Learn Cross-Account, Cross-Region RDS DB Snapshots
- Learn about RDS DB Subnet Groups, DB Parameter Groups, RDS Proxy
- Learn how to failover Multi-AZ DB instance, create RDS Read-Replica
- Master the Amazon RDS Blue/Green Deployments for databases
- Learn from real-world, hands-on practical examples
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
MySQL Community Server installation on Red Hat Enterprise Linux
GTID-based Replication Setup
AWS Virtual Private Cloud (VPC), Subnets, Security Group, IGW
AWS Command Line Interface Tool (AWS CLI)
XtraBackup
AWS S3 buckets
RDS for MySQL
DB Subnet Groups
DB Parameter Groups
Multi-AZ DB Instance & Clusters
RDS Read Replicas
RDS Automated Backups & DB Snapshots
RDS Events
RDS Proxy
Performance Insight & Enhanced Monitoring
Blue/Green Deployments
Course Content
Course Introduction
On Premises MySQL Setup
Setting Up AWS EC2 Replica
AWS S3 Setup
Creating AWS RDS for MySQL
Setting Up RDS Replica
AWS CLI MasterClass
Application Migration to RDS for MySQL
Multi-AZ RDS Setup
RDS Backup & Recovery
RDS Monitoring & Performance Tuning
Amazon RDS for MySQL Features
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
Who this course is for:
- Database Administrators looking to become Cloud Database Administrator
- AWS Cloud Administrators interested to learn about AWS RDS for MySQL
- MySQL DBAs looking to migrate their databases to AWS Cloud
- IT Professionals looking to start a new career as Cloud DBA
There are no reviews yet.