Header RSS Feed
 
If you only want to see the articles of a certain category, please click on the desired category below:
ALL Android Backup BSD Database Hacks Hardware Internet Linux Mail MySQL Monitoring Network Personal PHP Proxy Shell Solaris Unix Virtualization VMware Windows Wyse

check_mysql_slavestatus now works with MySQL 5.6
Monday - Jan 6th 2014 - by - (0 comments)

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.

Go to Homepage home
Linux Howtos how to's
Monitoring Plugins monitoring plugins
Links links

Valid HTML 4.01 Transitional
Valid CSS!
[Valid RSS]

7422 Days
until Death of Computers
Why?