features enhanced Multi-threaded slave which can be used to apply transactions in parallel even within a single database. Internal details of its working can be found in an earlier post
. In this post we will see how we can configure our replication slave to use this enhancement.
MySQL 5.7.2 has a new system variable --slave-parallel-type
which is dynamic. It can be set to the following values:1. DATABASE
: (Default) Use the db partitioned MTS (1 worker per database)2. LOGICAL_CLOCK
: Use logical clock based parallelization mode.
Apart from this the original option of --slave-parallel-workers=N
is still valid and it sets that number of workers that we need to spawn. Also since the slave [Read more...]