# Master-Master set-up with Replication slaves and binlog woes

**URL:** <https://forums.percona.com/t/master-master-set-up-with-replication-slaves-and-binlog-woes/1268>\
**Category:** Other MySQL® Questions\
**Created:** [September 24, 2009, 7:54am UTC](https://forums.percona.com/t/master-master-set-up-with-replication-slaves-and-binlog-woes/1268 "2009-09-24T07:54:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Imran-UK](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/imran-uk/32/816_2.png) [@Imran-UK](https://forums.percona.com/u/Imran-UK)\
**Post date:** [September 24, 2009, 7:54am UTC](https://forums.percona.com/t/master-master-set-up-with-replication-slaves-and-binlog-woes/1268/1 "2009-09-24T07:54:29Z")

</div>

I want to fix a replication issue with a 2-node cluster (one active, one passive) that is using Heartbeat and a single virtual IP for failover. The nodes are in Master-Master configuration (that is, each is the slave and master of the other).

I have several other hosts that are replication slaves from the active node. They connect to MySQL via TCP over an SSH tunnels.

When failover occurs, the passive node becomes the active node.  
However the replication slaves stop replicating. The error from a log on one of the slaves is:

Jul 15 07:43:32 mysqld[1339]: 090715 7:43:32 [Note] Slave I/O  
thread: conn  
ected to master ‘@127.0.0.1:3307’, replication started in log  
‘mysql-bin.00  
0978’ at position 23923243  
Jul 15 07:43:32 mysqld[1339]: 090715 7:43:32 [ERROR] Error  
reading packet  
from server: Could not find first log file name in binary log index file ( serve  
r\_errno=1236)  
Jul 15 07:43:32 mysqld[1339]: 090715 7:43:32 [ERROR] Got fatal  
error 1236:  
‘Could not find first log file name in binary log index file’ from master when  
reading data from binary log  
Jul 15 07:43:32 mysqld[1339]: 090715 7:43:32 [Note] Slave I/O thread  
exiting, read up to log ‘mysql-bin.000978’, position 23923243

I do not think this is an SSH tunnel issue. I believe this is because of inconsistent binary log file names and positions between the two nodes. Probably because one of the nodes had been in operation a lot longer than the other.

At the moment I have to get replication going by dumping the master databases again, re-import to the slave hosts and bootstrap the slaves.

What is the best way to make this consistent and ensure that replication continues smoothly after a failover (and failback) event?

I have asked this question on the mysql-general list and was pointed to the mmm-mysql project. While that certainly looks of great interest I want to explore the possibility of a less-complex solution.

Thanks,  
Im

---

<div class="post-metadata">

**Author:** ![Imran-UK](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/imran-uk/32/816_2.png) [@Imran-UK](https://forums.percona.com/u/Imran-UK)\
**Post date:** [October 23, 2009, 1:56pm UTC](https://forums.percona.com/t/master-master-set-up-with-replication-slaves-and-binlog-woes/1268/2 "2009-10-23T13:56:29Z")

</div>

Wow, 5800+ views and no reply )

Someone at [linbit.com](http://linbit.com) proposed DRBD as a solution so I’m now going to evaluate that.

Any comments from production users of DRBD with Master-Master are most welcome.

Thanks

---

<div class="post-metadata">

**Author:** ![dizhenxiong](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@dizhenxiong](https://forums.percona.com/u/dizhenxiong)\
**Post date:** [October 24, 2009, 1:28am UTC](https://forums.percona.com/t/master-master-set-up-with-replication-slaves-and-binlog-woes/1268/3 "2009-10-24T01:28:14Z")

</div>

)