Hi everybody,
I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says "Connecting to master". The error log says:
040304 19:11:58 Slave I/O thread: error connecting to master '[EMAIL PROTECTED]
47.62:3306': Error: 'Lost connection to MySQL server during query' errno: 2013
retry-time: 60 retries: 86400
The server which is supposed to replicate fromt this server says:
"Waiting for master to send event". The log says:
040304 16:47:59 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
The third replication finally seems to work.
I did not change anything in configuration, passwords etc. It's all the same.
Something to note: The two servers able to replicate are in the same network, the one which makes trouble is in another, firewall protected network. Port 3306 is open in both firewalls and it always worked.
Does anybody have any tips? Thanks a lot (I'm really desparate)
Stefan
For simplicity, make sure all servers have the same version and start all together in sync with fresh logs. Newer versions might be confused by the old logs from the old versions.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
