Will enabling binlog in TiDB affect performance?

Translated
1

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

Original topic: tidb开启binlog之后会对性能产生影响嘛

| username: ablewang_xiaobo

Will enabling the binlog feature in the TiDB cluster affect performance?

2
| username: HACK | Original post link

I think it can be ignored.

3
| username: ddhe9527 | Original post link

There is a slight impact during the prewrite phase of COMMIT due to an additional step.

4
| username: Raymond | Original post link

It is still recommended to enable it in the production environment, as backup and recovery are very important for safety.

5
| username: cs58_dba | Original post link

This can separate the binlog and data read/write onto different disks.

6
| username: ablewang_xiaobo | Original post link

Thanks for the link, brother.

7
| username: ablewang_xiaobo | Original post link

Having binlog is relatively safe :smile:

8
| username: ablewang_xiaobo | Original post link

My pump and drainer are on separate machines, so there shouldn’t be any impact on disk performance.

9
| username: ablewang_xiaobo | Original post link

The impact is minimal and should be negligible.

10
| username: system | Original post link

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