Mysql on Docker : On-Premise & AWS Cloud

Explore docker fundamentals and learn how to run Mysql inside docker for on-premise deployments and AWS cloud environments.

Explore Docker, a platform for developers and sysadmins to develop, deploy, and run applications with containers. See how containers package an app with libraries and dependencies for easy portability.

Define containers as portable units that package code and dependencies into images, share a single host OS, and run consistently across on-prem and cloud with isolation for scalable workloads.

Compare containers and virtual machines to show how the Docker daemon virtualizes the operating system, enabling lightweight, shared host OS with quick startup.

Discover Docker’s origins, its Go-based architecture, shift from LXC to libcontainer, cross-platform support, cloud portability, swarm clustering, and real-world NASA DART usage.

Install mysql on docker while examining docker architecture and mastering important commands for on-premise and AWS cloud deployments.

Install docker desktop for mac from docker hub after creating a docker id. Use the command line to verify docker version and learn key docker commands for images and containers.

The lecture reveals how Docker on Mac runs a hidden Linux environment via a hypervisor, hosting the Docker daemon and enabling access with screen.

Explore Docker architecture, including the client, Docker daemon, host, containers, and images, and understand how containers originate from images via a registry like Docker Hub.

Explore how a docker registry acts as a repository for docker images, including Docker Hub as the default source. Learn how to pull from or push to private registries.

Explore the Docker engine, its daemon and REST API that let the client create and manage images and containers, enabling apps to run on-prem and in the cloud.

Explore docker images, read-only templates that form containers from layered instructions. Learn how base images are built from registries or docker hub and how changes rebuild only modified layers.

Explore how a docker container is a runnable instance of an image, offering isolation, networking, and persistent storage options, with commands to start, stop, and manage containers.

Master essential docker commands to manage mysql containers: pull images, run and start containers, list, stop, remove, kill, view logs, and build and push images.

Explore docker basics by navigating the docker hub, using official images, and pulling a hello world image to your local machine, trying commands like docker pull and docker --version.

Explore docker management commands, pulling and running images, and managing containers and images with rm, rmi, and docker run, showing hello world and ubuntu examples.

Master docker commands for managing containers, including running and killing containers, viewing the last 100 lines of logs, and pushing images to the docker hub, with exit codes for troubleshooting.

Explore the two MySQL editions on Docker—the Oracle enterprise edition and the community edition—covering licensing, official support, and the Debian versus Oracle Linux operating systems.

Pull and run the official MySQL docker image, explore community and enterprise editions from Oracle, and create and access a MySQL container with docker run and docker exec.

Learn to run MySQL on Docker using the Oracle supplied image, create and start containers, and access databases. Retrieve the generated root password from logs and change it.

Learn to run multiple MySQL versions in Docker by creating two containers, legacy (5.7) and latest (8.0), using tags and docker run with environment variables.

Connect to a MySQL container via docker exec -it and via MySQL Workbench. Publish port 3306 to host port 3309 and connect using hostname, port, and username.

Learn to create a mysql container with docker, publish ports, and map container port 3306 to the host. Connect via docker exec or mysql workbench to test the connection.

Discover how docker compose standardizes multi-container apps by defining all services in a single docker-compose.yaml file and running them together with docker compose up.

demonstrate building and running a docker-compose setup for MySQL, configuring services, environment variables, and databases, then connect to containers to verify the blog database.

Learn to build a custom Docker image from a base MySQL image using a Dockerfile, environment variables, and entrypoint scripts, then run containers with docker run or compose.

Create a custom MySQL docker image from a base image, initialize a blogs database with a blog table using starter scripts, and deploy via docker compose.

Push your custom MySQL image to Docker Hub by logging in, tagging the image with your registry, and pushing it to your repository for easy access by others.

Pull and run the custom MySQL image from Docker Hub, specifying the exact tag, start a container, and verify the blogs database and sample data inside.

Learn how MySQL on Docker handles data persistence with bind mounts, Docker-managed volumes, and tmpfs, and why volumes are the industry standard.

Learn how docker volumes provide data persistence for MySQL containers, how to create and use volumes with docker run and docker compose, and how volumes compare to bind mounts.

Create a named docker volume, run a MySQL container that uses it for data persistence, and verify the volume with docker inspect to confirm mapping.

Learn to configure docker volumes with a docker compose YAML file for MySQL, rename the service to mysql dev, add volume mappings, and verify persistence with docker inspect.

Learn to back up and restore MySQL databases inside Docker containers, using mysqldump and docker exec to move data between on-prem and cloud environments.

Demonstrates backing up a mysql database inside a docker container with mysqldump and restoring it to another container, validating databases and data through a step-by-step demo.

Learn how to run MySQL on Docker in the AWS cloud and compare it with on-premise deployments.

Explore deploying MySQL on docker in AWS, building a VPC with public and private subnets, security groups, and private subnet isolation to connect from the public subnet.

Explore AWS instance types—general purpose, compute optimized, memory optimized, accelerated computing with GPU, and storage optimized—aligned with web servers, databases, big data, and machine learning workloads.

Define and explore the virtual private cloud (VPC) as a private, logically isolated network within AWS, dedicated to your account, where you launch resources such as instances and databases.

Build a simple, hand-built VPC with a public and private subnet in one availability zone, using a network ACL, internet gateway, and routing to control traffic.

Allocate an elastic IP in the VPC, associate it with the NAT gateway to give private subnets internet access, and proceed with VPC creation and website setup.

Create a custom AWS VPC with public and private subnets, an internet gateway, and an elastic IP for internet access, then configure security groups for web and database servers.

Define and manage security groups as virtual firewalls for EC2 instances, detailing inbound and outbound rules, and use user-defined web and database server groups to control traffic.

Create a web server security group in the public subnet and a database security group in the private subnet within a VPC, with inbound port 3306 from the web server.

Launch a web server on AWS EC2 using a free-tier micro instance, configure a public subnet and IP, and set security groups for HTTP and SSH with a key pair.

Launch a second EC2 instance in a three-tier setup, install Docker and MySQL inside containers, configure a private subnet and database security group, and deploy web and database servers.

Demonstrate connectivity tests from the web server to the db server in a private subnet by using a restricted private key to connect via SSH and verify internet access.

Install and configure docker on an aws ec2 instance in a private subnet, update packages, adjust user permissions, and verify the docker engine and images for a functional back end.

Demonstrates installing Apache on Red Hat Linux, enabling Remi repo, installing PHP 7.2, starting the service, validating with a phpinfo page and a test page to verify MySQL connectivity.

Pull the MySQL image from Docker Hub, create a container with port mapping, and verify the blogs database and its tables.

Demonstrate php to mysql connectivity in a docker-hosted database, test web-server access, and extract and display query results in the browser.