check_replication_status_hc.sh

#!/usr/bin/env bash

# check_replication_status_hc.sh
#
# Check MySQL 8.0 replication status and ping healthchecks.io
#
# Author: Nils Knieling - https://github.com/Cyclenerd
# Source: https://handyman.dulare.com/mysql-replication-status-alerts-with-bash-script/

# healthchecks.io UUID
MY_HC_ID=""
# Maximum number of seconds behind master
MY_MAX_SEC_BEHIND=30
# Set MySQL username and password in .my.cnf

# Check commands
command -v mysql >/dev/null 2>&1 || { echo >&2 "[ERROR] mysql it's not installed!"; exit 1; }
command -v curl  >/dev/null 2>&1 || { echo >&2 "[ERROR] curl it's not installed!"; exit 1; }

# Check MySQL replication status
if ! mysql -e 'SHOW REPLICA STATUS \G' | grep 'Running:\|Source:\|Error:' > "/tmp/mysql_replication_status_hc.txt"; then
	echo "Login failed" > "/tmp/mysql_replication_status_hc.txt"
fi

# Check parameters
MY_REPLICA_IO_RUNNING=$(grep -c "Replica_IO_Running: Yes" "/tmp/mysql_replication_status_hc.txt")
MY_REPLICA_SQL_RUNNING=$(grep -c "Replica_SQL_Running: Yes" "/tmp/mysql_replication_status_hc.txt")
MY_SECONDS_BEHIND_SOURCE=$(grep "Seconds_Behind_Source" "/tmp/mysql_replication_status_hc.txt" | tr -dc '0-9')

# Send status to healthchecks.io
if [[ $MY_REPLICA_IO_RUNNING != 1 || $MY_REPLICA_SQL_RUNNING != 1 || $MY_SECONDS_BEHIND_SOURCE -gt $MY_MAX_SEC_BEHIND ]]; then
	# Echo error to stderr
	{
		echo "ERROR:"
		cat "/tmp/mysql_replication_status_hc.txt"
		echo
		echo "Replica_IO_Running    : $MY_REPLICA_IO_RUNNING"
		echo "Replica_SQL_Running   : $MY_REPLICA_SQL_RUNNING"
		echo "Seconds_Behind_Source : $MY_SECONDS_BEHIND_SOURCE"
	} >&2
	if [ "$1" = "no-fail" ]; then
		# do not ping healthchecks.io
		exit 8
	else
		# send fail to healthchecks.io
		curl -fsS -m 10 --retry 5 -o "/dev/null" "https://hc-ping.com/$MY_HC_ID/fail"
		exit 9
	fi
else
	# echo OK to stdout
	echo "OK"
	curl -fsS -m 10 --retry 5 -o "/dev/null" "https://hc-ping.com/$MY_HC_ID"
fi