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.

RolandoMySQLDBA
  • 182,700
  • 33
  • 317
  • 520
Nawaz Sohail
  • 1,440
  • 3
  • 10
  • 25
  • 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 Feb 19 '15 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.. – Nawaz Sohail Feb 19 '15 at 14:36

1 Answers1

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 :-(

Community
  • 1
RolandoMySQLDBA
  • 182,700
  • 33
  • 317
  • 520
  • 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. – Nawaz Sohail Feb 20 '15 at 02:09