推荐配置
推荐配置
# 源端
binlog_transaction_dependency_tracking = WRITESET
transaction_write_set_extraction = XXHASH64
# 从库
replica_parallel_type = LOGICAL_CLOCK
replica_parallel_workers = 8
replica_preserve_commit_order = ON| WRITESET | 按行级写集合判定事务无冲突 → 可并行 |
|---|---|
| LOGICAL_CLOCK | 同组提交事务并行重放 |
| commit order | ON 保证与源端一致的提交顺序（切换安全） |
并行度不是越大越好：受表级冲突与磁盘随机 IO 限制，压测后定值。