Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: V7.1.0 tidb 安装部署时拓扑文件如何最优化
[TiDB Usage Environment] Production Environment
[TiDB Version] V7.1.0
[Encountered Problem: Phenomenon and Impact] The company plans to deploy TiDB v7.1.0 in the production environment. The specific components and hardware are shown in the figure below, with 9 physical servers. However, I am not sure what optimization options can be added to the configuration file besides the basic configuration to avoid modifying the configuration information repeatedly after successful deployment. I hope experienced experts can provide some guidance.
[Resource Configuration]
Since the configurations are related to the access characteristics of the business, the configurations of other clusters may not necessarily be suitable for your business situation. Therefore, if there are no special business requirements, you can first deploy according to the official default configuration. Specifically, you can refer to the “Deploy Standard Cluster” section in the official documentation.
After the deployment is complete, you can import business data and conduct thorough stress testing and analysis on the new cluster. At that time, you can analyze and adjust the configurations one by one based on the cluster’s performance, cluster monitoring, and encountered issues. At this stage, your business has not yet gone live, and your environment is still a test cluster without any business access, so operations such as modifying configurations and restarting the cluster will not have a significant impact, and you can proceed with confidence.
Finally, once you have adjusted to the most suitable configuration for your business scenario, you can arrange the go-live process. This process is generally indispensable when using a new database.
Most configurations can be modified in real-time. The main focus should be on those parameters or configuration items that can only be initialized during deployment. I think these are worth paying attention to.
There are basically no projects in TiDB that cannot be modified after deployment, so you can just deploy with the default parameters and adjust them later.
Okay, thank you everyone, it has been successfully deployed.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.