I think most of the DBAs experience this error in their weekly, monthly todo list. Each one follows different approach, I would like to share some tips here:
- You should first execute “Show Slave Status;” and check the output, analyze it. Whether SQL thread has stopped or I/O thread has stopped and check respective error , It should be either SQL error or I/O error, based on that take next step.
I/O thread has stopped:
- Check that you can reach the master host from slave hostby
tracertto reach …