并行复制
- 社区版5.6中新增
- 并行是指从库多线程apply binlog
- 库级别并行应用binlog,同一个库数据更改还是串行的(5.7版并行复制基于事务组)
设置
set global slave_parallel_workers=10;设置sql线程数为10
步骤:
#从库
mysql> show variables like '%slave_par%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| slave_parallel_workers | 0 |#关闭状态
+------------------------+-------+
1 row in set (0.00 sec)
mysql> set global slave_parallel_workers=10;
Query OK, 0 rows affected (0.00 sec)
#查看线程,SQL线程数量并没有改变,因为没有重新启动slave
mysql> show processlist\G
*************************** 1. row ***************************
Id: 15
User: system user
Host:
db: NULL
Command: Connect
Time: 59458
State: Waiting for ma