Not the answer you need?
Register and ask your own question!

pt-online-schema-change and foreign key constraints

edwhedwh ContributorCurrent User Role Novice
This is a great tool. I'm using it with --alter-foreign-keys-method=rebuild_constraints, because my reading of the help is that this is the only really safe option (please correct me if this is wrong).

However this can cause a rebuild of other tables - which can on occasion be a worse problem for availability than not using pt-online-schema-change at all, if the second table is large, or if there are multiple tables to rebuild.

I was wondering if it is possible for this tool to work in a way which also rebuilds those other tables in a nicely available way?

Comments

  • edwhedwh Contributor Current User Role Novice
    Bump. Maybe my question isn't clear?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.