List:General Discussion« Previous MessageNext Message »
From:Local Date:April 15 2005 12:01am
Subject: Re: slave out of sync
View as plain text  
Jeff Smelser wrote:
> On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
> 
>>i have replication going between 2 boxes. the master crashed a few days
>>ago, and this morning i noticed that the slaves slave thread errored
>>out. the binary log and offset had changed on the master and the slave
>>couldn't sync up. i got the slave up and running again by changing the
>>log file and offset in the slave. but now i am left with out of sync
>>data. how do i get these back in sync, and how do i aviod this in the
>>future?
> 
> 
> Why wouldn't they sync up? If you left off at master-005, pos 123 (lets say). 
> It should pick up right there..
> 
> If your missing bin log files, then you need to set up the master to not 
> delete logs the slave has not processed yet. This would assure your up to 
> date, once the slave comes back alive..
> 
> Or am I missing something?

this is what i thought as well. the error i got was for the position 
offset not matching up. when i looked at the master it was at file 
bin.003 and offset of something like 123,456. the slave was still at 
file bin.001 and offset 654,321. i don't delete the bin log files. i 
thought the slave would just catch up or am i doing something wrong here?

Thread
slave out of syncChris Scheller8 Apr
  • Re: slave out of syncGleb Paharenko11 Apr
    • Re: slave out of syncLocal12 Apr
      • Re: slave out of syncGleb Paharenko12 Apr
  • Re: slave out of syncJeff Smelser14 Apr
    • Re: slave out of syncLocal15 Apr
    • Re: slave out of syncAtle Veka15 Apr
RE: slave out of syncnormandl14 Apr