MySQL Forums
Forum List  »  Replication

Re: Group Replicaton - Lagging Slave
Posted by: Adam Nelson
Date: September 01, 2017 07:38AM

For anyone else who has the same problem ... I spent all night going through MySQL options and documentation. I was able to solve the issue by doing the following after stop all work and allowed the reader to catch up.

Increased io_write threads to 16
Increased page_cleaner to the same number of pool_instances
Set slave_preserve_commit_order to 1
Set slave_pending_jobs_size_max >= to max_allowed_packet
Set slave_parallel_workers to 5
Set slave_parallel_type to LOGICAL_CLOCK

After restarting everything the reader hasn't fallen behind (other than 5 or 10 momentarily, but cleared as fast as can be refreshed).

Options: ReplyQuote


Subject
Views
Written By
Posted
243
August 31, 2017 04:15PM
Re: Group Replicaton - Lagging Slave
211
September 01, 2017 07:38AM
166
September 01, 2017 01:46PM


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.