MySQL Forums
Forum List  »  Replication

Re: Making the original master a slave after a crash
Posted by: Frederic Descamps
Date: August 20, 2018 04:14PM

Hi Ravi,

When you follow the procedure above, you will try to replay all events (from the beginning, they should be ignored as they have the same server_id). However to avoid such hazardous procedure, I recommend you to use GTID. Then it will be way more clear to identify which events have been replicated and you will be able to repoint to the right place automatically. (see https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html)

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Making the original master a slave after a crash
381
August 20, 2018 04:14PM


Sorry, you can't reply to this topic. It has been closed.

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.