diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 19:58:28 -0400 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 19:58:28 -0400 |
| commit | d357ce06af74e27074132ab4f0f0ee2702c2b0d1 (patch) | |
| tree | 57e0973f902769e63e4d73b66cd3f82402405867 | |
| parent | Fix test (diff) | |
| download | cli-d357ce06af74e27074132ab4f0f0ee2702c2b0d1.zip | |
Add healthcheck for docker compose databases
| -rw-r--r-- | docker-compose.mssql.yml | 9 | ||||
| -rw-r--r-- | docker-compose.mysql.yml | 5 | ||||
| -rw-r--r-- | docker-compose.postgresql.yml | 5 |
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: |