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.

We have a very active (high rate of change) MySQL master / slave. After the slave was offline for a few hours (over a million binlog entries missed) the slave will not start replication again. When you look at the slave status, it shows slave IO & slave SQL running, however, the binlog position never updates.

Doing a "show processlist" on the master shows that the binlog dump starts writing to net, however, after about 1100 seconds it silently dies. However the slave still thinks that it's connected and waiting for the master to send events.

There is nothing in the master or slave error log - the master just silently stops the slave binlog dump with no error message. Doing a fresh dump from the master isn't really an option as the time to dump and restore would leave me back in the same place of being at least two hours behind the master.

Any insight into what's causing the master to silently stop the binlog dump?

share|improve this question
    
Version numbers for everything involved, please. Also, describe what's in between the two servers--routers, firewalls, load balancers, the Internet, etc. Also, a couple SHOW FULL PROCESSLISTs and SHOW MASTER STATUS\Gs/SHOW SLAVE STATUS\Gs would be helpful, in before/during/after failure states. –  BMDan Apr 12 '11 at 12:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.