aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-03-11 19:58:28 -0400
committerEugene Triguba <eugenetriguba@gmail.com>2024-03-11 19:58:28 -0400
commitd357ce06af74e27074132ab4f0f0ee2702c2b0d1 (patch)
tree57e0973f902769e63e4d73b66cd3f82402405867
parentFix test (diff)
downloadcli-d357ce06af74e27074132ab4f0f0ee2702c2b0d1.zip
Add healthcheck for docker compose databases
-rw-r--r--docker-compose.mssql.yml9
-rw-r--r--docker-compose.mysql.yml5
-rw-r--r--docker-compose.postgresql.yml5
3 files changed, 19 insertions, 0 deletions
diff --git a/docker-compose.mssql.yml b/docker-compose.mssql.yml
index 144a00a..1dd941b 100644
--- a/docker-compose.mssql.yml
+++ b/docker-compose.mssql.yml
@@ -4,6 +4,15 @@ services:
mssql_db:
image: mcr.microsoft.com/mssql/server:2022-latest
container_name: bolt_mssql_db
+ healthcheck:
+ test:
+ [
+ "CMD-SHELL",
+ "/opt/mssql-tools/bin/sqlcmd -S ${BOLT_DB_CONN_HOST:?err} -U ${BOLT_DB_CONN_USER:?err} -P ${BOLT_DB_CONN_PASSWORD:?err} -Q 'SELECT 1'",
+ ]
+ interval: 10s
+ timeout: 5s
+ retries: 5
ports:
- "${BOLT_DB_CONN_PORT:?err}:1433"
environment:
diff --git a/docker-compose.mysql.yml b/docker-compose.mysql.yml
index e88d0f5..837fe54 100644
--- a/docker-compose.mysql.yml
+++ b/docker-compose.mysql.yml
@@ -4,6 +4,11 @@ services:
mysql_db:
image: mysql:8.3
container_name: bolt_mysql_db
+ healthcheck:
+ test: ["CMD", "mysqladmin", "ping", "-h", "${BOLT_DB_CONN_HOST:?err}"]
+ interval: 10s
+ timeout: 5s
+ retries: 5
ports:
- "${BOLT_DB_CONN_PORT:?err}:3306"
environment:
diff --git a/docker-compose.postgresql.yml b/docker-compose.postgresql.yml
index f3052fd..b2f6107 100644
--- a/docker-compose.postgresql.yml
+++ b/docker-compose.postgresql.yml
@@ -4,6 +4,11 @@ services:
postgres_db:
image: postgres:16.1-alpine3.19
container_name: bolt_postgres_db
+ healthcheck:
+ test: ["CMD-SHELL", "pg_isready -U postgres"]
+ interval: 10s
+ timeout: 5s
+ retries: 5
ports:
- "${BOLT_DB_CONN_PORT:?err}:5432"
environment: