I am setting up a master-master replication.
I have the masters set up correctly (I guess), and they update their position when changes occur. 'show slave status' and 'show master status' both show the correct positions between each server.
However. Although the slave position increments to match the position on the master on both servers, the data is NOT getting updated. The position continues to increment up and up, but nothing is changed.
When I had successful replication in the past, I remeber the bin-logs being transfered from the master to the slave for the updates. This is currently NOT happenning on both servers.
When I execute the 'LOAD DATA FROM MASTER' I ALWAYS get an error.
ERROR 1189: Net error reading from master
And I get the same error on both servers.Now I know the replication configuration is correct, because when changes occur on one server, the 'Read_Master_Log_Pos' changes on the second server to match the first server. However, the data is NOT getting updated.
There is no firewall between the two machines. And we are running MySQL 4.0.20
Is there a reason why the bin-logs are not being transferred?
I suspect this is the reason why the data is not getting updated.
And I suspect the error from 'LOAD DATA FROM MASTER' demonstrates the problem I am having.
What is wrong? Any help?
-RG
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
