k8s/MariaDbGaleraInitDb

Links https://docs.bitnami.com/kubernetes/infrastructure/mariadb/configuration/customize-new-instance/
Running MariaDb (mysql fork) clusters version (Galera) using helm in Kubernetes, then initializing DB.

2022 - Using the bitnami/Mariadb-galera helm chart to deploy

Using startup feature, that looks for db/scripts in "/docker-entrypoint-initdb.d/" and loads then on db creation.
Only first run, then startup leaves flag .user_scripts_initialized

dirs

export BITNAMI_VOLUME_DIR="/bitnami"
export DB_VOLUME_DIR="${BITNAMI_VOLUME_DIR}/mariadb"
export DB_DATA_DIR="${DB_VOLUME_DIR}/data"
                  #= /bitnami/mariadb/data

*.sql.gz imported with

                *.sql.gz)
                    [[ "$DB_REPLICATION_MODE" = "slave" ]] \
                    && warn "Custom SQL $1db is not supported on slave nodes, ignoring $f" && continue
                    wait_for_mysql_access "$DB_ROOT_USER"
                    # In this case, it is best to pipe the uncompressed SQL commands directly
                    # to the 'mysql' command as extraction may cause problems
                    # e.g. lack of disk space, permission issues...
                    if ! gunzip -c "$f" | mysql_execute_print_output "$DB_DATABASE" "$DB_ROOT_USER" "$DB_ROOT_PASSWORD"; then
                        error "Failed executing $f"
                        return 1
                    fi

example if initdb shell script

initdbScripts:
  my_init_script.sh: |
    #!/bin/sh
    if [[ $(hostname) == *primary* ]]; then
        echo "Primary node"
        mysql -P 3306 -uroot -prandompassword -e "create database new_database";
    else
        echo "No primary node"
    fi