docker-compose.yml

services:
    app:
        container_name: cncnet_ladder_app
        restart: always
        build:
            args:
                user: ${HOST_USER}
                uid: ${HOST_UID}
                debug: 0
            context: .
            dockerfile: ./docker/Dockerfile

        env_file: ./cncnet-api/.env
        volumes:
            - ./cncnet-api:/home/${HOST_USER}/site
        networks:
            - cncnet

    nginx:
        image: nginx:stable-alpine
        container_name: cncnet_ladder_nginx
        restart: always
        ports:
            - "3000:80"
            - "443:443"
        volumes:
            - ./cncnet-api:/home/${HOST_USER}/site
            - ./docker/nginx/templates:/etc/nginx/templates/
        environment:
            NGINX_ENVSUBST_TEMPLATE_SUFFIX: ".conf"
            HOST_USER: ${HOST_USER}
        networks:
            - cncnet

    mysql:
        image: mariadb:latest
        container_name: cncnet_ladder_mysql
        restart: always
        env_file: ./cncnet-api/.env
        # https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
        command: --max_connections=1000 --max_allowed_packet=128M --log_warnings=3 --wait_timeout=31536000 --slow-query-log --interactive_timeout=31536000
        volumes:
            - cncnet-ladder-db:/var/lib/mysql
            - ./docker/mysql/init.sql:/docker-entrypoint-initdb.d/init.sql # Import latest db tables on init 
        # https://medium.com/@kauminikg/how-to-increase-max-connections-in-mysql-docker-container-772ae17e3526
        ulimits:
            nofile:
                soft: 20000
                hard: 40000
        networks:
            - cncnet

    db-backup:
        container_name: cncnet_ladder_backup
        env_file:
            - './cncnet-api/.env'
        image: tiredofit/db-backup
        volumes:
            - ./backups:/backup
        restart: always
        links:
            - mysql
        networks:
            - cncnet

networks:
    cncnet:
        driver: bridge

volumes:
    cncnet-ladder-db:
        driver: local