1

We have Master-Master Replication and it is configured correctly as it transmit data for certain period of time and after that it does not send further events till we stop/start slave on both nodes.

When I run Show Slave Status\G, it displays

  • Seconds_Behind_Master as 0
  • Slave_SQL_Running as Yes
  • Slave_IO_Running as Yes
  • server_id is also different for both nodes.

My Server Info

  • MySQL Version is 5.6.23
  • Windows Server 2012

Any help would be great.

2
  • Please add a full output of things like your my.ini, server versions, and SHOW MASTER STATUS and SHOW SLAVE STATUS of both servers before and after a write command/you observe the issue. Check also the error log for issues.
    – jynus
    Commented Feb 19, 2015 at 13:55
  • no errors in log error log as well..it does not update the position while reading for binlog when it stops reading events till issue of stop/start slave. Version and os already given in question.. Commented Feb 19, 2015 at 14:36

1 Answer 1

0

This could be one of two things

  • Slave I/O Thread is encountering Network Issues
  • Slave I/O is Playing Possum (pretending to be dead)

Derek Downey and I have written posts about the flaky behavior of the Slave's I/O Thread

According to the Bug Reports on this phenomenon, it was supposedly fixed.

See (Bug #30703 and Bug #51089)

If this bug is happening to you, someone missed a patch making MySQL 5.6.23.

I have three suggestions

As for the Network

  • Check Network For Dropped Packets
  • Check the NIC Card
  • Use separate NIC card for Replication Traffic

Other that what I have just said, sorry I don't have a silver bullet for this one :-(

1
  • seems like change master to MASTER_HEARTBEAT_PERIOD did the trick. Doesn't know why would have to use this explicitly in 5.6.23 because i have done this without using this feature in previous versions. Anyways thanks alot for your great help. Commented Feb 20, 2015 at 2:09

Your Answer

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

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