When using TiDB as HTAP, do analytical queries need to specify a separate TiDB Server?

Translated
1

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

Original topic: TiDB作为HTAP使用，分析类的查询需要单独指定TiDB Server吗？

| username: wzf0072

To use TiDB as HTAP, in order to isolate the impact of analytical queries on the performance of transactional SQL, do analytical queries need to specify a separate TiDB Server?

【TiDB Environment】Production environment
【TiDB Version】v6.5.0
【Reproduction Path】
【Encountered Problem: Problem Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】

2
| username: 啦啦啦啦啦 | Original post link

If conditions permit, it is best to have a separate TiDB server for AP-type business.

3
| username: Jaimyjie | Original post link

It is necessary; otherwise, the analysis will consume a lot of resources and affect normal business access.

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

Having enough TiDB nodes is definitely better to separate them.

5
| username: Raymond | Original post link

If resources allow, separating the TP and AP types of TiDB servers is the best choice.

6
| username: system | Original post link

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