check_mysql_slavestatus now works with MySQL 5.6

Written by - 0 comments

Published on January 6th 2014 - Listed in MySQL Database DB


In MySQL 5.6, the output of 'show slave status' changed and contains more information now. 

Example output from a slave running on MySQL 5.5 :

mysql> show slave status\G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.45.45
                  Master_User: replica
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: binlog.000390
          Read_Master_Log_Pos: 945435945
               Relay_Log_File: db-server-relay-bin.000442
                Relay_Log_Pos: 70120531
        Relay_Master_Log_File: binlog.000390
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
[...]

There are a total of 40 entries.

Now on MySQL 5.6 there are 53 lines, including some which have a very similar name:

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: root
                  Master_Port: 13000
                Connect_Retry: 60
              Master_Log_File: master-bin.000002
          Read_Master_Log_Pos: 1307
               Relay_Log_File: slave-relay-bin.000003
                Relay_Log_Pos: 1508
        Relay_Master_Log_File: master-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
[...]
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
[...]

Note the following two entries: Slave_SQL_Running and Slave_SQL_Running_State. Because their names are almost identical, this breaks the check_mysql_slavestatus.sh Nagios plugin, which greps for "Slave_SQL_Running" and therefore finds two results.

The newest version (20131230) fixes this issue. Thanks go to Omri Bahumi for the fix.


Add a comment

Show form to leave a comment

Comments (newest first)

No comments yet.