Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 6th May 2008, 11:50
127.0.0.1 127.0.0.1 is offline
Junior Member
 
Join Date: May 2008
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default Related: MySQL Master-Master Replication

Hello,

i have tested this tutorial: Setting Up Master-Master Replication With MySQL 5 On Debian Etch.

I build a local test environment for furter tests with my database. After my 12 day holiday I power on the machine, and nothing, the replication was crashed.

Code:
May  6 11:40:04 dev1.lan mysqld[7410]: 080506 11:40:04 [ERROR] Slave I/O thread: error connecting to master 'slave1_user@10.33.7.102:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'  errno: 2013  retry-time: 60  retries: 86400
I think this is an error related the binlog age. Im right? Can anybody confirm that?

Code:
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [Note] Slave I/O thread: connected to master 'slave2_user@10.33.7.101:3306',  replication started in log 'mysql-bin.000035' at position 98
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [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
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000035', position 98
But the BIG question is, can this occur when I use the replication on my productive systems?

127.0.0.1
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 17:07
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
mysql master master replication not working SoftDux HOWTO-Related Questions 5 29th March 2007 14:31
Mysql Master Master replication stormrider HOWTO-Related Questions 5 16th February 2007 18:18


All times are GMT +2. The time now is 12:10.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.