Day: 22 July 2019

[2XL]

Motivation:

Setup local dev environment

Learning new tools:

• docker
• docker-compose

Results for today

• docker and docker-compose installed, hello world site composed with 4 services, image:version description

1. • • nginx:latest
2. • • mysql:latest
3. • • php:latest site exposed through port 80
4. • • php:latest site exposed through port 8080

hint: (this is not a valid manifest, may require small fixes)

# docker-compose.yml
version
services
 nginx
  image: nginx
 backend:
  image: php
  port: 80
 frontend:
  image: php
  port: 8080
 database:
  image: mysql
  port: 3306

[2XL]

Additianal learning

• 1. Create a new database image based on mysql:5.6
     • the docker image should load qianli database on start:

docker-compose start database

there is a demo database dump shared through dropbox/qianli/db directory *.sql

• 2. Install mysql workbench, connect the the database instance with mysql workbench and experiment with database queries.