|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/becoming-a-production-mysql-dba/
课程评论：没有评论
课程名称：成为一名生产环境的 MySQL DBA 课程概述：欢迎参加这门精彩的 MySQL 服务器管理课程。在本课程中，您将学习 MySQL 服务器的各个方面，包括设置、管理和故障排除。您将学习如何升级 MySQL、设置复制、迁移到 AWS 云等多项内容。 课程内容： - MySQL 服务器介绍 - 安装 MySQL 服务器社区版、MariaDB 数据库服务器和 Percona MySQL 服务器 - MySQL 服务器的架构与安装文件位置 - MySQL 用户管理与权限设置，包括创建 DBA 账户与角色 - 数据库管理与认证凭证存储 - MySQL 服务器配置与错误日志 - MySQL 备份与恢复，包括热备份和冷备份 - 在 Docker 上运行 MySQL，安装 Docker 和操作 MySQL 容器 - 云数据库管理，包括在 DigitalOcean 上创建滴水和 AWS 云复制设置 - 数据库脚本编写入门，包括 Shell 脚本的使用和实例 课程更新： - 2023 年 1 月：新增“在 Docker 上运行 MySQL”部分，包括将 MySQL 实例转换为容器的相关内容。 - 2023 年 2 月：新增“云数据库管理”和“数据库脚本编写”部分，包含多项实用的作业和工具介绍。 课程中的 DBA 面试问题也在结构中添加，且未来将继续更新内容。通过本课程，您将获得成为专业 MySQL DBA 所需的知识与技能。
**Disclaimer**For the section Running MySQL on Docker, This course requires you to download Docker Desktop If you are a Udemy Business user, please check with your employer before downloading software.**Course Overview **Welcome to this amazing course on MySQL Server Administration. You will learn all aspects of MySQL Server including setting it up, managing it, troubleshooting it. You will learn how to upgrade MySQL, how to setup replication, how to migrate to AWS cloud, and much more!** Course Contents **MySQL Server IntroductionWhy MySQL?Meet Bob, The future DBAMySQL WebsitesMySQL Server InstallationInstalling MySQL Server Community EditionInstalling MariaDB Database ServerInstalling Percona MySQL Serverinstalling Specific MySQL VersionRemoving MySQLExploring MySQL ServerMySQL ArchitectureMySQL Installed File LocationsMySQL Executable ProgramsMySQL Shell CommandsMySQL Socket FileMySQL Global & Session VariablesMySQL Remove vs Local ConnectionsMySQL User AdministrationMySQL AccountsCreating DBA Account WITH GRANT OPTIONMySQL RolesGranting Permissions to RolesGranting Roles to UsersMySQL Database AdministrationStoring Auth Credentials using mysql_config_editorMySQL Administrative Programsmysqlimport, mysqlshow, mysqlcheck utilitiesLoading Time Zone DataDownloading Example DatabasesMySQL Server ConfigurationMySQL Default Option FilesAdding Option FilesOption File InclusionsMySQL Error LogMySQL Binary Log FilesRelocating InnoDB System TablespacesMoving Redo Log FilesUpgrading MySQL ServerPerforming MySQL Minor Version UpgradePerforming MySQL Major Version UpgradeRunning Pre-Upgrade ChecksVersion Comparison Between Primary & ReplicaMySQL ReplicationPerforming Traditional Position-Based RelicationPerforming GTID ReplicationIgnoring Databases for ReplicationExcluding Tables from ReplicationMySQL Storage EnginesBLACKHOLE MEMORYINNODBCSVMySQL InnoDB Storage Engine ConfigurationInnoDB ArchitectureMemory-Based ArchitectureInnoDB Buffer PoolDedicated ServerDoublewrite BufferSystem TablespacesMySQL Backup & RestorePerforming Hot BackupPerforming Cold BackupPerforming Logical BackupsRestoring from Hot/Cold BackupsRunning MySQL on DockerInstalling Docker EnginePulling MySQL ImageRunning MySQL ContainerDBA Tips & Tricks ClubCustomizing MySQL Prompt** January 2023 - Course Update **SECTION: Running MySQL on DockerLessons Added:Converting MySQL Instance to ContainerInstalling MySQL Server on Docker HostDemo - Attach Container to Instance** Feburary 2023 - Course Update **NEW SECTION: Cloud Database AdministrationLessons Added:Cloud Database Lab SetupCreating Droplets on DigitalOceanDisabling SELINUXGTID Based Replication SetupOnline Data Duplication using xbstreamSetting up AWS Cloud ReplicaNEW SECTION: Database ScriptingLessons Added:Introduction to Shell ScriptingShell Script PermissionsBash Shell ShebangMixing Text with Shell CommandsShell Script ArgumentsShell VariablesOutput of Command as VariableFor Loop in Shell ScriptingAssignment: Create Shell Sript to Create MySQL AccountsAssignment: Create Shell Script to Download Example DatabaseAssignment: Create Shell Script to Create tables in specific databasesIntroduction to Percona ToolkitInstalling Percona Toolkitpt-mysql-summary pt-summaryCOURSE UPDATES:* DBA interview questions are added for section 2* DBA interview questions are added for section 3We will be adding more content to this course soon...
