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;

上一篇 下一篇

猜你喜欢

热点阅读