From: Machiel Richards - Gmail
Date: November 12 2012 1:04pm
Subject: Assistance with replication
List-Archive: http://lists.mysql.com/mysql/228599
Message-Id: <50A0F3E8.3070508@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Guys

         We need some assistance with a master slave setup we are 
experiencing some issues with.

         We have one master with 2 slaves replicating from it.

         Both the slaves stopped working this morning in the early hours 
at exactly the same bin_log file and position.

         We have since restarted the slave servers and when you run a 
"show slave status" the seconds behind master stays "0".


         Upon closer investigation, the Relay_Master_Log_File and 
Exec_Master_Log_Pos does not change, although all other values are changing.

         No errors are being logged, and there is enough disk space on 
the server so it can't be space related.



         Can anyone suggest some things we can check or do in order to 
get replication sorted and to avoid future issues like this?


regards
Machiel