MySQL Forums
Forum List  »  Replication

Re: Slave has more data than Master?
Posted by: Yang Jie
Date: February 24, 2012 04:27AM

At first, I want to tell you that I appreciate of your help so much! it is very helpful to talk with someone about this problem.

The way to solve this problem which I used: for example, the replication was crashed when the slave read binary file log_bin.00005. I will let the slave read the next log file and the starting position is 0.

code:

STOP SLAVE;
CHANGE MASTER TO MASTER_LOG_POS = 0;
CHANGE MASTER TO MASTER_LOG_FILE = 'log_bin.00006';
START SLAVE;

According to my observation after the execution of this code, there is no data lost after this recovery. So I think when the master has something wrong to write into one binary file, it will create a new log file.

Looking forward to your reply.

Options: ReplyQuote


Subject
Views
Written By
Posted
2465
February 21, 2012 06:43AM
1202
February 22, 2012 02:49AM
1259
February 22, 2012 10:23PM
1391
February 23, 2012 06:01AM
Re: Slave has more data than Master?
1049
February 24, 2012 04:27AM
1156
February 24, 2012 07:26AM
1118
March 05, 2012 04:38AM
850
March 22, 2012 05:26AM
955
March 26, 2012 02:37AM


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.