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:
As far I understand these
slave_parallel_workersparameter should be only on the slave, right ?
slave_parallel_workersparameter should have? 16 as number of cores ? (I test it with 20 and I got nice performance).
Any suggestion about the slave_pending_jobs_size_max ?
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