MySQL Replication is a powerful tool and it’s hard to find a
production system not using it. On the other hand debugging
replication issues can be very hard and time consuming.
Especially if your replication setup is not straightforward and
you are using filtering of some kind.
Recently we got an alert from our monitoring system that replication stopped on production slave with the following error:
Can't find record in 'some_table', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log binlog.000011, end_log_pos 735766642
This means that a ROW-based replication event was going to be applied on slave, but could …[Read more...]