Where is the actual data of the TiFlash replica stored?

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

Original topic: 构建TIFLASH的副本的真实数据保存到哪里了

| username: residentevil

[TiDB Usage Environment] Production Environment
[TiDB Version] V6.5.8
[Encountered Problem: Problem Phenomenon and Impact] After constructing the table data using ALTER TABLE table_name SET TIFLASH REPLICA count, the physical file of this table cannot be seen on the local deployment disk of TiFlash. Where is the constructed data stored?

| username: WalterWj | Original post link

TiDB’s storage is not like a single-node database where each table corresponds to a file; the underlying storage is distributed. TiFlash 组件的存储格式版本如何查看? - #6,来自 tidb菜鸟一只 - TiDB 的问答社区

| username: residentevil | Original post link

The underlying layer is distributed, but the specific data is not stored on the TIFLASH node server, right?

| username: WalterWj | Original post link

If TiFlash replicas are created, there will be data files on the TiFlash server. However, it is not straightforward to know which files correspond to which tables and which tables correspond to which files.

| username: residentevil | Original post link

Where is the data file located on the server?

| username: 江湖故人 | Original post link

Check the TiFlash configuration file, you might have configured multiple data directories.

| username: 江湖故人 | Original post link

The command SHOW TABLE t1 regions; finds the prefix of the table star_key, such as t_119. Normally, you should be able to grep the t_119 directory in the TiFlash directory.

| username: residentevil | Original post link

Got it, found it this time, thank you very much. It seems that TIFLASH’s data is still stored locally.

| username: zhanggame1 | Original post link

It must be stored locally, where else would it be placed?

| username: DBAER | Original post link

TiFlash is a columnar storage system, generally storing data by columns. TiFlash seems to be based on ClickHouse.

| username: GreenGuan | Original post link

The data is stored on the physical machine where the TiFlash node is located, and the table structure is in PD.

| username: system | Original post link

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