[MDEV-13072] AliSQL: [feature] Issue #37: Support MTS distributing in table level Created: 2017-06-13  Updated: 2017-10-21

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergey Vojtovich Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Epic Link: AliSQL patches

 Description   

MySQL 5.6 introduce Multi-Threaded Slaves(MTS) which significantly improved
replicating capability of slave. However, the original MTS only support
distributing in schema level, which limits the parallelism of worker threads.
 
For example, if all updates on master is under one schema, there will be
only one worker applying events, and degenerate to signle thread replication.
 
To solve this problem, we add a new distributing level, table mode.
In the new mode, events can be distributing to different workers as long as
different tables is involed.
 
A new global option "slave_pr_mode" is introduced, which can be configured as:
1. schema, distributing in schema mode, same as origial;
2. table, distributing in table mode.
 
Note: if changed dynamically, please remember to restart SQL thread,
i.e. "stop slave sql_thread; start slave sql_thread", to make the changes
take effect.

https://github.com/alibaba/AliSQL/commit/945e59d98c280fc253dde17c42116075d8c87311


Generated at Thu Feb 08 08:02:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.