MySQL Forums
Forum List  »  Replication

mysql 5.7 replication - slave_parallel_workers and slave_pending_jobs_size_max
Posted by: devops berlin
Date: June 25, 2017 02:59AM

I am using `slave_parallel_type = LOGICAL_CLOCK` and `slave_parallel_workers = 20` to achieve replication performance.

Lets say I am using `m4.4xlarge` with 16 cores and 64GB memory for the master and the slave:

1. As far I understand these`slave_parallel_type` and `slave_parallel_workers` parameter should be only on the slave, right ?

2. What value `slave_parallel_workers` parameter should have? 16 as number of cores ? (I test it with 20 and I got nice performance).

3. Any suggestion about the slave_pending_jobs_size_max ?

4. sync_binlog=1 should be on both master and slave to increase group commits and increase the potential to execute queries in parallel?


> slave_parallel_workers=20
> slave_parallel_type = LOGICAL_CLOCK
> slave_pending_jobs_size_max=1G
> sync_binlog=1
> max_allowed_packet = 256M

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 5.7 replication - slave_parallel_workers and slave_pending_jobs_size_max
2770
June 25, 2017 02:59AM


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.