#!/bin/bash
apk add mariadb-connector-c
//more codes here
//this while loop is to check Mysql server readiness
while ! mariadb-admin ping -h"$HOST" --protocol=tcp --skip-ssl --silent; do
sleep 1
done
//then do real stuff
mysql --protocol=tcp --skip-ssl -h$HOST -u$DB_USER -p$DB_PASS < ${ROOT_DIR}/library/WWAPI/recreate-schema.sql
Why needs to check server readiness
For MariaDB/MySQL, startup can include:
- reading config
- initializing storage engine internals
- crash recovery / redo log replay
- loading grant tables / auth plugins
- opening sockets
- replication setup (if any)
Why need "--protocol=tcp --skip-ssl"
those flags force a specific connection path that is often required in CI/unit-test environments.
--protocol=tcp Forces the client to connect over TCP/IP. Without it, mysql may try a Unix socket (on Linux/macOS) when host is localhost or certain defaults apply. If your test DB is in Docker/remote host/no local socket, socket connect fails.
--skip-ssl Forces a non-TLS connection. Without it, client/server may attempt SSL/TLS negotiation (depending on defaults and server settings). If certs/SSL config are missing or incompatible in the test environment, connection can fail.