proxysql_add_pxc_nodes.sh

#!/bin/bash

set -o errexit
set -o xtrace

function mysql_root_exec() {
	local server="$1"
	local query="$2"
	set +o xtrace
	MYSQL_PWD="${OPERATOR_PASSWORD:-operator}" timeout 600 mysql -h "${server}" -uoperator -s -NB -e "${query}"
	set -o xtrace
}

function wait_for_mysql() {
	local h="$1"
	echo "Waiting for host $h to be online..."
	while [ "$(mysql_root_exec "$h" 'select 1')" != "1" ]; do
		echo "MySQL is not up yet... sleeping ..."
		sleep 1
	done
}

function proxysql_admin_exec() {
	local server="$1"
	local query="$2"
	set +o xtrace
	MYSQL_PWD="${PROXY_ADMIN_PASSWORD:-admin}" timeout 600 mysql -h "${server}" -P6032 -u "${PROXY_ADMIN_USER:-admin}" -s -NB -e "${query}"
	set -o xtrace
}

function wait_for_proxy() {
	local h=127.0.0.1
	echo "Waiting for host $h to be online..."
	while [ "$(proxysql_admin_exec "$h" 'select 1')" != "1" ]; do
		echo "ProxySQL is not up yet... sleeping ..."
		sleep 1
	done
}

function main() {
	echo "Running $0"

	read -ra first_host
	if [ -z "$first_host" ]; then
		echo "Could not find PEERS ..."
		exit
	fi
	pod_zero=$(echo "$first_host" | cut -d . -f 1 | sed -r 's/-[0-9]+$/-0/')
	service=$(echo "$first_host" | cut -d . -f 2-)

	sleep 15s # wait for evs.inactive_timeout
	wait_for_mysql "$service"
	wait_for_proxy

	SSL_ARG=""
	if [ "$(proxysql_admin_exec "127.0.0.1" 'SELECT variable_value FROM global_variables WHERE variable_name="mysql-have_ssl"')" = "true" ]; then
		SSL_ARG="--use-ssl=yes"
	fi

	sed "s/WRITE_NODE=.*/WRITE_NODE='$pod_zero.$service:3306'/g" /etc/proxysql-admin.cnf 1<>/etc/proxysql-admin.cnf

	proxysql-admin \
		--config-file=/etc/proxysql-admin.cnf \
		--cluster-hostname="$first_host" \
		--enable \
		--update-cluster \
		--force \
		--remove-all-servers \
		--disable-updates \
		--force \
		$SSL_ARG

	proxysql-admin \
		--config-file=/etc/proxysql-admin.cnf \
		--cluster-hostname="$first_host" \
		--sync-multi-cluster-users \
		--add-query-rule \
		--disable-updates \
		--force

	proxysql-admin \
		--config-file=/etc/proxysql-admin.cnf \
		--cluster-hostname="$first_host" \
		--update-mysql-version

	echo "All done!"
}

main
exit 0