What are the drawbacks of using TiDB and how to avoid them?

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

Original topic: tidb使用过程中有什么弊端,需要避坑的

| username: swino

What are the drawbacks of using TiDB, and what pitfalls should be avoided?

| username: Jellybean | Original post link

TiDB Best Practices

TiDB Frequently Asked Questions Summary

| username: Fly-bird | Original post link

Resources must be sufficient, and the TiKV disk must be SSD.

| username: 舞动梦灵 | Original post link

What if it’s not an SSD? I’m planning to build a data center to store historical data using regular hard drives, with the lowest configuration, and synchronize yesterday’s data every day. Occasionally, I need to check historical data. Can it handle tens of terabytes of data with a 4-core, 12GB configuration?

| username: 路在何chu | Original post link

Just allocate enough resources, don’t think about closing the pit, you will always encounter it.

| username: Jolyne | Original post link

Having experienced some pitfalls, the hardware must meet the standards. It is best to use SSDs (you need to test whether they meet the requirements, as some SSDs do not). Otherwise, after running for a long time, the cluster will experience significant delays.

| username: Kongdom | Original post link

The hardware must at least meet the standard configuration.

| username: Soysauce520 | Original post link

No need to know much, if you don’t step on it, it’s not a pit.

| username: dba远航 | Original post link

The more you use domestic databases, the more you’ll realize how many pitfalls there are; you won’t miss any.

| username: caiyfc | Original post link

Your question seems a bit difficult to answer, it feels like asking how to prevent yourself from getting sick :joy:
Anyway, for high performance, you definitely need SSD drives and 10 Gigabit network.

| username: 像风一样的男子 | Original post link

Support domestic products

| username: ShawnYan | Original post link

This post’s topic is too broad; it feels more like a casual chat thread. Search more for issues encountered in the forum and read more articles in the columns, and you’ll find the answers.

| username: Kongdom | Original post link

Just remembered one thing: the server room must have a UPS, a diesel generator, and comprehensive fire safety measures~
This comes from an unforgettable experience of a server room fire and unexpected server power outage :joy:

| username: 随缘天空 | Original post link

The cluster configuration must meet the official hardware and network requirements. Additionally, before installation, optimize system parameters, ensure time synchronization across nodes, disable swap, etc. For details, refer to TiDB 环境与系统配置检查 | PingCAP 文档中心

| username: TiDBer_小阿飞 | Original post link

What’s there to research? Just keep jumping and climbing, accumulate experience, and you’ll become an expert. :rofl:

| username: andone | Original post link

There are still quite a few pitfalls with domestic databases.

| username: zhanggame1 | Original post link

TiDB has very high disk configuration requirements. If the configuration is poor, you will encounter lag and OOM issues.

| username: zxgaa | Original post link

Under the control of TiKV nodes, too many heartbeat statistics can easily cause network congestion.

| username: system | Original post link

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