services:
  web:
    image: capacityrepost-web:baaea9a
    container_name: capacityrepost-web
    restart: unless-stopped
    ports:
      - "19082:9081"
    volumes:
      - capacityrepost-web-data:/data
    environment:
      TZ: Asia/Shanghai
      PYTHONUNBUFFERED: "1"
      DB_HOST: capacityrepost-mysql
      DB_PORT: "3306"
      DB_USER: root
      DB_PASSWD: gmcc123
      MAIN_DB_NAME: CapacityReport
      CELLDATA_DB_NAME: celldata
    depends_on:
      mysql:
        condition: service_healthy
    networks:
      - capacityrepost-network

  mysql:
    image: capacity-mysql:8.0.44
    container_name: capacityrepost-mysql
    restart: unless-stopped
    expose:
      - "3306"
    volumes:
      - capacityrepost-mysql-data:/var/lib/mysql
      - ./mysql/conf.d:/etc/mysql/conf.d:ro
      - ./mysql/init:/docker-entrypoint-initdb.d:ro
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: gmcc123
      MYSQL_DATABASE: CapacityReport
    command:
      - --character-set-server=utf8mb4
      - --collation-server=utf8mb4_unicode_ci
      - --local-infile=ON
      - --secure-file-priv=
      - --max_allowed_packet=256M
      - --innodb_buffer_pool_size=512M
      - --innodb_log_file_size=128M
      - --innodb_flush_log_at_trx_commit=2
      - --sync_binlog=0
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-pgmcc123"]
      interval: 10s
      timeout: 5s
      retries: 10
      start_period: 30s
    networks:
      - capacityrepost-network

networks:
  capacityrepost-network:
    name: capacityrepost-network
    driver: bridge

volumes:
  capacityrepost-web-data:
    name: capacityrepost-web-data
  capacityrepost-mysql-data:
    name: capacityrepost-mysql-data