Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 2 down vote accepted
  • 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"`
echo ${SLAVETHREADCOUNT}

If SLAVETHREADCOUNT is 2, replication is fully operational.

Give it a Try !!!

share|improve this answer

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.