List:General Discussion« Previous MessageNext Message »
From:Jeff Smelser Date:April 14 2005 8:15pm
Subject:Re: slave out of sync
View as plain text  
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?

Jeff

Attachment: [application/pgp-signature]
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