Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 3副本3kv 只有1个kv备份了能恢复数据么
Can data be recovered if there are 3 replicas and 3 KVs but only 1 KV is backed up?
Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 3副本3kv 只有1个kv备份了能恢复数据么
Can data be recovered if there are 3 replicas and 3 KVs but only 1 KV is backed up?
Column - Methods for Lossy Recovery of Multiple Damaged Replicas in TiDB | TiDB Community
Having only one KV backup might not be sufficient. During restoration, integrity should be verified. If it’s incomplete, it probably can’t be restored.
Incomplete recovery does not guarantee data consistency.
Incomplete recovery should be able to restore most of the data.
Can data be recovered if only one of the three KV copies is backed up?
How was the backup done if only one KV copy was backed up?
If backups are made through virtual machine snapshots, the backups of the three TiKV nodes are not consistent. In theory, as long as the snapshot backup of one node is normal, the database can be restored, but it requires the original TiDB developers to perform an unconventional recovery.
You can try using online-unsafe-recovery, 专栏 - 使用Online unsafe recovery恢复v6.2同城应急集群 | TiDB 社区
What do you mean by only one TiKV backup? Is it the SST file backup on one machine? If it is the SST file backup of a single machine, it cannot be restored.
Three replicas, losing one is acceptable; if two are lost, data cannot be recovered.
Even if two out of three replicas are broken, it can still recover.