Prior to MySQL 5.6, the source node syncs binlogs and the replica node replays binlogs, both in the single-thread mode. MySQL 5.6 and later versions support the DATABASE/LOGICAL_CLOCK parallel replication scheme, but the granularity is too large to achieve expected parallel replication in many cases.
Tencent Cloud's TXSQL kernel team has optimized the parallel replication scheme. Table parallel replication is now supported, improving parallelism and reducing source-replica delay.
This feature is suitable for use cases where optimizing the parallelism of some loads can speed up the binlog replay at the replica node, thus reducing the source-replica delay.
For MySQL 5.6 and 5.7, you can enable this feature by setting the slave_parallel_type
parameter to the newly added value TABLE
. MySQL 8.0 does not support the TABLE mode.
Additionally, the cdb_slave_thread_status
table is added to the information_schema
database to display the thread status of the replica node.
Parameter | Effective Immediately | Type | Default Value | Valid Values/Value Range | Description |
---|---|---|---|---|---|
slave_parallel_type | Yes | char* | SCHEMA | SCHEMA/TABLE | The level of parallel replication on the replica node. |
Was this page helpful?