AWS Cloud DBA

Descripción

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 an EC2 MySQL replica, migrating the backup to AWS S3 bucket, and creating an RDS DB instance from the "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 of the RDS instance Learning about RDS for MySQL's 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 • Data Migration Services (AWS DMS) 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 • AWS Data Migration Services (DMS) • 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 the 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 * AWS Database Migration Services (DMS)

Lo que aprenderás

• 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

Requisitos

• Basic understanding of any Relational Database Management System (RDBMS)
• It is recommended to have already taken the course "Becoming a Professional MySQL DBA"
• No cloud experience is required, you will learn a lot about AWS cloud