- TiUP 拓扑给 A/B/C 打
perf:high、D 打perf:low,滚动重启 TiKV - PD 注册标签:
pd-ctl config set replication.location-labels '["perf"]' - SQL 创建放置策略(3 副本:2 高性能 Voter、1 低性能 Learner)并全局绑定
sql
SET GLOBAL tidb_enable_alter_placement=1;
CREATE PLACEMENT POLICY bal
FOLLOWERS=2,CONSTRAINTS='[+perf=high]',LEARNER_CONSTRAINTS='[+perf=low]';
ALTER GLOBAL SET PLACEMENT POLICY bal;
- 调低 D 存储权重:
pd-ctl store <D-store-id> weight 5