Episode #8

MySQL and PostgreSQL with Docker in Development

Published on: Oct 12, 2017 | Video length: 24 minutes

Show Notes

Learn how to setup & run MySQL & PostgreSQL databases with Docker using Docker Compose in development environment. Define container services for multiple versions of mysql and postgres in Docker Compose YAML file.

Following are the steps to walk through,

  1. Define Docker Compose YAML file for a simple MySQL container
  2. Test connecting to containerized MySQL server using MySQL Workbench on host OS
  3. Test connecting to containerized MySQL server database using another container
  4. Test connecting to containerized MySQL server database from within the container
  5. Run multiple MySQL databases of different versions as containers
  6. Configure volume mount between host OS and container to share MySQL server config file
  7. Configure volume mount between host OS and container to share the data directory
  8. Manage containerized databases using a database management web tool - adminer
  9. Run containerized PostgreSQL database along with multiple MySQL database