<Spaceelk_> hm. damn.. UserParameter=mysql[slavelog],mysql -uroot -e "show slave status;" | tail -n 1 | awk '{print $5}' | cut -f2 -d"." <- is configured on all mysql slaves..
on master i have an item like UserParameter=mysql[masterlog],mysql -uroot -e "show master status;" | tail -n 1 | awk '{ print $1 }' | cut -f2 -d"."
<Spaceelk_> i have a trigger.. ({F_hydrogen.inotronic-intern.de:mysql[masterlog].last(0)})#({F_oxygen.inotronic.de:mysql[slavelog].last(0)})
<Spaceelk_> unfortunatly mysql[slavelog] and mysql[masterlog] gets unsupported as soon as the first error occurs.
<Spaceelk_> anyone has an idea if items try to become monitored frequently if changed to unsupported? at least in this case its not working.
TO MAKE SURE ITS NOT A null PROBLEM..
mysql> stop slave;
Query OK, 0 rows affected (0.02 sec)
mysql> Bye
arsenic:/home/marc> mysql -uroot -e "show slave status;" | tail -n 1 | awk '{print $5}' | cut -f2 -d"."
002
so even if slave process is stopped the value of binlog is still present.
if not this should be fixed as soon as possible.
regards,
marc
on master i have an item like UserParameter=mysql[masterlog],mysql -uroot -e "show master status;" | tail -n 1 | awk '{ print $1 }' | cut -f2 -d"."
<Spaceelk_> i have a trigger.. ({F_hydrogen.inotronic-intern.de:mysql[masterlog].last(0)})#({F_oxygen.inotronic.de:mysql[slavelog].last(0)})
<Spaceelk_> unfortunatly mysql[slavelog] and mysql[masterlog] gets unsupported as soon as the first error occurs.
<Spaceelk_> anyone has an idea if items try to become monitored frequently if changed to unsupported? at least in this case its not working.
TO MAKE SURE ITS NOT A null PROBLEM..
mysql> stop slave;
Query OK, 0 rows affected (0.02 sec)
mysql> Bye
arsenic:/home/marc> mysql -uroot -e "show slave status;" | tail -n 1 | awk '{print $5}' | cut -f2 -d"."
002
so even if slave process is stopped the value of binlog is still present.
if not this should be fixed as soon as possible.
regards,
marc