News for hackers. Stuff that matters.
Re:GitHub's online schema migration for MySQL by anton_gogolev on Thursday May 03, 2018 @05:31AM (#16984495)
How could foreign keys ever be a "hassle"?
Re:GitHub's online schema migration for MySQL by shlomi-noach on Thursday May 03, 2018 @07:27AM (#16984972)
They can be a hassle when you want to shard your data, having outgrown your single-instance capacity. You will either shard functionally (extracting complete tables to other database servers), in which case FKs will completely break, or horizontally (split rows across database servers), in which case you may or may not be able to still use FKs.

They're also a performance impact on large tables since inserts/deletes must make multiple trips to the tables/indexes. That's a growing operational hassle as tables grow larger.

Re:GitHub's online schema migration for MySQL by asaph on Thursday May 03, 2018 @08:14AM (#16985229)
> You will either shard functionally (extracting complete tables to other database servers)

This isn't sharding. This is vertical partitioning. Sharding is a type of horizontal partitioning.

Reference: https://en.m.wikipedia.org/wiki/Shard_(database_architecture...