Autoplay
Autocomplete
Previous Lesson
Complete and Continue
AWS Cloud DBA
Course Introduction
Welcome to the course (5:01)
Course Logistics (1:45)
On Premises MySQL Setup
Section Introduction (1:37)
Project Overview (6:26)
Creating VMs (6:58)
Disabling SELINUX (6:30)
Installing MySQL on Primary & Replica (9:27)
Securing MySQL Installation (7:09)
Setting Up GTID-Based Replication (15:16)
Testing GTID-Based Replication (4:14)
Project Checkpoint (4:10)
Section Summary (0:57)
Quiz
Setting Up AWS EC2 Replica
Section Introduction (2:40)
AWS VPC & Network Stack Overview (9:58)
Creating VPC, Network Stack & EC2 (11:02)
Installing MySQL on EC2 (7:33)
Restoring Backup on EC2 (10:51)
Setting Up GTID-Based Replication on EC2 (9:31)
Section Summary (1:58)
AWS S3 Setup
Section Introduction (2:39)
Project Overview (3:49)
Installing AWS CLI Tool (7:37)
Configuring AWS CLI Tool (6:18)
Setting up S3 Bucket (9:19)
Installing XtraBackup Hot Backup Tool (6:10)
Taking Hot Backup with XtraBackup (5:53)
Copying the Hot Backup to S3 Bucket (3:01)
Section Summary (1:07)
Creating AWS RDS for MySQL
Section Introduction (1:43)
Introduction to RDS for MySQL (4:55)
RDS Terminology (8:07)
RDS Interface (15:06)
Creating IAM Role for RDS (3:34)
What is Subnet Group? (7:44)
Creating Subnet Group for RDS Instance (4:50)
Creating Security Group for RDS Instance (3:21)
What is DB Parameter Group? (10:13)
Creating DB Parameter Group for RDS Instance (4:11)
Creating RDS for MySQL Instance (9:00)
Section Summary (1:14)
Setting Up RDS Replica
Section Introduction (1:07)
RDS Interface Walkthrough (8:41)
Preparing RDS for GTID-Based Replication (7:35)
Configure RDS as Replica (8:28)
Section Summary (1:34)
AWS CLI MasterClass
Section Introduction (1:53)
Project Overview (5:13)
AWS CLI Structure (9:13)
Configuring AWS CLI Tool (3:12)
Creating & Assigning VPC & IGW (12:15)
Creating Subnets (4:35)
Creating Route Table (5:30)
Attach Subnets to Route Table (4:31)
Creating Security Group (4:49)
Creating DB Subnet Group (3:32)
Creating DB Parameter Group (2:51)
Creating IAM Role (5:45)
Restoring RDS Instance from S3 Backup (6:06)
Configuring RDS for GTID-Based Replication (8:38)
Deleting RDS Instance (3:07)
Deleting VPC & Network Stack (4:12)
Section Summary (0:59)
Application Migration to RDS for MySQL
Section Introduction (6:18)
Removing EC2 Replica (5:52)
Pointing On-Prem Replica to RDS (7:00)
Understanding Replication Filter (7:18)
Cutting Over from On-Premises to RDS (8:34)
Performing Minor MySQL Version Upgrade (9:13)
Troubleshooting Replication Error (8:59)
Performing Major MySQL Version Upgrade (7:09)
Removing On-Prem Replica (11:30)
Creating RDS Read-Only Replica (6:54)
Section Summary (2:41)
RDS for MySQL Administration
Section Introduction (4:13)
RDS Overview (6:34)
RDS Events (4:26)
RDS Certificate (5:37)
Recommendations for RDS (3:48)
Option Group for RDS (4:17)
Reserved Instance for RDS (5:07)
Zero-ETL Integrations (3:42)
Default Network (3:21)
Creating & Managing RDS Proxy (11:54)
EC2 Connection (6:28)
Section Summary (5:51)
Multi-AZ RDS Setup
Section Introduction (3:50)
Assigning Custom Parameter Group to RDS Read-Only Replica (6:52)
Performing Minor Version Upgrade on RDS Read-Only Replica (5:50)
Promoting RDS Read-Only Replica (4:15)
Converting into Multi-AZ DB Instance (5:27)
Stopping a RDS Instance Temporarily (4:43)
Deleting RDS Multi-AZ DB Instance (3:02)
Converting into Multi-AZ DB Cluster (12:07)
Rebooting Multi-AZ DB Cluster Reader (3:43)
Failing Over Multi-AZ DB Cluster (3:06)
Creating Read-Only Replica from Multi-AZ DB Cluster (7:33)
Promoting Replica to Writer & Deleting Multi-AZ DB Cluster (6:54)
Section Summary (2:28)
RDS Backup & Recovery
Section Introduction (1:48)
What is RPO & RTO (5:19)
RDS Automated Backups (10:00)
How to Perform Point-in-time Recovery (8:43)
Cross-Region Replication (10:09)
Taking Manual DB Snapshot (4:02)
Restoring DB Snapshot (4:55)
Copying DB Snapshot (3:48)
Sharing DB Snapshot (11:37)
Migrating DB Snapshot (5:23)
Upgrading DB Snapshot (4:49)
Exporting DB Snapshot to S3 (5:02)
Deleting DB Snapshot (4:13)
Introduction to AWS Backup Service (7:07)
Taking On-Demand AWS Backup (4:35)
Navigating AWS Backup Interface (5:00)
Creating AWS Backup Plan (6:25)
Dashboard, Vaults, Jobs, Restore Points ARNs (4:23)
Deleting AWS Backup Plans (4:01)
Section Summary (1:06)
RDS Monitoring & Performance Tuning
Section Introduction (4:01)
Binary Log Disk Usage (9:22)
CPU Utilization (4:04)
Database Connection Monitoring (4:18)
DB Load Monitoring (3:30)
Disk Queue Depth Monitoring (7:20)
LVM Monitoring (3:18)
Configuring the Slow Queries Log (9:21)
DB Instance Types (7:24)
Temp Table Size Optimization (5:49)
Time Zone Settings (4:14)
Sync Bin Log Parameter (8:05)
Tuning Max Connections Parameter (5:39)
Slave Parallel Workers (6:59)
Performance Insight & Enhanced Monitoring (11:07)
Section Summary (2:39)
Amazon RDS for MySQL Features
Section Introduction (2:27)
Built-in RDS Admin User - rdsadmin (6:30)
RDS Admin User - admin (5:28)
Introduction to Blue Green Deployment (3:44)
Blue Green Deployment for Standalone RDS Instance (7:07)
Blue Green Deployment for Multi-AZ DB Instance (5:53)
Blue Green Deployment - Replication Issues (3:20)
Blue Green Deployment - Fixing Replication Issues (3:17)
Blue Green Deployment - Testing (6:04)
Blue Green Deployment - Switching (4:37)
Section Summary (1:57)
Course Knowledge Test
Introduction (2:54)
Final Test
Course Wrap-Up
Thank you (0:41)
Testing GTID-Based Replication
Complete and Continue