2012/11/12 Machiel Richards - Gmail <machiel.richards@stripped>
> 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?
If seconds behind the master is at 0 it means the replication is working
fine - it's not broken (broken would show NULL)
What you can do to make sure both machines are indeed replicating all the
data arriving to the master is:
Master: show master status\G
Check File and Position field
Slave: show slave status\G
Check Exec_Master_Log_Pos and Master_Log_File
The should be the same in both, master and slaves.
Keep in mind these values will change if the master is getting writes. So
try to run the commands at the same time in the 3 servers.