|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/aws-cloud-dba/
课程评论:没有评论
Coursera 课程: AWS Cloud DBA 本课程全面讲解了如何在AWS云环境中进行MySQL数据库管理。 **主要学习内容:** * **MySQL基础:** 在Red Hat Enterprise Linux上安装MySQL Community Server。 * **高可用性与数据复制:** * 设置基于GTID的主从复制。 * 创建EC2上的MySQL副本。 * 利用XtraBackup进行备份迁移。 * 创建RDS for MySQL实例(包括从S3恢复)。 * 创建和管理Multi-AZ数据库实例和集群。 * 创建RDS只读副本。 * **RDS管理:** * AWS VPC、子网、安全组、IGW的配置。 * 使用AWS CLI工具。 * RDS数据库子网组和参数组的管理。 * RDS自动备份和数据库快照的管理(复制、升级、迁移、导出)。 * 配置RDS事件通知。 * 使用RDS Proxy。 * **性能优化与监控:** * RDS实例的性能调优。 * 使用Performance Insight和增强型监控。 * 了解RDS for MySQL的新特性。 * **迁移与部署:** * 将应用程序迁移到RDS for MySQL。 * 利用蓝绿部署升级RDS实例。 **课程特色:** * 包含真实世界的实践练习和示例。 * 涵盖了从基础安装到高级管理的各个方面。 * 增加了DBA面试问题。 **先修知识:** * 对任一关系型数据库(RDBMS)有基本了解,特别是MySQL。 * 强烈建议先完成“Becoming a Production MySQL DBA”课程。 **适合人群:** * 数据库管理员(DBA) * 云管理员 * 初级DBA * MySQL数据库管理员
AWS Cloud DBA Course OverviewWelcome 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 instanceLearning about RDS for MySQL new featuresAll with real-world, practical exercises & examples.Topics Covered in AWS Cloud DBA CourseMySQL Community Server installation on Red Hat Enterprise Linux GTID-based Replication SetupAWS Virtual Private Cloud (VPC), Subnets, Security Group, IGWAWS Command Line Interface Tool (AWS CLI)XtraBackupAWS S3 bucketsRDS for MySQLDB Subnet GroupsDB Parameter Groups Multi-AZ DB Instance & ClustersRDS Read ReplicasRDS Automated Backups & DB SnapshotsRDS EventsRDS ProxyPerformance Insight & Enhanced MonitoringBlue/Green DeploymentsCourse ContentCourse IntroductionOn Premises MySQL Setup Setting Up AWS EC2 ReplicaAWS S3 SetupCreating AWS RDS for MySQLSetting Up RDS ReplicaAWS CLI MasterClassApplication Migration to RDS for MySQLMulti-AZ RDS SetupRDS Backup & RecoveryRDS Monitoring & Performance TuningAmazon RDS for MySQL FeaturesCourse Wrap-UpCourse 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 forDatabase AdministratorsCloud AdministratorsJunior DBAsMySQL Database AdministratorsCOURSE UPDATES:* DBA interview questions added per section