version: "3.5"
services:
  mariadb:
    image: mariadb:latest
    container_name: ${APP_NAME}_db
    networks:
      - backend
    restart: always
    environment:
      - TZ=${TZ}
      - MYSQL_DATABASE=${MYSQL_DATABASE}
      - MYSQL_USER=${MYSQL_USER}
      - MYSQL_PASSWORD=${MYSQL_PASSWORD}
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    command:
      - "--character-set-server=utf8mb4"
      - "--collation-server=utf8mb4_unicode_ci"
      - "--max-connections=512"
      - "--innodb-buffer-pool-size=256M"
      - "--innodb-log-buffer-size=32M"
      - "--innodb-file-per-table=1"
    ports:
      - "${MYSQL_EXPOSE_PORT}:3306"
    volumes:
      - "${DB_PATH}:/var/lib/mysql"
    logging:
      driver: json-file
      options: { max-size: "200k", max-file: "1" }
  wordpress:
    image: wordpress:5-fpm
    container_name: ${APP_NAME}_website
    networks:
      - frontend
      - backend
    restart: always
    environment:
      - TZ=${TZ}
      - WORDPRESS_DB_HOST=mariadb:${MYSQL_EXPOSE_PORT}
      - WORDPRESS_DB_USER=${MYSQL_USER}
      - WORDPRESS_DB_NAME=${MYSQL_DATABASE}
      - WORDPRESS_DB_PASSWORD=${MYSQL_PASSWORD}
    volumes:
      - ${WEBSITE_STORAGE}:/var/www/html
    logging:
      driver: json-file
      options: { max-size: "200k", max-file: "1" }
  nginx:
    image: nginx:alpine
    container_name: ${APP_NAME}_nginx
    networks:
      - frontend
    restart: always
    environment:
      - TZ=${TZ}
    ports:
      - "${NGINX_EXPORT_HTTP_PORT}:80"
    volumes:
      - ./nginx/wordpress.conf:/etc/nginx/conf.d/default.conf:ro
      - ${WEBSITE_STORAGE}:/var/www/html
    logging:
      driver: json-file
      options: { max-size: "200k", max-file: "1" }

networks:
  frontend:
    name: ${APP_NAME}_frontend
  backend:
    name: ${APP_NAME}_backend

TZ=Asia/Bangkok
APP_NAME=simple-wordpress

MYSQL_USER=wp_user
MYSQL_DATABASE=wp
MYSQL_PASSWORD=wp_password
MYSQL_ROOT_PASSWORD=root_password
MYSQL_EXPOSE_PORT=3306

NGINX_EXPORT_HTTP_PORT=127.0.0.1:80

DB_PATH=./db

WEBSITE_STORAGE=./site

server {
    listen 80 default;

    root /var/www/html;
    index index.php;

    server_name localhost;

    location / {
        try_files $uri $uri/ /index.php?$args;
    }

    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass wordpress:9000;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param PATH_INFO $fastcgi_path_info;
    }
}