Issues with BR Cross-Version Backup and Restore

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

Original topic: BR跨大版本备份和恢复的问题

| username: Hacker_GfW2YGtK

In the production environment, due to IPv6 issues, it is necessary to migrate data from the original v4.0.4 cluster to the new TiDB cluster of version v7.1.0. The official documentation mentions that there are requirements for the versions of BR used for backup and restore, but there are no relevant instructions for the outdated version 4.0.4.
Can I use the data backed up by BR version 4.0.3 and then use BR version 7.1 to restore it to the new TiDB cluster of version v7.1.0? If not, are there any other migration solutions?

| username: Billmay表妹 | Original post link

I remember that BR recovery cannot be performed across versions.

| username: Hacker_GfW2YGtK | Original post link

Can you confirm this? If not, are there any other migration solutions? The old cluster has about 4TB of data.

| username: h5n1 | Original post link

The steps from 4 to 7 are a bit too much, it’s better to import and export. This can be tested in a test environment.

| username: Hacker_GfW2YGtK | Original post link

The main issue is that the current environment is like this, and using BR for backup and recovery should be the fastest way. There is no clear explanation in the official documentation at the moment.

| username: 我是咖啡哥 | Original post link

I think you can use backup to test a small database or table.
Recently tested br backup, and it increasingly feels like a logical backup :grinning: It might work.

BACKUP DATABASE `test` TO 'local:///mnt/backup/2020/04/';
| username: Billmay表妹 | Original post link

Try using dumpling+lightning. Importing in local mode is unimaginably fast. Reply from @啦啦啦啦啦

| username: zhanggame1 | Original post link

Using a faster hard drive and increasing the parameters can also make it quite fast.

| username: redgame | Original post link

Indeed, the scope is a bit large, but we can conduct an experiment.

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

Is it possible to set up a TiDB cluster with version 4.0.4, migrate the data using BR, and then upgrade the new cluster to 7.1.0? This way, the fault tolerance rate would be higher.

| username: caiyfc | Original post link

Use Dumpling and Lightning. Data safety should be ensured first, then the migration speed. If there are hidden issues with BR, wouldn’t you have to export it again?

| username: Anna | Original post link

The image you provided is not accessible. Please provide the text content that needs to be translated.