MySQL开启 WriteSet并行复制
2021-03-24 本文已影响0人
zr_hebo
# 从库需要执行
stop slave;
set global binlog_transaction_dependency_tracking=COMMIT_ORDER;
set global transaction_write_set_extraction=XXHASH64;
set global binlog_transaction_dependency_tracking=writeset_session;
set global slave_parallel_type='logical_clock';
set global binlog_group_commit_sync_delay=0;
set global binlog_group_commit_sync_no_delay_count=0;
set global slave_parallel_workers=8;
set global slave_preserve_commit_order=1;
# 从库需要执行
start slave;