Hello,
check out this url:
http://www.nagiosexchange.org/cgi-bin/search.cgi?d=1&query=check_replication&Go=Go
We use the shell script plugin and it's working like a charm.
Kind Regards,
Jochen Billen
Citeren Kaushal Shriyan <kaushalshriyan@stripped>:
> Hi
>
> Is there a monitoring tool to check MySQL Slave. Just to know how much it is
> behind its Master( Seconds_Behind_Master: Variable in the below output.)
> which will send sms alerts
> or email to the user
>
> For example
>
> mysql> show slave status\G
> *************************** 1. row ***************************
> Slave_IO_State: Waiting for master to send event
> Master_Host: 192.168.0.1
> Master_User: replication
> Master_Port: 3306
> Connect_Retry: 60
> Master_Log_File: mysqld-bin.000006
> Read_Master_Log_Pos: 359455147
> Relay_Log_File: mysqld-relay-bin.000033
> Relay_Log_Pos: 236
> Relay_Master_Log_File: mysqld-bin.000006
> Slave_IO_Running: Yes
> Slave_SQL_Running: Yes
> Replicate_Do_DB:
> Replicate_Ignore_DB:
> Replicate_Do_Table:
> Replicate_Ignore_Table:
> Replicate_Wild_Do_Table:
> Replicate_Wild_Ignore_Table:
> Last_Errno: 0
> Last_Error:
> Skip_Counter: 0
> Exec_Master_Log_Pos: 359455147
> Relay_Log_Space: 236
> Until_Condition: None
> Until_Log_File:
> Until_Log_Pos: 0
> Master_SSL_Allowed: No
> Master_SSL_CA_File:
> Master_SSL_CA_Path:
> Master_SSL_Cert:
> Master_SSL_Cipher:
> Master_SSL_Key:
> Seconds_Behind_Master: 0
> 1 row in set (0.00 sec)
> mysql>
>
> Thanks and Regards
>
> Kaushal
>
