mysql 5.7 replication - slave_parallel_workers and slave_pending_jobs_size_max
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
Subject
Views
Written By
Posted
mysql 5.7 replication - slave_parallel_workers and slave_pending_jobs_size_max
2770
June 25, 2017 02:59AM
1264
September 05, 2017 11:38AM
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.