MySQL & PostgreSQL with Docker in development - Episode #8
Learn how to run MySQL and PostgreSQL on Docker using Docker Compose to configure the container service definitions.
Following are the steps to walk through,
Define Docker Compose YAML file for a simple MySQL container
Test connecting to containerized MySQL server using MySQL Workbench on host OS
Test connecting to containerized MySQL server database using another container
Test connecting to containerized MySQL server database from within the container
Run multiple MySQL databases of different versions as containers
Configure volume mount between host OS and container to share MySQL server config file
Configure volume mount between host OS and container to share the data directory
Manage containerized databases using a database management web tool - adminer
Run containerized PostgreSQL database along with multiple MySQL database
Find references and software/tool version details here - https://devteds.com/episodes/8-mysql-...
------------------------------------------------------------------------
Source code:
https://github.com/devteds/e8-db-on-d...
------------------------------------------------------------------------
Related episodes & courses:
Course: "Kubernetes on AWS EKS: Hands-on Get Started":
https://devteds.com/k8s
Episode: "Multi-Stage Docker Build: How to Build Production-Ready Container Image":
• Docker Multi-stage for Production-rea...
Episode: "Rails on Docker: Create and run Rails app using Docker":
• Rails on Docker: Create and run Rails...
Episode: "Create CloudFormation Stack (EC2 + RDS) & Deploy Docker App":
• Create CloudFormation Stack (EC2 + RD...
------------------------------------------------------------------------
Commands & README:
https://github.com/devteds/e8-db-on-d...
------------------------------------------------------------------------
Resources:
Download Docker - https://www.docker.com/community-edition
Docker Store - https://store.docker.com/
Docker Hub - https://hub.docker.com/explore/
MySQL Docker Image - https://store.docker.com/images/mysql
PostgreSQL Docker Image - https://store.docker.com/images/postgres
Adminer Docker Image - https://store.docker.com/images/adminer
------------------------------------------------------------------------
Softwares and tools:
Docker (Docker for Mac) - 1.13.0
Docker Compose - 1.10.0
macOS - 10.12.3
MySQL Workbench - 6.3
------------------------------------------------------------------------
Author:
Chandra Shettigar | Software Engineer & Architect | Cloud & Platform Engineering | Creator & Instructor at Devteds
https://devteds.com | / shettigarc | / shettigar
------------------------------------------------------------------------
