Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When issuing START SLAVE UNTIL on MySQL , I'm getting the following:

Warning: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart.

Why exactly is it recommended to use --skip-slave-start? What happens if the slave indeed restarts - does it only forget the UNTIL part and replicates till the end of binlog?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Does it only forget the UNTIL part and replicates till the end of binlog?

That's right.

If a previously configured slave is started without --skip-slave-start, then it will use the information stored in master.info to automatically reconnect and continue replication like normal - that is without the UNTIL clause. Which means proceeding to the end of the binlog and waiting for new binlog events.

share|improve this answer
    
Thanks, I hope there are no other hidden reasons :) –  Rafał Dowgird Jul 20 '09 at 10:11

Your Answer

 
discard

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.