sql2api/docker-compose.yml at master · AxiosLeo/sql2api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
# sql2api local test databases
# Usage:
#   cp .env.example .env   # optional; defaults work for local
#   docker compose up -d
#   docker compose ps

services:
  postgres:
    image: docker.m.daocloud.io/postgres:16-alpine
    container_name: sql2api-postgres
    restart: unless-stopped
    environment:
      POSTGRES_USER: ${POSTGRES_USER:-sql2api}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-sql2api_dev_pass}
      POSTGRES_DB: ${POSTGRES_DB:-sql2api}
    ports:
      - '${POSTGRES_PORT:-5432}:5432'
    volumes:
      - postgres-data:/var/lib/postgresql/data
      - ./scripts/db-init/postgres:/docker-entrypoint-initdb.d:ro
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U "$$POSTGRES_USER" -d "$$POSTGRES_DB"']
      interval: 5s
      timeout: 5s
      retries: 10

  mysql:
    image: docker.m.daocloud.io/mysql:8
    container_name: sql2api-mysql
    hostname: mysql
    command: >
      mysqld
      --authentication-policy=caching_sha2_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --innodb-buffer-pool-size=256M
      --max_connections=1000
      --bind-address=0.0.0.0
      --skip-name-resolve
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_PASS:-sql2api_dev_pass}
      MYSQL_DATABASE: ${MYSQL_DATABASE:-main_db}
      TZ: Asia/Shanghai
    restart: unless-stopped
    volumes:
      - mysql_data:/var/lib/mysql
      - ./scripts/db-init/mysql:/docker-entrypoint-initdb.d:ro
    ports:
      - '${MYSQL_PORT:-33306}:3306'
    healthcheck:
      test: ['CMD', 'mysqladmin', 'ping', '-h', 'localhost', '-uroot', '-p${MYSQL_PASS:-sql2api_dev_pass}']
      timeout: 20s
      retries: 10
      interval: 10s
      start_period: 40s

volumes:
  postgres-data:
  mysql_data: