Unable to add isolation-read.engines using tiup cluster edit-config

Translated
1

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

Original topic: 使用tiup cluster edit-config没办法添加isolation-read.engines

| username: dba-kit

I saw in the official documentation that you can add isolation-read.engines in the configuration file to set whether to enable TiFlash for tidb-server. However, when using tiup cluster edit-config to modify the configuration, it reports field isolation-read.engines not found in type spec.TiDBSpec. The specific error message is as follows:

tiup is checking updates for component cluster ...
Starting component `cluster`: /root/.tiup/components/cluster/v1.11.1/tiup-cluster edit-config dw-tidb6
New topology could not be saved: Failed to parse topology file: yaml: unmarshal errors:
  line 66: field isolation-read.engines not found in type spec.TiDBSpec
  line 99: field isolation-read.engines not found in type spec.TiDBSpec
Do you want to continue editing? [Y/n]: (default=Y) N
Nothing changed.
2
| username: WalterWj | Original post link

How did you change it? Send it over for a look.

3
| username: dba-kit | Original post link

Well, I found the problem. Unfortunately, this parameter can only be placed in the global configuration and cannot be set for a single tidb-server.

4
| username: WalterWj | Original post link

I have encountered the same problem. The solution is to add the following configuration in the TiDB configuration file:

prepared-plan-cache:
  enabled: true
  capacity: 1000
  memory-guard-ratio: 0.1

After adding this configuration, restart the TiDB service.

5
| username: WalterWj | Original post link

Sorry, I can’t translate images. Please provide the text you need translated.

6
| username: dba-kit | Original post link

The original intention was to modify the configuration of a specific tidb-server, so it was placed in tidb_servers. However, I just tried it and found that it can only be placed in server_configs.tidb.

7
| username: WalterWj | Original post link

Where did you see it? :thinking: Let me take a look.

8
| username: dba-kit | Original post link

It was found here.

9
| username: WalterWj | Original post link

Can be changed:

image
image1380×836 72.4 KB

10
| username: dba-kit | Original post link

I put it in the wrong place, I should add another config level :rofl:

11
| username: dba-kit | Original post link

Does this need to be written in list form?

12
| username: WalterWj | Original post link

Try it in the test environment. :face_with_thermometer:

13
| username: system | Original post link

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