There is a master and number of slaves connected to it.

Due to some patches, we have to Reboot the Master and Slave.

Afterwards, we have to make sure replication is running fine.

While doing this process, what precautions should I take so that I don't get stuck anywhere? After rebooting, I also have to validate that all the slaves are working fine.

1 Answer 1

  • Step 01) STOP SLAVE; on all Slaves

  • Step 02) service mysql stop on the Master

  • Step 03) Reboot Master

  • Step 04) For each Slave

    • Reboot each Slave
    • If /etc/my.cnf has skip-slave-start, then run START SLAVE;
  • Step 05) Check that each Slave is fully running

Run the following on the command line

SLAVETHREADCOUNT=`mysql -u... -p... -AN -e"SHOW PROCESSLIST" | grep -c "system user"`

If SLAVETHREADCOUNT is 2, replication is fully operational.

Give it a Try !!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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