destroy_maxscale.sh - terraform-mariadb-replica-homelab - A terraform homelab with mariadb and maxscale for my own understanding and learning.

destroy_maxscale.sh (850B)

#!/bin/bash

ROOT_SRC=$1

if [[ ! -s "$ROOT_SRC/created_servers.txt" ]]; then
    echo "No created servers file found, aborting"
    exit 1
fi

MANAGED_SERVERS=$(awk '(NR==1){print $0}' $ROOT_SRC/created_servers.txt)
echo "DELETING SERVERS ${MANAGED_SERVERS} FROM maxscale.cnf"
LAST_SERVER_ID=$(echo $MANAGED_SERVERS | grep -Eo 'server[0-9]+$' | sed 's/server//')
NEXT_SERVER_ID=$(echo "$LAST_SERVER_ID + 1" | bc)
NUMBER=$(awk 'BEGIN{FS=","}{if(NR==1){print NF}}' $ROOT_SRC/created_servers.txt)

if [[ $LAST_SERVER_ID -lt 4 ]]; then
    exit 1
fi

TMP=$(mktemp)

awk -v boundary=$NEXT_SERVER_ID -v number=$NUMBER -f $ROOT_SRC/awk_scripts/destroy_maxscale.awk /etc/maxscale.cnf > $TMP
cat /etc/maxscale.cnf > /etc/maxscale.cnf.last
cat $TMP > /etc/maxscale.cnf
sed -E -i "s/,$MANAGED_SERVERS//g" /etc/maxscale.cnf

systemctl restart maxscale

rm $TMP

Back (Current repo: terraform-mariadb-replica-homelab)