【TIDB】br增量数据恢复

1.执行增量恢复 

(1)数据检查 
mysql> show tables; 
+----------------+
| Tables_in_test |
+----------------+
| my_test1       |
| my_test2       |
+----------------+
2 rows in set (0.00 sec)

(2)增量数据恢复 

br restore full \
--pd "192.168.1.11:2379" \
--storage "local:///tidb/backup/mytidb_cluster/incr" \
--ratelimit 128 \
--check-requirements=false \
--log-file restore_inc.log

[tidb@mysql1 ~]$ br restore full \
> --pd "192.168.1.11:2379" \
> --storage "local:///tidb/backup/mytidb_cluster/incr" \
> --ratelimit 128 \
> --check-requirements=false \
> --log-file restore_inc.log
Detial BR log in restore_inc.log
Full restore <---------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
[2024/08/18 12:05:24.738 +08:00] [INFO] [collector.go:60] ["Full restore Success summary: total restore files: 2, total success: 2, total failed: 0, total take(Full restore time): 1.1862657s, total take(real time): 2.727705106s, total kv: 2, total size(Byte): 72, avg speed(Byte/s): 60.69"] ["split region"=136.702507ms] ["restore checksum"=1.150370005s] ["restore ranges"=1] [Size=4725]
[tidb@mysql1 ~]$ 

(3)验证数据 

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| my_test1       |
| my_test2       |
| my_test3       |
+----------------+
3 rows in set (0.00 sec)