example-db-site-hosting-docker-compose

docker-compose.yml

version: '2'
services:
  nginx:
    image: nginx:1.11.0-alpine
    ports:
      - "80:80"
    depends_on:
      - php
    volumes:
      - .:/usr/share/nginx/html
      - ./config/nginx/default.conf:/etc/nginx/conf.d/default.conf
  php:
    build: ./config/php
    depends_on:
      - sql
    volumes:
      - .:/var/www/html
      - ./config/php/php.ini:/usr/local/etc/php/php.ini
      - ./config/php/www.conf:/usr/local/etc/php-fpm.d/www.conf
    environment:
      MYSQL_TYPE: MYSQL
      MYSQL_DB_NAME: westpointrealtors
      MYSQL_DB_USERNAME: root
      MYSQL_DB_PASSWORD: root
      MYSQL_DB_HOSTNAME: sql
      MYSQL_DB_PORT: 3306
      MYSQL_DB_CHARSET: UTF8
  sql:
    build: ./config/sql
    ports:
      - "8306:3306"
    environment:
      MYSQL_DB_NAME: westpointrealtors
      MYSQL_DB_USERNAME: root
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DB_BACKUP_FILE_PATH: /var/lib/mysql
    volumes:
      - ./db:/var/lib/mysql
      - ./config/sql/backup.template:/backup.template
      - ./config/sql/docker-entrypoint.sh:/docker-entrypoint.sh
    command: /bin/sh "/docker-entrypoint.sh"