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-and-postgresql-with-docker-in-development

————————————————————————
Source code:
https://github.com/devteds/e8-db-on-docker
————————————————————————
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”:
https://youtu.be/EkOCLmvwEhc

Episode: “Rails on Docker: Create and run Rails app using Docker”:
https://youtu.be/a-jcTib9ZPA

Episode: “Create CloudFormation Stack (EC2 + RDS) & Deploy Docker App”:
https://youtu.be/8J0g_xWUzV0

————————————————————————
Commands & README:
https://github.com/devteds/e8-db-on-docker/blob/master/README.md

————————————————————————
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 | https://www.linkedin.com/in/shettigarc | https://twitter.com/shettigar

————————————————————————