Re: Issue with Replication using MySQL 5.7.19 on Windows 2012

[Peter Brawley]

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.