Can a specific database in TiDB (e.g., the history database) be configured to have only two replicas?

Translated
1

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

Original topic: TiDB某一库（如：history库）可以单独为这个库只设置为二副本吗？

| username: jingyesi3401

[TiDB Usage Environment] Production Environment

[TiDB Version] v5.1.0

[Problem Encountered] In the production TiDB, there are multiple databases. Currently, there is one database (e.g., the history database) that is not particularly important. Can this database be set to have only two replicas?

2
| username: BraveChen | Original post link

It seems that there is currently no official parameter specifically for setting the number of replicas for a particular database table. However, the number of TiFlash replicas can be set Cluster Management FAQ | PingCAP Docs

image
image932×295 29 KB

3
| username: ddhe9527 | Original post link

Using Placement Rules or Placement Policy can set the number of replicas for a specific database or table. If you use the former, you need to specify the table’s keyrange. However, I haven’t tried setting it to two replicas; you can test it out.

4
| username: mono | Original post link

Two copies are not as good as just one copy.

5
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.