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

Fast ddl和pitr不兼容描述不太准确 #17204

Open
chuchuwei opened this issue Apr 24, 2024 · 2 comments
Open

Fast ddl和pitr不兼容描述不太准确 #17204

chuchuwei opened this issue Apr 24, 2024 · 2 comments

Comments

@chuchuwei
Copy link

File: /release-7.1/faq/backup-and-restore-faq.md
image

在 v7.0.0 之前版本中,pitr感知不到fast ddl创建的索引数据,所以pitr恢复以后也没有这部分索引数据
那 “BR 会将通过索引加速功能创建的索引数据删除,再重新创建” 这句话是什么意思

@Oreoxmt
Copy link
Collaborator

Oreoxmt commented Apr 24, 2024

@Leavrth PTAL

@Leavrth
Copy link
Contributor

Leavrth commented Aug 9, 2024

BR 可以知道哪些索引是日志备份期间通过加速索引特性创建的。
所以 BR 会在恢复的最后阶段对通过索引加速功能创建的索引都执行一遍下面两条 SQL 语句

DROP INDEX `index_name`;
ADD INDEX `index_name` ...;

https://github.com/pingcap/tidb/blob/b0823fae8ee4bcc66063addd39242b82b6b13eb3/br/pkg/restore/client.go#L3294-L3297

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants