FilesExpand file tree

main

/

docker-compose.testdb.yml

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

190 lines (180 loc) · 5.42 KB

main

/

docker-compose.testdb.yml

Copy path

Top

File metadata and controls

• Code
• Blame

190 lines (180 loc) · 5.42 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

version: '3.8'

# HowlerOps Test Database Environment

# This docker-compose file provides test databases with seed data for all supported database types.

#

# Usage:

# Start all databases: docker-compose -f docker-compose.testdb.yml up -d

# Stop all databases: docker-compose -f docker-compose.testdb.yml down

# Reset all data: docker-compose -f docker-compose.testdb.yml down -v

# View logs: docker-compose -f docker-compose.testdb.yml logs -f

#

# Each database is pre-populated with realistic test data including:

# - Users table (100+ users)

# - Products table (200+ products)

# - Orders table (500+ orders)

# - Order items (1000+ line items)

# - Audit logs (1000+ entries)

#

# Port mappings (to avoid conflicts with dev databases):

# - PostgreSQL: 5433 (internal: 5432)

# - MySQL: 3307 (internal: 3306)

# - MongoDB: 27018 (internal: 27017)

# - ElasticSearch: 9201 (internal: 9200)

# - ClickHouse: 9001 (internal: 9000), 8124 (internal: 8123)

# - Redis: 6380 (internal: 6379)

services:

# PostgreSQL Test Database

postgres-test:

image: postgres:16-alpine

container_name: howlerops-postgres-test

environment:

POSTGRES_DB: testdb

POSTGRES_USER: testuser

POSTGRES_PASSWORD: testpass

PGDATA: /var/lib/postgresql/data/pgdata

ports:

- "5433:5432"

volumes:

- postgres_test_data:/var/lib/postgresql/data

- ./scripts/seed-test-data/postgres:/docker-entrypoint-initdb.d:ro

healthcheck:

test: ["CMD-SHELL", "pg_isready -U testuser -d testdb"]

interval: 5s

timeout: 3s

retries: 10

networks:

- testdb-network

# MySQL Test Database

mysql-test:

image: mysql:8.0

container_name: howlerops-mysql-test

environment:

MYSQL_ROOT_PASSWORD: rootpass

MYSQL_DATABASE: testdb

MYSQL_USER: testuser

MYSQL_PASSWORD: testpass

ports:

- "3307:3306"

volumes:

- mysql_test_data:/var/lib/mysql

- ./scripts/seed-test-data/mysql:/docker-entrypoint-initdb.d:ro

command: --default-authentication-plugin=mysql_native_password

healthcheck:

test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "testuser", "-ptestpass"]

interval: 5s

timeout: 3s

retries: 10

networks:

- testdb-network

# MongoDB Test Database

mongodb-test:

image: mongo:7

container_name: howlerops-mongodb-test

environment:

MONGO_INITDB_ROOT_USERNAME: testuser

MONGO_INITDB_ROOT_PASSWORD: testpass

MONGO_INITDB_DATABASE: testdb

ports:

- "27018:27017"

volumes:

- mongodb_test_data:/data/db

- ./scripts/seed-test-data/mongodb:/docker-entrypoint-initdb.d:ro

healthcheck:

test: ["CMD", "mongosh", "--eval", "db.adminCommand('ping')"]

interval: 5s

timeout: 3s

retries: 10

networks:

- testdb-network

# ElasticSearch Test Database

elasticsearch-test:

image: docker.elastic.co/elasticsearch/elasticsearch:8.11.0

container_name: howlerops-elasticsearch-test

environment:

- discovery.type=single-node

- xpack.security.enabled=false

- "ES_JAVA_OPTS=-Xms512m -Xmx512m"

- bootstrap.memory_lock=true

ulimits:

memlock:

soft: -1

hard: -1

ports:

- "9201:9200"

- "9301:9300"

volumes:

- elasticsearch_test_data:/usr/share/elasticsearch/data

healthcheck:

test: ["CMD-SHELL", "curl -f http://localhost:9200/_cluster/health || exit 1"]

interval: 10s

timeout: 5s

retries: 10

networks:

- testdb-network

# ElasticSearch data seeder (runs after ES is healthy)

elasticsearch-seeder:

image: curlimages/curl:latest

container_name: howlerops-elasticsearch-seeder

depends_on:

elasticsearch-test:

condition: service_healthy

volumes:

- ./scripts/seed-test-data/elasticsearch:/scripts:ro

entrypoint: ["/bin/sh"]

command: ["/scripts/seed.sh"]

networks:

- testdb-network

# ClickHouse Test Database

clickhouse-test:

image: clickhouse/clickhouse-server:latest

container_name: howlerops-clickhouse-test

environment:

CLICKHOUSE_DB: testdb

CLICKHOUSE_USER: testuser

CLICKHOUSE_PASSWORD: testpass

CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1

ports:

- "9001:9000" # Native protocol

- "8124:8123" # HTTP interface

volumes:

- clickhouse_test_data:/var/lib/clickhouse

- ./scripts/seed-test-data/clickhouse:/docker-entrypoint-initdb.d:ro

healthcheck:

test: ["CMD", "clickhouse-client", "--query", "SELECT 1"]

interval: 5s

timeout: 3s

retries: 10

networks:

- testdb-network

# Redis Cache (often used alongside databases)

redis-test:

image: redis:7-alpine

container_name: howlerops-redis-test

ports:

- "6380:6379"

volumes:

- redis_test_data:/data

healthcheck:

test: ["CMD", "redis-cli", "ping"]

interval: 5s

timeout: 3s

retries: 5

networks:

- testdb-network

volumes:

postgres_test_data:

name: howlerops_postgres_test_data

mysql_test_data:

name: howlerops_mysql_test_data

mongodb_test_data:

name: howlerops_mongodb_test_data

elasticsearch_test_data:

name: howlerops_elasticsearch_test_data

clickhouse_test_data:

name: howlerops_clickhouse_test_data

redis_test_data:

name: howlerops_redis_test_data

networks:

testdb-network:

name: howlerops-testdb-network

driver: bridge