Replication enables data from one MySQL server to be replicated
on one or more other MySQL servers. Replication is mostly used as
scale-out solution. In such a solution, all writes and updates
take place on the master server, while reads take place on one or
more slaves. This model is actually known as master-slave
replication and this is the kind of replication that I will be
setting up in this post.

The slave failed with the error that the relay binlog is corrupt.
It had copied close to 12 binlogs from the master and they were
yet to be applied. Unfortunately those binlogs have been purged
on the master. Now to sync up cleanly we might have to refresh
data from the master which can be costly since it was a 290 GB
database. We had the option of shutting down the server. We
thought we can try our luck with a crazy hack. We shutdown the
server. Tried reading the binlog using mysqlbinlog utility from
the corrupt position. It failed as expected. Then we tried
reading from the next immediate position and it went through
fine. Now we had a proof that our hack might …

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.