Forcing a slave to reset master connection

Posted on 2007-10-01
Last Modified: 2008-09-08
I have a replication setup that works great 99% of the time.  However occationally the master server will grind to a halt and will have to be rebooted.  (the grinding to a halt it not a problem of replications, but more some of the processes it runs).

When the master stops responding and has to be rebooted both the slaves don't seem to recongise this, or atleast it confuses them as:

looking on the slaves connections I see a system user with state of "Has read all relay log; waiting..."

also issuing a STOP SLAVE command on the slaves just causes that command to hang which then can not be killed from Mysql administrator.

Is there anyway that I can restart the repilication service on the slaves wthout having to reboot mysql (which is the only method I have found to work so far)
Question by:dealclickcouk
    1 Comment
    LVL 17

    Accepted Solution

    If STOP SLAVE & START SLAVE do not work, then I'm afraid restarting mysql on the slave is your only option. It would be interesting though to see why it is not working. The slaves should have no problem recognizing a master restart and they should continue as if nothing happened...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now