docker-compose.beginners.yml

version: "2.1"
services:
  consul1:
    image: consul:latest
    hostname: "consul1"
    ports:
      - "8400:8400"
      - "8500:8500"
      - "8600:8600"
    command: "agent -server -bootstrap-expect 3 -ui -disable-host-node-id -client 0.0.0.0"
  consul2:
    image: consul:latest
    hostname: "consul2"
    expose:
      - "8400"
      - "8500"
      - "8600"
    command: "agent -server -retry-join consul1 -disable-host-node-id"
    depends_on:
      - consul1
  consul3:
    image: consul:latest
    hostname: "consul3"
    expose:
      - "8400"
      - "8500"
      - "8600"
    command: "agent -server -retry-join consul1 -disable-host-node-id"
    depends_on:
      - consul1
  # This is a convenience container to quickly test vitess against an external database.
  # In practice you will point Vitess to your existing database and migrate to a Vitess managed cluster.
  external_db_host:
    build:
      context: ./external_db/mysql
      dockerfile: Dockerfile
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-pass}
      MYSQL_DATABASE: ${DB:-commerce}
      MYSQL_USER: ${DB_USER:-external_db_user}
      MYSQL_PASSWORD: ${DB_PASS:-external_db_password}
    volumes:
      - ./external_db/mysql/:/docker-entrypoint-initdb.d/
      - ./external_db/mysql/log:/var/log/mysql
    command:
      - --server-id=1
      - --log-bin=mysql-bin
      - --gtid_mode=ON
      - --enforce_gtid_consistency
      - --general_log=1
      - --slow_query_log=1
    healthcheck:
      test: "/usr/bin/mysql --user=root --password=$${MYSQL_ROOT_PASSWORD} --execute \"SHOW DATABASES;\""
      timeout: 10s
      retries: 10
    ports:
      - "3306"

  vtctld:
    image: vitess/lite:v16.0.2
    ports:
      - "15000:$WEB_PORT"
      - "$GRPC_PORT"
    command: ["sh", "-c", " /vt/bin/vtctld \
        $TOPOLOGY_FLAGS \
        --cell $CELL \
        --service_map 'grpc-vtctl,grpc-vtctld' \
        --backup_storage_implementation file \
        --file_backup_storage_root /vt/vtdataroot/backups \
        --logtostderr=true \
        --port $WEB_PORT \
        --grpc_port $GRPC_PORT
        "]
    depends_on:
      - consul1
      - consul2
      - consul3
    depends_on:
      external_db_host:
        condition: service_healthy

  vtgate:
    image: vitess/lite:v16.0.2
    ports:
      - "15099:$WEB_PORT"
      - "$GRPC_PORT"
      - "15306:$MYSQL_PORT"
    command: ["sh", "-c", "/vt/bin/vtgate \
        $TOPOLOGY_FLAGS \
        --logtostderr=true \
        --port $WEB_PORT \
        --grpc_port $GRPC_PORT \
        --mysql_server_port $MYSQL_PORT \
        --mysql_auth_server_impl none \
        --cell $CELL \
        --cells_to_watch $CELL \
        --tablet_types_to_wait PRIMARY,REPLICA \
        --service_map 'grpc-vtgateservice' \
        --enable_system_settings=true \
        "]
    volumes:
      - ".:/script"
    environment:
      - KEYSPACE
      - DB
    depends_on:
      - vtctld
    depends_on:
      vttablet101:
        condition: service_healthy

  schemaload:
    image: vitess/lite:v16.0.2
    command:
    - sh
    - -c
    - /script/schemaload.sh
    environment:
    - TOPOLOGY_FLAGS
    - WEB_PORT
    - GRPC_PORT
    - CELL
    - KEYSPACE
    - TARGETTAB
    - SLEEPTIME
    - VSCHEMA_FILE
    - SCHEMA_FILES
    - POST_LOAD_FILE
    - EXTERNAL_DB
    volumes:
    - .:/script
    depends_on:
      vttablet101:
        condition: service_healthy

  set_keyspace_durability_policy:
    command:
      - sh
      - -c
      - /script/set_keyspace_durability_policy.sh
    depends_on:
      - vttablet100
    environment:
      - KEYSPACES=$KEYSPACE
      - GRPC_PORT=15999
    image: vitess/lite:v16.0.2
    volumes:
      - .:/script

  vttablet100:
    image: vitess/lite:v16.0.2
    ports:
      - "15100:$WEB_PORT"
      - "$GRPC_PORT"
      - "3306"
    volumes:
      - ".:/script"
      - "./backups:/vt/vtdataroot/backups"
    environment:
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
      - ROLE=primary
    command: ["sh", "-c", "[ $$EXTERNAL_DB -eq 1 ] && /script/vttablet-up.sh 100 || exit 0"]
    depends_on:
      - vtctld
    healthcheck:
      test: ["CMD-SHELL","curl -s --fail --show-error localhost:$$WEB_PORT/debug/health"]
      interval: 30s
      timeout: 10s
      retries: 15

  vttablet101:
    image: vitess/lite:v16.0.2
    ports:
      - "15101:$WEB_PORT"
      - "$GRPC_PORT"
      - "3306"
    volumes:
      - ".:/script"
      - "./backups:/vt/vtdataroot/backups"
    environment:
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
      - ROLE=primary
    command: ["sh", "-c", "/script/vttablet-up.sh 101"]
    depends_on:
      - vtctld
    healthcheck:
      test: ["CMD-SHELL","curl -s --fail --show-error localhost:$$WEB_PORT/debug/health"]
      interval: 30s
      timeout: 10s
      retries: 15

  vttablet102:
    image: vitess/lite:v16.0.2
    ports:
      - "15102:$WEB_PORT"
      - "$GRPC_PORT"
      - "3306"
    volumes:
      - ".:/script"
      - "./backups:/vt/vtdataroot/backups"
    environment:
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
    command: ["sh", "-c", "/script/vttablet-up.sh 102"]
    depends_on:
      - vtctld
      - vttablet101
    healthcheck:
      test: ["CMD-SHELL","curl -s --fail --show-error localhost:$$WEB_PORT/debug/health"]
      interval: 30s
      timeout: 10s
      retries: 15

  vttablet103:
    image: vitess/lite:v16.0.2
    ports:
      - "15103:$WEB_PORT"
      - "$GRPC_PORT"
      - "3306"
    volumes:
      - ".:/script"
      - "./backups:/vt/vtdataroot/backups"
    environment:
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
    command: ["sh", "-c", "/script/vttablet-up.sh 103"]
    depends_on:
      - vtctld
      - vttablet101
    healthcheck:
      test: ["CMD-SHELL","curl -s --fail --show-error localhost:$$WEB_PORT/debug/health"]
      interval: 30s
      timeout: 10s
      retries: 15

  vtorc:
    image: vitess/lite:v16.0.2
    command: ["sh", "-c", "/script/vtorc-up.sh"]
    depends_on:
      - vtctld
      - set_keyspace_durability_policy
    ports:
      - "13000:8080"
    volumes:
      - ".:/script"
    environment:
      - WEB_PORT=8080
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
    healthcheck:
      test: ["CMD-SHELL","curl -s --fail --show-error localhost:8080/debug/health"]
      interval: 5s
      timeout: 10s
      retries: 15

  vreplication:
    image: vitess/lite:v16.0.2
    volumes:
      - ".:/script"
    environment:
      - TOPOLOGY_FLAGS
      - WEB_PORT
      - GRPC_PORT
      - CELL
      - KEYSPACE
      - DB
      - EXTERNAL_DB
      - DB_PORT
      - DB_HOST
      - DB_USER
      - DB_PASS
      - DB_CHARSET
    command: ["sh", "-c", "[ $$EXTERNAL_DB -eq 1 ] && /script/externaldb_vreplication.sh || exit 0"]
    depends_on:
      - vtctld