Can I use the minimum configuration for TiDB when storing historical data?

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

Original topic: 我做历史数据存储tidb配置可以用最低配吗

| username: 舞动梦灵

I want to store historical data from the cloud to the local data center, specifically data from one year ago. The cloud setup has 39TB, 30 KV storage servers with SSDs, all with 8 cores and 64GB of RAM.

Will the minimum configuration for storing historical data in the local data center have any impact? The data will only be historical, and we will manually check it occasionally if there are any issues.

Is this configuration sufficient? All are mechanical hard drives:

  • 1 server with 8 cores and 16GB RAM for TiDB + PD + monitoring services
  • 9 servers with 4 cores and 8GB RAM for TiKV services, each partitioned to 5TB
| username: Fly-bird | Original post link

This configuration is fine, you can use the standalone version.

| username: andone | Original post link

No problem.

| username: kelvin | Original post link

There should be no problem.

| username: Kongdom | Original post link

Not enough disk space, 39T in the cloud, 20T on the physical machine :thinking:

| username: 舞动梦灵 | Original post link

With 30 servers on the cloud, each with 2TB, a total of 39TB is used. For self-built, prepare 9 TiKV nodes, each with 5TB, totaling 45TB.

| username: TiDBer_vfJBUcxl | Original post link

This configuration for historical data is fine.

| username: 路在何chu | Original post link

Occasionally check, it’s okay to use MySQL.

| username: Kongdom | Original post link

:joy: Oh, I misread it, I thought 4 cores were 4 machines.

| username: swino | Original post link

Enough.

| username: system | Original post link

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