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.

Sign up for GitHub

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

Jump to bottom

源库使用gh-ost是否要关闭DDL同步 #300

Closed
shawnloong opened this issue Dec 8, 2020 · 5 comments
Closed

源库使用gh-ost是否要关闭DDL同步 #300

shawnloong opened this issue Dec 8, 2020 · 5 comments

Comments

@shawnloong
Copy link

源库使用gh-ost是否要关闭DDL同步
@Ryan-Git
Copy link
Collaborator

Ryan-Git commented Dec 8, 2020 •
edited
Loading

不用，会在目标侧同样生效。
如果不想同步到目标侧，那可以关掉 ddl。

现在的一个已知问题是临时表会残留，可以通过多配相应的路由解决。
#236

@shawnloong
Copy link
Author

shawnloong commented Dec 8, 2020 •
edited
Loading

比如同步历史库这种场景 gh-ost最后是rename表，所以貌似只能禁用DDL同步，否则会导致历史库数据丢失，因为同步中过滤了delete操作

@Ryan-Git
Copy link
Collaborator

Ryan-Git commented Dec 8, 2020

哦。。那是业务场景问题

@Ryan-Git Ryan-Git closed this as completed Dec 8, 2020
@shawnloong
Copy link
Author

目前 功能 没有包含数据校验功能 吧？

@Ryan-Git
Copy link
Collaborator

Ryan-Git commented Dec 9, 2020 •
edited
Loading

过滤 delete 咋校验。。
数据完全一致的话可以用 mysql 常用的工具校验，比如 pt-table-checksum, pingcap 的 sync-diff-inspector

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Ryan-Git @shawnloong