docker-compose.yml

version: '2.1'

services:
    web:
        image: querybook-dev:latest
        cap_add:
            - SYS_PTRACE
        tmpfs: /tmp:exec,mode=777
        tty: true
        stdin_open: true
        # network_mode: "host"
        command: './querybook/scripts/bundled_docker_run_web'
        ports:
            - '${PORT-10001}:${PORT-10001}'
        expose:
            - '${PORT-10001}'
        environment:
            PORT: ${PORT-10001}
            APIPORT: ${APIPORT-3000}
            HOT_RELOAD: ${HOT_RELOAD-true}
        restart: 'always'
        volumes:
            # This is for code change via watcher
            - $PWD:/opt/querybook
            # See https://stackoverflow.com/questions/29181032/add-a-volume-to-docker-but-exclude-a-sub-folder
            - /opt/querybook/node_modules/
            # Make sure the build files don't leak back
            - /opt/querybook/dist/
            - $PWD/containers/bundled_querybook_config.yaml:/opt/querybook/querybook/config/querybook_config.yaml
            # - file:/opt/store/
        depends_on:
            mysql:
                condition: service_healthy
            redis:
                condition: service_healthy
            elasticsearch:
                condition: service_healthy
    worker:
        image: querybook-dev:latest
        cap_add:
            - SYS_PTRACE
        tmpfs: /tmp:exec,mode=777
        tty: true
        stdin_open: true
        command: './querybook/scripts/runservice worker'
        # restart: "always"
        volumes:
            # This is for code change via watcher
            - $PWD:/opt/querybook
            - $PWD/containers/bundled_querybook_config.yaml:/opt/querybook/querybook/config/querybook_config.yaml
            # - file:/opt/store/
        depends_on:
            mysql:
                condition: service_healthy
            redis:
                condition: service_healthy
            elasticsearch:
                condition: service_healthy
    scheduler:
        image: querybook-dev:latest
        cap_add:
            - SYS_PTRACE
        tmpfs: /tmp:exec,mode=777
        tty: true
        stdin_open: true
        command: './querybook/scripts/runservice scheduler --pidfile="/opt/celerybeat.pid"'
        volumes:
            # This is for code change via watcher
            - $PWD:/opt/querybook
            # See https://stackoverflow.com/questions/29181032/add-a-volume-to-docker-but-exclude-a-sub-folder
            - /opt/querybook/node_modules/
            # Make sure the build files don't leak back
            - /opt/querybook/dist/
            - $PWD/containers/bundled_querybook_config.yaml:/opt/querybook/querybook/config/querybook_config.yaml
        depends_on:
            mysql:
                condition: service_healthy
            redis:
                condition: service_healthy
    redis:
        image: redis:5.0.9
        restart: always
        command: ['redis-server', '--appendonly', 'yes']
        hostname: redis
        ports:
            - '6379:6379'
        healthcheck:
            test: ['CMD', 'redis-cli', 'ping']
            interval: 30s
            timeout: 10s
            retries: 3
    mysql:
        image: mysql:5.7
        restart: always
        ports:
            # <Port exposed> : < MySQL Port running inside container>
            - '3306:3306'
        expose:
            # Opens port 3306 on the container
            - '3306'
            # Where our data will be persisted
        volumes:
            - my-db:/var/lib/mysql
        environment:
            MYSQL_HOST: mysql:3306
            MYSQL_DATABASE: querybook2
            MYSQL_USER: test
            MYSQL_PASSWORD: passw0rd
            # Password for root access
            MYSQL_ROOT_PASSWORD: hunter2
        healthcheck:
            test:
                [
                    'CMD-SHELL',
                    "mysqladmin -h 'localhost' -u test -ppassw0rd ping --silent",
                ]
            interval: 30s
            timeout: 30s
            retries: 3
    elasticsearch:
        image: docker.elastic.co/elasticsearch/elasticsearch:6.6.1
        environment:
            cluster.name: docker-cluster
            bootstrap.memory_lock: 'true'
            ES_JAVA_OPTS: -Xms750m -Xmx750m
        ulimits:
            memlock:
                soft: -1
                hard: -1
            nofile:
                soft: 65536
                hard: 65536
        volumes:
            - esdata1:/usr/share/elasticsearch/data
        ports:
            - 9200:9200
        healthcheck:
            test:
                [
                    'CMD-SHELL',
                    'curl --silent --fail localhost:9200/_cluster/health || exit 1',
                ]
            interval: 30s
            timeout: 30s
            retries: 3
    # If you need email to work use this
    # dockerhostforward:
    #     expose:
    #         - '25'
    #     image: qoomon/docker-host
    #     cap_add: ['NET_ADMIN', 'NET_RAW']
    #     mem_limit: 8M
    #     restart: on-failure
volumes:
    my-db:
    esdata1:
        driver: local
    # file:
    #     driver: local
    #     driver_opts:
    #         type: 'none'
    #         o: 'bind'
    #         device: '/mnt/querybook-store/'