-
Notifications
You must be signed in to change notification settings - Fork 1.1k
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
[docdb] PITR: Add persistent tracking for DDL statements #8773
Labels
area/docdb
YugabyteDB core features
kind/enhancement
This is an enhancement of an existing feature
priority/medium
Medium priority issue
Comments
After the initial proof of concept, we should augment this with
cc @sanketkedia |
spolitov
added a commit
that referenced
this issue
Jun 5, 2021
Summary: It is a frequent case then we would like to restore the DB state to some time right before DDL operation. For instance before the drop table. This diff adds a DDL log, which could be seen using yb-admin. So user could easily pick up time for restore snapshot schedule operation using this log. Also changed UI to render time using local timezone instead of UTC. Test Plan: ybd --cxx-test yb-admin-test --gtest_filter AdminCliTest.DdlLog Reviewers: bogdan Reviewed By: bogdan Subscribers: ybase Differential Revision: https://phabricator.dev.yugabyte.com/D11744
spolitov
added a commit
that referenced
this issue
Jun 17, 2021
Summary: It is a frequent case then we would like to restore the DB state to some time right before DDL operation. For instance before the drop table. This diff adds a DDL log, which could be seen using yb-admin. So user could easily pick up time for restore snapshot schedule operation using this log. Also changed UI to render time using local timezone instead of UTC. Original commit: D11744 / a4ea9e4 Test Plan: ybd --cxx-test yb-admin-test --gtest_filter AdminCliTest.DdlLog Jenkins: rebase: 2.6 Reviewers: bogdan Reviewed By: bogdan Subscribers: ybase Differential Revision: https://phabricator.dev.yugabyte.com/D11952
I am taking point on this. cc @spolitov to avoid duplication. |
yugabyte-ci
added
kind/bug
This issue is a bug
priority/medium
Medium priority issue
labels
Jun 9, 2022
yugabyte-ci
added
kind/enhancement
This is an enhancement of an existing feature
and removed
kind/bug
This issue is a bug
labels
Jul 30, 2022
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
area/docdb
YugabyteDB core features
kind/enhancement
This is an enhancement of an existing feature
priority/medium
Medium priority issue
Jira Link: DB-1829
To start with, this can be a new type of
sys_catalog
entry, written to from every DDL entry point. We can use a simple time based query interface, to be able to see the last N entries / last M hours of entries, via yb-admin.This will help for PITR, as we can then be able to rollback to right before executing a particular DDL statement:
The text was updated successfully, but these errors were encountered: