blob: 89239281b3da089fb6128a0fd4615de8baaa5c62 (
plain) (
tree)
|
|
#!/bin/bash
STATE_OK=0
STATE_WARNING=1
STATE_CRITICAL=2
STATE_UNKNOWN=3
socket=$1
config_file=$2
info=$(mysql --defaults-file=${config_file} -S $socket -e "show slave status" --vertical)
exit_code=$?
lag=$(echo "$info" | grep Seconds_Behind_Master | cut -d':' -f2 | sed -e "s/\s//g")
if [[ $exit_code -ne 0 ]]; then
echo "UNKNOWN - Impossible to run mysql command"
exit $STATE_UNKNOWN
elif [[ -z "$lag" ]]; then
echo "UNKNOWN - No replication found for mysql"
exit $STATE_UNKNOWN
else
output="Replication lag for mysql is ${lag}s"
LC_ALL=C lag=$(printf "%.*f" 0 $lag)
if [[ $lag -lt 5 ]]; then
echo "OK - $output"
exit $STATE_OK
elif [[ $lag -lt 10 ]]; then
echo "WARNING - $output"
exit $STATE_WARNING
else
echo "CRITICAL - $output"
exit $STATE_CRITICAL
fi
fi
|