]>
Commit | Line | Data |
---|---|---|
1 | #!/bin/bash | |
2 | ||
3 | STATE_OK=0 | |
4 | STATE_WARNING=1 | |
5 | STATE_CRITICAL=2 | |
6 | STATE_UNKNOWN=3 | |
7 | ||
8 | socket=$1 | |
9 | config_file=$2 | |
10 | info=$(mysql --defaults-file=${config_file} -S $socket -e "show slave status" --vertical) | |
11 | exit_code=$? | |
12 | ||
13 | lag=$(echo "$info" | grep "\bSeconds_Behind_Master\b" | cut -d':' -f2 | sed -e "s/\s//g") | |
14 | ||
15 | IO_running=$(echo "$info" | grep "\bSlave_IO_Running\b" | cut -d':' -f2 | sed -e "s/\s//g") | |
16 | SQL_running=$(echo "$info" | grep "\bSlave_SQL_Running\b" | cut -d':' -f2 | sed -e "s/\s//g") | |
17 | ||
18 | if [[ $exit_code -ne 0 ]]; then | |
19 | echo "UNKNOWN - Impossible to run mysql command" | |
20 | exit $STATE_UNKNOWN | |
21 | elif [[ -z "$lag" ]]; then | |
22 | echo "UNKNOWN - No replication found for mysql" | |
23 | exit $STATE_UNKNOWN | |
24 | elif [[ "$IO_running" != "Yes" || "$SQL_running" != "Yes" ]]; then | |
25 | echo "UNKNOWN - Replication is not running" | |
26 | exit $STATE_UNKNOWN | |
27 | else | |
28 | output="Replication lag for mysql is ${lag}s" | |
29 | LC_ALL=C lag=$(printf "%.*f" 0 $lag) | |
30 | ||
31 | if [[ $lag -lt 5 ]]; then | |
32 | echo "OK - $output | time=${lag}s;5;10;;" | |
33 | exit $STATE_OK | |
34 | elif [[ $lag -lt 10 ]]; then | |
35 | echo "WARNING - $output | time=${lag}s;5;10;;" | |
36 | exit $STATE_WARNING | |
37 | else | |
38 | echo "CRITICAL - $output | time=${lag}s;5;10;;" | |
39 | exit $STATE_CRITICAL | |
40 | fi | |
41 | fi |