Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature Request]: Support querying the recoverable time period of the recovered object #20781

Open
1 task done
YANGGMM opened this issue Dec 17, 2024 · 0 comments
Open
1 task done
Assignees
Labels
kind/feature priority/p1 Medium priority feature that should be implemented in this version
Milestone

Comments

@YANGGMM
Copy link
Contributor

YANGGMM commented Dec 17, 2024

Is there an existing issue for the same feature request?

  • I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

为了全面保障表数据的安全性并增强误操作后的恢复能力,可以通过一种方法查看数据库中表的可恢复时间范围,包括基于快照和点时间恢复的时间段。
●如果是租户和数据库级别,需列出指定对象下的所有表的范围(除系统库表)。
●如果同一个对象被删除,再重建同名对象,那在语法层面,同名对象即为同一个对象,而无需考虑schema。
●只有是当前存在的表才可以被查看,例如在“2024-12-01 12:00:00”创建了一个快照,然后删除了tab1,那么此时由于数据库不存在他不,所以无法查看tab1可恢复时间段,除非新建同名对象。

mo_br pitr show recovery_window
--host string 集群 IP
--port int 集群端口号
--user string 用户名
--password 用户密码
--account string 查看对象租户/数据库/表级别需指定
--database string 查看对象为数据库/表级别需指定
--table string 查看对象为表级别需指定

集群管理员:
查看对象为租户:show recovery_window for account <account_name>;//需列出指定租户下所有数据库下表的信息

租户管理员:
查看对象为租户:show recovery_window for account;//需列出当前租户下所有数据库下表的信息
查看对象为数据库:show recovery_window for database <database_name>; //需列出指定数据库下所有表的信息
查看对象为表:show recovery_window for table <database_name> <table_name> //需列出当前租户下所有数据库下表的信息

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

@YANGGMM YANGGMM added priority/p1 Medium priority feature that should be implemented in this version kind/feature labels Dec 17, 2024
@YANGGMM YANGGMM self-assigned this Dec 17, 2024
@YANGGMM YANGGMM changed the title [Feature Request]: Support for querying the recoverable time period of the recovered object [Feature Request]: Support querying the recoverable time period of the recovered object Dec 17, 2024
@YANGGMM YANGGMM added this to the 2.1.0 milestone Dec 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/feature priority/p1 Medium priority feature that should be implemented in this version
Projects
None yet
Development

No branches or pull requests

1 participant