关闭复制
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
设置并发同步类型为逻辑时钟方式
mysql> set global slave_parallel_type=logical_clock;
Query OK, 0 rows affected (0.00 sec)
默认是datebase,每个线程只能处理一个数据库
配置成基于逻辑时钟的方式
配置并发线程数:
mysql> set global slave_parallel_workers=32;
Query OK, 0 rows affected (0.00 sec)
查看结果:
mysql> show variables like 'slave_parallel_type';
+---------------------+---------------+
| Variable_name | Value |
+---------------------+---------------+
| slave_parallel_type | LOGICAL_CLOCK |
+---------------------+---------------+
1 row in set (0.00 sec)
mysql> show variables like 'slave_parallel_workers';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| slave_parallel_workers | 32 |
+------------------------+-------+
1 row in set (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.04 sec)
mysql> show processlist;
+----+-------------+-----------+------+---------+------+