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

schema store #174

Open
ming535 opened this issue Jun 18, 2019 · 3 comments
Open

schema store #174

ming535 opened this issue Jun 18, 2019 · 3 comments
Assignees

Comments

@ming535
Copy link
Contributor

ming535 commented Jun 18, 2019

Initial design https://github.com/moiot/gravity/blob/master/docs/rfc_schema_storage.md

we can consider use https://github.com/bytewatch/ddl-executor

@Ryan-Git
Copy link
Collaborator

为啥要 binlogPositionId 存本地?直接存 gtid 不行吗

@Ryan-Git
Copy link
Collaborator

还有个问题,不能每个 pipeline 都干这个事情,应该一个实例只做一次。
我觉得应该用 gtid 做键,一来避免不同 pipeline 重复,二来方便查询。其次不仅要保存执行后的表结构,还要保存所执行的语句。最后还需要一个归档/快照机制,不然一个实例的 ddl 时间长了可能还是太多。

@ming535
Copy link
Contributor Author

ming535 commented Jun 23, 2019

嗯,归档/快照,以及每次 schema 的变更肯定需要,其他的可以再考虑一下。包括单机版和集群版默认的 schema store 放在哪里也可以再看考虑一下。

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