Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am running with one master and two slaves in a chain. ie

Master-->Primary Slave-->Secondary Slave. 

The relay log of primary slave got corrupted.

How can I recreate the relay log of primary slave without making any changes to the Primary Slave --> Secondary Slave replication?

share|improve this question
I doubt you can. – Tom O'Connor May 21 '12 at 10:01
up vote 1 down vote accepted

If it's the relay log (rather than the master bin log) which got corrupted, then

  1. STOP SLAVE (on both slaves)
  2. SHOW SLAVE STATUS on the failing machine to get the current log file and position
  3. RESET SLAVE on the faling machine
  4. CHANGE MASTER TO MASTER_LOG_FILE='filename from step 2', MASTER_LOG_POS='position from step 2'
  5. START SLAVE on both slaves
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.