composes/databases/cockroachdb.yaml at main · aleroxac/composes · 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
# syntax=docker/dockerfile:1
version: "3"


networks:
  composes:


services:
  cockroachdb:
    container_name: cockroachdb
    hostname: cockroachdb
    restart: always
    image: cockroachdb/cockroach:v23.2.14
    environment:
      COCKROACH_USER: root
      COCKROACH_PASSWORD: root
      COCKROACH_DATABASE: orders
    ports:
      - 26257:26257
      - 8080:8080
    command: start-single-node --insecure
    networks:
      - composes
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:8080/health?ready=1"]
      interval: 10s
      timeout: 5s
      retries: 5

  migrations:
    hostname: migrations
    container_name: migrations
    restart: no
    image: migrate/migrate:v4.18.1
    command: -path=/migrations -database "cockroachdb://root:root@cockroachdb:26257/orders" -verbose up
    environment:
      MYSQL_DATABASE: orders
      MYSQL_ROOT_PASSWORD: root
    volumes:
      - ./migrations/cockroachdb:/migrations
    networks:
      - composes
    depends_on:
      cockroachdb:
        condition: service_healthy

  pgadmin:
    container_name: pgadmin
    hostname: pgadmin
    restart: always
    image: dpage/pgadmin4:2024-10-19-2
    environment:
      PGADMIN_DEFAULT_EMAIL: root@domain.com
      PGADMIN_DEFAULT_PASSWORD: root
      COCKROACH_USER: root
      COCKROACH_PASSWORD: root
      COCKROACH_DATABASE: orders
    ports:
      - 8000:8000
    networks:
      - composes
    depends_on:
      cockroachdb:
        condition: service_healthy
    healthcheck:
      test: ["CMD-SHELL", "PGPASSWORD=${COCKROACH_PASSWORD} psql -U ${COCKROACH_USER} -d ${COCKROACH_DATABASE} -c 'SELECT 1;' || exit 1"]
      interval: 10s
      timeout: 5s
      retries: 5