在5.6基于schema的同步,需配置slave_parallel_workers参数:
mysql> show variables like '%work%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | proxy_protocol_networks | | | skip_networking | OFF | | slave_parallel_workers | 0 | +-------------------------+-------+ 3 rows in set (0.00 sec)
mysql> set global slave_parallel_workers=2
mysql> show variables like '%work%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | proxy_protocol_networks | | | skip_networking | OFF | | slave_parallel_workers | 2 | +-------------------------+-------+ 3 rows in set (0.00 sec)
尤其需要注意一点就是,开启从站基于schema的同步后,从站的事物执行记录的binlog与主站记录的日志是不同的,也就造成用从站日志恢复的问题,同时5.6并行复制,主库也必须是5.6版本,这个有而需要注意