MySQL Forums
Forum List  »  Replication

Re: Replica won't connect to Master after server restart
Posted by: Peter Brawley
Date: July 20, 2022 01:16PM

So the replica was down for a time while the source kept churning. If the time is too long for replication to catch up, you won't like this but the usual remedy is a full replica restart (eg see "reset slave" at https://www.artfulsoftware.com/infotree/mysqltips.php).

Re debugging, if a 1062 error happens repeatedly with inserts on one table, on the master build a debugging stub round the insert, eg with a Trigger, that writes debugging info to another table, and track how that gets replicated.

Options: ReplyQuote




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.