docker-compose.yml

services:
  consul1:
    command: agent -server -bootstrap-expect 3 -ui -disable-host-node-id -client 0.0.0.0
    hostname: consul1
    image: consul:latest
    ports:
    - 8400:8400
    - 8500:8500
    - 8600:8600
  consul2:
    command: agent -server -retry-join consul1 -disable-host-node-id
    depends_on:
    - consul1
    expose:
    - "8400"
    - "8500"
    - "8600"
    hostname: consul2
    image: consul:latest
  consul3:
    command: agent -server -retry-join consul1 -disable-host-node-id
    depends_on:
    - consul1
    expose:
    - "8400"
    - "8500"
    - "8600"
    hostname: consul3
    image: consul:latest
  external_db_host:
    build:
      context: ./external_db/mysql
      dockerfile: Dockerfile
    command:
    - --server-id=1
    - --log-bin=mysql-bin
    - --gtid_mode=ON
    - --enforce_gtid_consistency
    - --general_log=1
    - --slow_query_log=1
    environment:
      MYSQL_DATABASE: ${DB:-commerce}
      MYSQL_PASSWORD: ${DB_PASS:-external_db_password}
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-pass}
      MYSQL_USER: ${DB_USER:-external_db_user}
    healthcheck:
      retries: 10
      test: /usr/bin/mysql --user=root --password=$${MYSQL_ROOT_PASSWORD} --execute
        "SHOW DATABASES;"
      timeout: 10s
    ports:
    - "3306"
    restart: always
    volumes:
    - ./external_db/mysql/:/docker-entrypoint-initdb.d/
    - ./external_db/mysql/log:/var/log/mysql
  schemaload_lookup_keyspace:
    command:
    - sh
    - -c
    - /script/schemaload.sh
    depends_on:
      vttablet301:
        condition: service_healthy
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=lookup_keyspace
    - TARGETTAB=test-0000000301
    - SLEEPTIME=15
    - VSCHEMA_FILE=lookup_keyspace_vschema.json
    - SCHEMA_FILES=lookup_keyspace_schema_file.sql
    - POST_LOAD_FILE=
    - EXTERNAL_DB=0
    image: vitess/lite:v16.0.2
    volumes:
    - .:/script
  schemaload_test_keyspace:
    command:
    - sh
    - -c
    - /script/schemaload.sh
    depends_on:
      vttablet101:
        condition: service_healthy
      vttablet201:
        condition: service_healthy
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=test_keyspace
    - TARGETTAB=test-0000000101
    - SLEEPTIME=15
    - VSCHEMA_FILE=test_keyspace_vschema.json
    - SCHEMA_FILES=test_keyspace_schema_file.sql
    - POST_LOAD_FILE=
    - EXTERNAL_DB=0
    image: vitess/lite:v16.0.2
    volumes:
    - .:/script
  set_keyspace_durability_policy:
    command:
      - sh
      - -c
      - /script/set_keyspace_durability_policy.sh
    depends_on:
      - vttablet101
      - vttablet301
    environment:
      - KEYSPACES=test_keyspace lookup_keyspace
      - GRPC_PORT=15999
    image: vitess/lite:v16.0.2
    volumes:
      - .:/script
  vreplication:
    command:
    - sh
    - -c
    - '[ $$EXTERNAL_DB -eq 1 ] && /script/externaldb_vreplication.sh || exit 0'
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - EXTERNAL_DB=0
    image: vitess/lite:v16.0.2
    volumes:
    - .:/script
  vtctld:
    command:
    - sh
    - -c
    - ' /vt/bin/vtctld --topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global --cell test
      --service_map ''grpc-vtctl,grpc-vtctld'' --backup_storage_implementation file --file_backup_storage_root
      /vt/vtdataroot/backups --logtostderr=true --port 8080 --grpc_port 15999 '
    depends_on:
      external_db_host:
        condition: service_healthy
    image: vitess/lite:v16.0.2
    ports:
    - 15000:8080
    - "15999"
    volumes:
    - .:/script
  vtgate:
    command:
    - sh
    - -c
    - '/script/run-forever.sh /vt/bin/vtgate --topo_implementation consul --topo_global_server_address
      consul1:8500 --topo_global_root vitess/global --logtostderr=true --port 8080 --grpc_port
      15999 --mysql_server_port 15306 --mysql_auth_server_impl none --cell test --cells_to_watch
      test --tablet_types_to_wait PRIMARY,REPLICA,RDONLY --service_map ''grpc-vtgateservice''
      --normalize_queries=true '
    depends_on:
    - vtctld
    image: vitess/lite:v16.0.2
    ports:
    - 15099:8080
    - "15999"
    - 15306:15306
    volumes:
    - .:/script
  vtorc:
    command:
    - sh
    - -c
    - /script/vtorc-up.sh
    depends_on:
    - vtctld
    - set_keyspace_durability_policy
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - EXTERNAL_DB=0
    - DB_USER=
    - DB_PASS=
    image: vitess/lite:v16.0.2
    ports:
    - 13000:8080
    volumes:
    - .:/script
  vttablet101:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 101
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=test_keyspace
    - SHARD=-80
    - ROLE=primary
    - VTHOST=vttablet101
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15101:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
  vttablet102:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 102
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=test_keyspace
    - SHARD=-80
    - ROLE=replica
    - VTHOST=vttablet102
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15102:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
  vttablet201:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 201
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=test_keyspace
    - SHARD=80-
    - ROLE=primary
    - VTHOST=vttablet201
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15201:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
  vttablet202:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 202
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=test_keyspace
    - SHARD=80-
    - ROLE=replica
    - VTHOST=vttablet202
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15202:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
  vttablet301:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 301
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=lookup_keyspace
    - SHARD=-
    - ROLE=primary
    - VTHOST=vttablet301
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15301:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
  vttablet302:
    command:
    - sh
    - -c
    - /script/vttablet-up.sh 302
    depends_on:
    - vtctld
    environment:
    - TOPOLOGY_FLAGS=--topo_implementation consul --topo_global_server_address consul1:8500
      --topo_global_root vitess/global
    - WEB_PORT=8080
    - GRPC_PORT=15999
    - CELL=test
    - KEYSPACE=lookup_keyspace
    - SHARD=-
    - ROLE=replica
    - VTHOST=vttablet302
    - EXTERNAL_DB=0
    - DB_PORT=
    - DB_HOST=
    - DB_USER=
    - DB_PASS=
    - DB_CHARSET=
    healthcheck:
      interval: 30s
      retries: 15
      test:
      - CMD-SHELL
      - curl -s --fail --show-error localhost:8080/debug/health
      timeout: 10s
    image: vitess/lite:v16.0.2
    ports:
    - 15302:8080
    - "15999"
    - "3306"
    volumes:
    - .:/script
version: "2.1"