Replication stopping intermittently
Hi,
I have a slave that has its replication stop working intermittently, seemingly random. It is happening around 1 or 2 times a day.
Doing a "show slave status" on the slave comes up with everything OK - Slave_IO_Running and Slave_SQL_Running are both "Yes" and the Slave_IO_State is "Waiting for master to send event". But at these times the slave is obviously behind the master, and for extended periods of time.
The only way I have found that fixes it is to do a "STOP SLAVE" and "START SLAVE". Then it catches up to the master and everything is fine.
We aren't talking about a busy database here. We are talking about maybe 100 transactions a day.
Subject
Views
Written By
Posted
Replication stopping intermittently
1951
February 18, 2014 05:35PM
624
February 23, 2014 09:40PM
967
February 24, 2014 04:35PM
758
February 25, 2014 08:12PM
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.