MySQL Forums
Forum List  »  Replication

MySQL 5.7 GR slave becomes sluggish to catchup, but after slave restart works fine
Posted by: Surinder Singh
Date: December 12, 2017 08:56AM

I have two node Group replication. After two or three days slave becomes sluggish to catch up with master. status shows online but slave kinda hangs. On restarting the slave mysql instance the slave catches up and works fine.

The doubt that arise is.

If slave can catchup after restart, why could not it catch up earlier in the first place.

My wild guess is some flow control that is trying to do some middleman job between master and slave but which is missing during slave startup and catchup. or some lock contention

system : MySQL 5.7 / RHEL 7.2

Regards
- Surinder

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 5.7 GR slave becomes sluggish to catchup, but after slave restart works fine
562
December 12, 2017 08:56AM


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.