X-Git-Url: https://git.immae.eu/?p=perso%2FImmae%2FConfig%2FNix.git;a=blobdiff_plain;f=modules%2Fprivate%2Fmonitoring%2Fplugins%2Fcheck_mysql_replication;fp=modules%2Fprivate%2Fmonitoring%2Fplugins%2Fcheck_mysql_replication;h=0000000000000000000000000000000000000000;hp=1ee5de1470c71da3c2eaa3fc4054a5b776f05e07;hb=1a64deeb894dc95e2645a75771732c6cc53a79ad;hpb=fa25ffd4583cc362075cd5e1b4130f33306103f0 diff --git a/modules/private/monitoring/plugins/check_mysql_replication b/modules/private/monitoring/plugins/check_mysql_replication deleted file mode 100755 index 1ee5de1..0000000 --- a/modules/private/monitoring/plugins/check_mysql_replication +++ /dev/null @@ -1,41 +0,0 @@ -#!/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 "\bSeconds_Behind_Master\b" | cut -d':' -f2 | sed -e "s/\s//g") - -IO_running=$(echo "$info" | grep "\bSlave_IO_Running\b" | cut -d':' -f2 | sed -e "s/\s//g") -SQL_running=$(echo "$info" | grep "\bSlave_SQL_Running\b" | 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 -elif [[ "$IO_running" != "Yes" || "$SQL_running" != "Yes" ]]; then - echo "UNKNOWN - Replication is not running" - 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 | time=${lag}s;5;10;;" - exit $STATE_OK - elif [[ $lag -lt 10 ]]; then - echo "WARNING - $output | time=${lag}s;5;10;;" - exit $STATE_WARNING - else - echo "CRITICAL - $output | time=${lag}s;5;10;;" - exit $STATE_CRITICAL - fi -fi