migrate icon indicating copy to clipboard operation
migrate copied to clipboard

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

Open Slach opened this issue 7 years ago • 2 comments

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

Slach avatar Mar 09 '18 11:03 Slach

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

JensRantil avatar Mar 09 '18 15:03 JensRantil

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.

Slach avatar Mar 09 '18 15:03 Slach