Ad Widget

Collapse

MySQL - slave behind master

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • weite
    Junior Member
    • Oct 2007
    • 6

    #1

    MySQL - slave behind master

    Is there a way to get the status from MySQL about the time that the slave is behind the master, or something else?
    I 've some replications and would like to monitor this with zabbix.
  • jml
    Junior Member
    • Jan 2008
    • 4

    #2
    Yes there is.

    Have a look at mk-heartbeat which is a part of maatkit.
    Download Maatkit for free. Maatkit (formerly MySQL Toolkit) contains essential command-line tools for MySQL. It is now hosted at http://code.google.com/p/maatkit/ instead of Sourceforge.


    A little background information here:
    How to measure mysql slave lag accurately

    jml

    Comment

    Working...