MySQL Forums
Forum List  »  Replication

Re: Issue with Replication using MySQL 5.7.19 on Windows 2012
Posted by: Peter Brawley
Date: June 18, 2019 03:09PM

Networks can slow down, connect_timeout could be longer.

How can you validate your configurations? I think it's not the right question.

You need to ask what's going wrong, what's getting replication stuck either at connecting or at catching up with the relay log. That comes down to trying to isolate one factor at a time.

To test relay log access or size as a cause, for example, you might, at the lowest demand time, suspend service on whatever apps depend on these dbs, run through a slave reset sequence, enable the master for just long enough to collect a couple of transactions, then lock it again and see if the slave got the one or two transactions.

In my experience, replication troubleshooting is usually like that---isolate one var at a time. It can take lots of time.

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.