# HG changeset patch
# User Tomas Zeman <tomas@functionals.cz>
# Date 1618493265 -7200
# Node ID a0015fe2009a1a2da479d6216a6816e541fbbf02
# Parent  1eada2e65e7a5a5f4bc964c1589ec26bb5f5a7e3
mysql-slave,status (Zabbix trapper)

diff -r 1eada2e65e7a -r a0015fe2009a scripts/mysql-slave
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/mysql-slave	Thu Apr 15 15:27:45 2021 +0200
@@ -0,0 +1,3 @@
+#!/bin/sh -e
+echo -n - mysql.slave_lagging
+mysql -ureader -Bse "show slave status\\G" | grep Seconds_Behind_Master | cut -d: -f 2
diff -r 1eada2e65e7a -r a0015fe2009a scripts/mysql-status
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/mysql-status	Thu Apr 15 15:27:45 2021 +0200
@@ -0,0 +1,2 @@
+#!/bin/sh -e
+mysqladmin -ureader status | tr ' ' '_' | sed -e 's/__/ /g' | tr -s ' ' '\012' | sed -e 's/:_/ /' | tr '[A-Z]' '[a-z]' | sed -e 's/^/- mysql./'