MySQL Forums
Forum List  »  Replication

Re: My slave just sits there...
Posted by: Rick James
Date: March 10, 2013 04:36PM

> 'Waiting for master to send event' and 'Slave has read all relay log; waiting for the slave I/O thread to update it'

That is usually what you will see. It means that the replication traffic was quickly taken care of, and nothing needs to be done at the moment.

SHOW SLAVE STATUS -- no current error message? Seconds_behind_master = 0 (not NULL)? Those further confirm that all is ok.

You could create at 'heartbeat' table with just a timestamp. Insert something into it. See if it gets to the other two machines.

All 3 server_id values are different, I assume.

Options: ReplyQuote


Subject
Views
Written By
Posted
1553
March 09, 2013 06:47PM
Re: My slave just sits there...
888
March 10, 2013 04:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.