S
S
SamOwaR2013-09-25 11:57:33
MySQL
SamOwaR, 2013-09-25 11:57:33

Slave in replication does not keep up with the master if it is far behind

MySQL 5.6.13
~200 requests per second
ROW-Based

Replication when the difference in data is small, it quickly catches up with the master and then everything is fine.
If the slave is stopped for a couple of days, and then started again, then it starts to catch up for about two minutes very cheerfully (high processor load, I / O, everything is as it should be). And then it practically falls asleep - the processor load is 1%, there is little I / O, Seconds_Behind_Master decreases very slowly, stands still or even increases.

In terms of performance, the hardware of the slave is higher, the software versions are identical. There are no errors in the logs. Between gigabit servers.

Where to dig?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
SamOwaR, 2013-09-25
@SamOwaR

seems to have figured out
the problem in bcache - merged the database onto a clean SSD and everything flew off.
very strange
, %iowait remained approximately the same - 5.4
bcache may have problems with multi-threaded access, because everything in synthetics is chocolate.
in any case, the question is closed, MySQL is not to blame :)

S
stavinsky, 2013-09-25
@stavinsky

1. Check if replication is working correctly. That is, did some error SHOW SLAVE STATUS\G appear in the Last_Error variable
2. Check the age of the binary logs on the master. They might be out in 2 days.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question