N
N
Nastradamus2013-10-02 12:23:00
MySQL
Nastradamus, 2013-10-02 12:23:00

MySQL: a question about restoring replication on a Slave after a fatal crash of the Master. When binlogs are killed on Master

Hello!

I imagined the following situation:

What if the MySQL master server crashed so that binlog was lost after a reboot.
In this case, it is not clear how to resume the replica on the Slave.

What are the options for restoring replication without recreating the Slave from scratch?

Thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2013-10-02
@Nastradamus

Yes, actually, no, the bin log is lost.
And manually catching up with something seems to me more labor-intensive than just reloading the slave.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question