noir/compose.yaml at master · invm/noir · 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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
volumes:
  mysql:
  psql:
  maria:
  clickhouse:

services:
  mysql:
    image: mysql:9.2
    container_name: mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: password
      MYSQL_DATABASE: world # https://dev.mysql.com/doc/world-x-setup/en/world-x-setup-installation.html
    ports:
      - 3306:3306
    volumes:
      - mysql:/var/lib/mysql
      - ./dev/mysql/mysql.cnf:/etc/mysql/conf.d/mysql.cnf
      # extract in dev/mysql folder before mounting
      - ./dev/mysql/world.sql:/docker-entrypoint-initdb.d/world.sql:ro
      - ./dev/certs:/etc/ssl/mysql/certs

  psql:
    image: postgres:17-bookworm
    container_name: psql
    command: >
      -c log_statement=all
      -c ssl=on
      -c ssl_cert_file=/etc/ssl/psql/certs/server.pem
      -c ssl_key_file=/etc/ssl/psql/certs/server.key
      -c ssl_ca_file=/etc/ssl/psql/certs/ca.pem
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: password
      POSTGRES_DB: dvdrental # https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/
    volumes:
      - psql:/var/lib/postgresql/data
      - ./dev/psql/postgres.conf:/etc/postgresql/postgresql.conf
      # - ./dev/psql/pg_hba.conf:/var/lib/postgresql/data/pg_hba.conf
      # extract in dev/psql folder before mounting
      - ./dev/psql/dvdrental.tar:/tmp/dvdrental.tar
      - ./dev/psql/init.sh:/docker-entrypoint-initdb.d/init.sh
      - ./dev/certs:/etc/ssl/psql/certs
    ports:
      - 5433:5432

  maria:
    image: mariadb:11.2.2-jammy
    container_name: maria
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: password
      MYSQL_DATABASE: nation # https://www.mariadbtutorial.com/getting-started/mariadb-sample-database/
    volumes:
      - maria:/var/lib/mysql
      - ./dev/mariadb/mysql.cnf:/etc/mysql/conf.d/mysql.cnf
      # extract in dev/maria folder before mounting
      - ./dev/mariadb/nation.sql:/docker-entrypoint-initdb.d/nation.sql:ro
      - ./dev/certs:/etc/ssl/mysql/certs
    ports:
      - 3307:3306

  clickhouse:
    image: clickhouse/clickhouse-server:25.12
    container_name: clickhouse
    restart: always
    environment:
      CLICKHOUSE_USER: default
      CLICKHOUSE_PASSWORD: password
      CLICKHOUSE_DB: clickhouse_sample
      CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
    volumes:
      - clickhouse:/var/lib/clickhouse
      - ./dev/clickhouse/init.sql:/docker-entrypoint-initdb.d/init.sql:ro
    ports:
      - 8123:8123
      - 9000:9000