Hi<br><br>Is there a plugin to check MySQL Slave. Just to know how much it is behind its Master( Seconds_Behind_Master: Variable in the below output.)<br><br>For example<br><br>mysql> show slave status\G<br>*************************** 1. row ***************************<br>
Slave_IO_State: Waiting for master to send event<br> Master_Host: <a href="http://192.168.0.1">192.168.0.1</a><br> Master_User: replication<br> Master_Port: 3306<br>
Connect_Retry: 60<br> Master_Log_File: mysqld-bin.000006<br> Read_Master_Log_Pos: 359455147<br> Relay_Log_File: mysqld-relay-bin.000033<br> Relay_Log_Pos: 236<br> Relay_Master_Log_File: mysqld-bin.000006<br>
Slave_IO_Running: Yes<br> Slave_SQL_Running: Yes<br> Replicate_Do_DB:<br> Replicate_Ignore_DB:<br> Replicate_Do_Table:<br> Replicate_Ignore_Table:<br> Replicate_Wild_Do_Table:<br>
Replicate_Wild_Ignore_Table:<br> Last_Errno: 0<br> Last_Error:<br> Skip_Counter: 0<br> Exec_Master_Log_Pos: 359455147<br> Relay_Log_Space: 236<br> Until_Condition: None<br>
Until_Log_File:<br> Until_Log_Pos: 0<br> Master_SSL_Allowed: No<br> Master_SSL_CA_File:<br> Master_SSL_CA_Path:<br> Master_SSL_Cert:<br> Master_SSL_Cipher:<br>
Master_SSL_Key:<br> Seconds_Behind_Master: 0<br>1 row in set (0.00 sec)<br>mysql><br><br>Thanks and Regards<br><br>Kaushal<br>