News for hackers. Stuff that matters.
Re:GitHub's online schema migration for MySQL by killbrad on Thursday May 03, 2018 @03:37AM (#16984052)
Child-side foreign keys? Does that mean constraints in app logic instead of the database?
Re:GitHub's online schema migration for MySQL by shlomi-noach on Thursday May 03, 2018 @04:22AM (#16984224)
No, on the database itself. I used "child side" for lack of better terminology. Every foreign key has two edges: the "parent" table and the "child" table. Rows in the "child" table depend on existence of matching rows in the "parent" table.

It should be feasible to run `gh-ost` to ALTER a table that only has "child"-side constraints. It will be impossible to run `gh-ost` to ALTER a table that has "parent" side constraints.

Hope this clarifies.