MySQL Forums
Forum List  »  Replication

Quickly Cover Slave Replication Lag
Posted by: Irfan Ahamd
Date: February 21, 2020 05:02AM

I am using master slave replication on 5.7.22 and my db size is around 700G (system specs 16-core and 150G RAM) and every 1 hour db generating 3-GB but we found slave goes around 500 behind seconds and its not cover quickly. We are reading dashboard related data from slave and in this case we are shifting traffic back to master. How we can speedup log implementation process on slave. I try to implement parallel worker but didn't find any impact.

STOP SLAVE;
SET GLOBAL slave_parallel_workers = 16;
SET GLOBAL slave_parallel_type = LOGICAL_CLOCK;
SET GLOBAL sync_binlog = 0;
SET GLOBAL innodb_flush_log_at_timeout=1800;
START SLAVE;

Options: ReplyQuote


Subject
Views
Written By
Posted
Quickly Cover Slave Replication Lag
733
February 21, 2020 05:02AM


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.