ALTER TABLE jianyu_subjectdb_test.pushmember SET TIFLASH REPLICA 1 > 8200 - Placement and TiFlash replica options cannot be set at the same time

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ALTER TABLE jianyu_subjectdb_test.pushmember SET TIFLASH REPLICA 1 > 8200 - Placement and tiflash replica options cannot be set at the same time

| username: xiaoxiaozuofang

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed that led to the issue
[Encountered Issue: ALTER TABLE jianyu_subjectdb_test.pushmember SET TIFLASH REPLICA 1

8200 - Placement and tiflash replica options cannot be set at the same time]
[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]

2
| username: Kongdom | Original post link

The prompt is very clear, placement and tiflash replica cannot be set at the same time.

3
| username: tidb菜鸟一只 | Original post link

In TiDB, Placement refers to the deployment strategy of TiKV and TiFlash nodes in a distributed cluster, used to specify the storage location and number of replicas of data. Typically, Placement can only be set on TiKV nodes, while TiFlash nodes automatically manage Placement.

When both Placement and TiFlash replica options are set simultaneously in TiDB, the error “Placement and tiflash replica options cannot be set at the same time” will occur. This is because TiFlash replica options are used to specify the number of replicas and distribution strategy for TiFlash nodes, and the replicas of TiFlash and Placement are different concepts that cannot be set simultaneously. If you need to set TiFlash replica options in TiDB, you should first set Placement to its default value and then set the TiFlash replica options.

It is important to note that different versions of TiDB may have different settings and limitations, so the specific operation methods and restrictions should refer to the documentation of the corresponding version.

4
| username: flow-PingCAP | Original post link

Starting from version 6.3, TiFlash replica and placement rule coexistence is supported, so you may consider upgrading to LTS 6.5.x.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.