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?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
