It's a usefull script.Thanks.
On Tue, Jun 17, 2008 at 8:26 PM, <jochen@stripped> wrote:
> 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
>>
>>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
