SQL replication periodically failing

Hi David,

I was having trouble with one of the computers going to sleep, and the results from running SHOW SLAVE STATUS would contain “Slave_SQL_Running: No”:

I changed the server setup so that they no longer sleep, and I shut down the secondary for about an hour on Friday. Did not see any problems with it when it started back up.

I left the primary server off over the weekend and I just started it back up. The replication seems to start back up, but it did not get all the items so now the history for my primary has a huge missing chunk.

I say that the replication is running based on the results of running SHOW SLAVE STATUS containing “Slave_IO_Running: Yes, Slave_SQL_Running: Yes”