|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/foundation-to-mysql-database-on-docker-on-prem-aws-cloud/
课程评论：没有评论
课程名称：Mysql on Docker: On-Premise & AWS Cloud 概述： 这是一门为希望学习Docker基础知识以及在本地和AWS云上如何运作Mysql数据库的学生设计的综合课程。课程将分为三个主要部分： 1. **Docker简介**： - 从Docker的基本概念入手，解释什么是Docker以及容器的定义，比较Docker与虚拟机的异同，介绍Docker的优点和一些有趣的事实。 2. **Docker架构深入剖析与演示**： - 通过深入了解Docker架构，掌握基本术语（如Docker镜像、容器、注册中心、引擎等），以便全面理解该技术。课程将演示在MacOS上安装Docker的步骤并进行基本Docker命令的演示。 3. **在Docker上运行Mysql数据库**： - 课程将转向在Docker上运行Mysql数据库，了解Docker与Oracle提供的Mysql社区版官方镜像，演示如何安装并比较它们的差异。我们将探讨标签的重要性以及如何安装多个Mysql版本。还将展示如何通过CLI和Mysql工作台连接到容器中的Mysql数据库，并聚焦于使用Docker Compose创建容器的行业标准，演示创建自定义镜像、推送镜像到Docker Hub以及从镜像中拉取并创建新容器。课程将深入探讨Docker中的数据持久性，使用Docker卷创建Mysql数据库，并讨论Mysql数据库的备份与恢复方法。 4. **AWS云中的Docker上运行Mysql数据库**： - 基于之前的知识，将其应用于AWS云环境，创建自定义架构，包括一个虚拟私有云（VPC）及其公共子网（用于web服务器）和私有子网（用于数据库服务器）。将进行实操演示，以帮助理解安全组的创建，确保数据库服务器在私有子网中安全，外部无法直接访问，同时确保通过特定配置实现数据库服务器的互联网连接。我们还将展示如何在AWS云上构建EC2实例，其中一个用于web服务器，另一个用于数据库服务器，安装前端的PHP 7.2与Apache web服务器，以及后端的在Docker上运行的Mysql数据库。最后，将编写PHP代码以连接到AWS云中的Docker Mysql数据库，并提取和显示Mysql表中的数据。 祝学习愉快！ DB Alchemist Academy
This is a 3-in-1 course designed for the students who wish to learn the Basics of Docker , How Mysql Databases work on Docker On-Prem & AWS Cloud.Docker Introduction We shall begin with the Basics: What is Docker , What are Containers as the concept of Docker revolves around Containers. We shall then looks and compare Docker with Virtual Machines. An understanding will be given to the students about the benefits of Docker and some interesting Facts.Docker Architecture: Deep Dive & DemosMy belief is when learning a new technology it's always good to understand the Architecture and hence we shall do a deep dive into the architecture of Docker, We will understand the basic terminlogies like What is a Docker Image/Container/ Registry/Engine and this will equip us to understand the technology and get a good grasp of the subject.The demos for installation of Docker on MacOs will be done and we will also perform loads of demos to run and understand the Basic Docker Commands.Mysql Database on Docker We shall then move our focus to Mysql Databases on Docker and get an understanding around the official images for Mysql community edition that are available from Docker & Oracle. We will do demos to install these and look at differences.We shall try and understand the importance of tags and how you can install multiple versions of mysql. I will also show how you can connect mysql database in a container using CLI & Mysql workbench. We will focus on Industry standards for creating Docker containers using the Docker Compose with Demos. We will also look at practical methods of creating your own custom image / pusing that image to Docker Hub / Pulling the same image and create a new container from the image.An in-depth understanding will be given on Data Persistence in Docker and how we can create Mysql Database using Docker Volumes. As any discussion on Databases will be incomplete without Backups/Recovery hence we shall take a look at Backup/Recovery of Mysql Databases in Docker.Mysql Database on Docker in AWS CloudWe shall use the above understanding and use it in the world of AWS Cloud. For this we will work on our custom Architecture where in we will create our own VPC (Virtual Private Cloud) and this VPC will have 2 Subnets: A Public Subnet for Webserver and a Private Subnet for the Database Server (Mysql). I will do practical demos and give you good understanding on the Security Groups and how you can create Security Groups for Webserver and DB Sever, please note that as Database Server is in private Subnet no one from outside world can access it directly and only the Webserver will be able to talk to Database Server.At the same time the Database Server needs to have internet connectivity as we need to install Docker there , how this can be achieved will be mentioned as well.Some more practical demos will be done showing the students how we can build EC2 Machines in AWS Cloud , one which will be used for Webserver and other for the Database Server. We will also install PHP 7.2 along with Apache Webserver at the Front End , and for the Backend we we will have Mysql Database running inside Docker on AWS Cloud. At the end we will write a PHP Code and which will make a connection from PHP to Mysql Database on Docker in AWS Cloud and will extract and display the database from Mysql Tables.Happy LearningDB Alchemist Academy
