Skip to content

system table backup/restore #52530

@Leavrth

Description

@Leavrth

Enhancement

  1. Filter out the unrecoverable tables in the backup stage. Therefore, we have a more friendly filter parameter usage.
  2. Distinguish which tables are unrecoverable.
  3. Support to restore the recoverable tables.

Recoverable tables

  1. mysql.tidb_kernel_options, mysql.expr_pushdown_blacklist and mysql.opt_rule_blacklist.
  2. [optional] mysql.password_history.
  3. [by SQL interface] mysql.plan_replayer_status. Use PLAN REPLAYER DUMP and PLAN REPLAYER LOAD interface.

Metadata

Metadata

Assignees

No one assigned

    Labels

    component/brThis issue is related to BR of TiDB.type/enhancementThe issue or PR belongs to an enhancement.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions