Description

PITR allows user to recover the database back to any point of time.

In principle, given an initial full backup archive, and several incremental changes, it is enough to restore to a snapshot at any given time.

The PITR feature should balance between the cluster's performance when making the continuous backup, and the restore speed when doing PITR.

Task List

Sprint 1 - 100 person day

• P0 test: fix coordinator bug and add fail over ddl case I ticdc#768 TiCDC support external storage (contain snapshot level consistent log backup).
• P0 Support restore data from TiCDC log #440 BR support restores data from TiCDC log backup.
• P0 Support generate undo SQL from TiCDC log #441 BR support generates undo SQL from TiCDC log backup.
• P0 Add checksum mechanism for cdc log restore #511 Add checksum mechanism for cdc log restore.
• P1 PITR building block features in SQL #445 PITR building block features in SQL
• P1 Support generate difference backup with log backup #442 BR support generates differential backup with log backup.

Sprint 2 - 100 person day

• Support PiTR with BR and TiCDC tidb-operator#3017 TiDB Operator supports PITR with TiCDC and BR
• implement local external storage, to adapt to the situation where the user does not have cloud storage?
• PITR backup management
  • Automatic backup retain strategy
  • Automatically generate full/differential backup data
  • Automatic backup data verification

Category

• Feature
• Reliability

Value

Value description

(TBD)

Value score

• (TBD) / 5

Workload estimation

• (TBD) person-day

Time

Time
GanttStart: 2020-07-01
GanttDue: 2020-10-22
GanttProgress: 80%