database-testing/docker-compose.db.yml at main · dnprogramming/database-testing · 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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
version: '3.8'

services:
  mysql:
    image: mysql
    environment:
      MYSQL_ROOT_PASSWORD: YourStrongPassword
    ports:
      - 3306:3306

  mariadb:
    image: mariadb
    restart: always
    environment:
      MARIADB_ROOT_PASSWORD: YourStrongPassword
    ports:
      - 3307:3306

  postgres:
    image: postgres
    environment:
      POSTGRES_PASSWORD: YourStrongPassword
    ports:
      - 5432:5432

  informix:
    platform: linux/x86_64
    image: icr.io/informix/informix-developer-database
    ports:
      - 9088:9088
      - 9089:9089

  memcached:
    image: memcached
    ports:
      - 11211:11211

  mssql:
    platform: linux/x86_64
    image: mcr.microsoft.com/mssql/server:2022-latest
    ports:
      - 1433:1433
    environment:
      MSSQL_SA_PASSWORD: DevCharlie4
      ACCEPT_EULA: "Y"
    healthcheck:
      test: ["CMD-SHELL", "/opt/mssql-tools/bin/sqlcmd -S . -U sa -P DevCharlie4"]
      interval: 1s
      timeout: 5s
      retries: 120
    restart: always

  # flyway:
  #   image: flyway/flyway
  #   command: migrate -url="jdbc:sqlserver://db;databaseName=master;encrypt=false;trustServerCertificate=true" -user="sa" -password="DevCharlie4" -mixed=true -placeholders.database_user_password="Test2Alpha212!" -placeholders.asymmetric_password="Test2Alpha1234!" -placeholders.master_key_password="U#IEVx95zX7nXhKvJn6"
  #   volumes:
  #     - ./sql:/flyway/sql
  #   depends_on:
  #     db:
  #       condition: service_healthy

  mongo:
    image: mongo
    restart: always
    ports:
      - 27017:27017
    healthcheck:
      test: echo 'db.runCommand({serverStatus:1}).ok' | mongosh admin -u root -p example --quiet | grep 1
      interval: 5s
      timeout: 3s
      retries: 30
    environment:
      MONGO_INITDB_ROOT_USERNAME: root
      MONGO_INITDB_ROOT_PASSWORD: example
      MONGO_INITDB_DATABASE: encryption

  redis:
    image: redis:latest
    command: redis-server
    restart: always
    environment:
      - REDIS_REPLICATION_MODE=master
      - REDIS_DISABLE_COMMANDS=FLUSHDB,FLUSHALL,CONFIG
      - REDIS_PASSWORD=Romeo1Sierra@Zulu
      - REDIS_AOF_ENABLED=no
    volumes:
      - redis:/var/lib/redis
      - redis-config:/usr/local/etc/redis/redis.conf
    ports:
      - 6379:6379
    healthcheck:
      test: ["CMD-SHELL", "redis-cli ping | grep PONG"]
      interval: 1s
      timeout: 3s
      retries: 30

  cassandra:
    image: cassandra:latest
    container_name: cassandra
    ports:
      - 9042:9042
    environment:
      - "MAX_HEAP_SIZE=256M"
      - "HEAP_NEWSIZE=128M"
    restart: always
    volumes:
      - cassandra:/var/lib/cassandra
    healthcheck:
      test: ["CMD", "cqlsh", "-u cassandra", "-p cassandra" ,"-e describe keyspaces"]
      interval: 15s
      timeout: 10s
      retries: 10

  # cassandra-load-keyspace:
  #   container_name: cassandra-load-keyspace
  #   image: cassandra:latest
  #   depends_on:
  #     cassandra:
  #       condition: service_healthy
  #   volumes:
  #     - ./ai_data_injector/DataSchema/Cassandra_Schema.cql:/schema.cql
  #   command: /bin/bash -c "echo loading cassandra keyspace && cqlsh cassandra -f /schema.cql"