Can TiFlash Recover from Partial Data Loss?

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

Original topic: tiflash部分数据丢失,能否恢复

| username: yulei7633

Last time, I was not very familiar with modifying parameters. When modifying parameters, I only modified TiKV and did not synchronize the modification of TiFlash parameters. As a result, data exceeding 8M per row was synchronized to TiKV but not to TiFlash. Some data was not synchronized to TiFlash. How should this unsynchronized data be handled?

  1. Scaling down TiFlash and then scaling it up again is one way, but it is not very friendly. If the data volume is too large, it will take a long time.
  2. If the TiFlash parameters are modified to be consistent with TiKV, can the data be automatically synchronized? I am not sure if this method will work.
  3. Are there any other ways to query the missing data and manually use some tools to synchronize it to TiFlash?
| username: 像风一样的男子 | Original post link

Isn’t TiFlash synchronization very fast?

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

Yesterday, I saw many people asking why it was so fast.

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

No need to scale in or out, just set TiFlash replica to 0 and then change it back to 1, it should recover quickly.

| username: yulei7633 | Original post link

Okay, I will take a closer look at the document you sent later.

| username: yulei7633 | Original post link

This method is quite good, thank you.

| username: andone | Original post link

It can be restored very quickly.

| username: dba远航 | Original post link

Set TiFlash replica to 0 and then change it to 1, which is equivalent to restarting the replication.

| username: system | Original post link

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