Skip to content
This repository has been archived by the owner on Jun 28, 2018. It is now read-only.

Use pt-online-schema-change or gh-ost or ocs_cli for MySQL Online schema changes? #346

Open
Slach opened this issue Mar 9, 2018 · 2 comments

Comments

@Slach
Copy link

Slach commented Mar 9, 2018

would like someone implements support one of following tools?
for your great tool
https://www.percona.com/doc/percona-toolkit/LATEST/pt-online-schema-change.html
https://github.com/github/gh-ost
https://github.com/facebookincubator/OnlineSchemaChange

@JensRantil
Copy link
Contributor

What problem are you trying to solve? MySQL 5.6(?) introduced Online DDL which allows online ALTERs.

@Slach
Copy link
Author

Slach commented Mar 9, 2018

as you can see
https://blog.pythian.com/depth-mysql-5-6-ddl/
pt-online-schema-change and other like tools can throttle disk usage and don't lock table in some cases change column type, add fulltext index etc.

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

No branches or pull requests

2 participants