Re:GitHub's online schema migration for MySQL
by sa46 on Friday May 04, 2018 @03:39AM
(#16992856)
Google's Spanner doesn't support foreign keys but does support interleaved tables to cover some use cases of foreign keys. Spanner sees wide use inside Google.
The usual routes for data consistency between tables are batch clean up or in-app validation.
The usual routes for data consistency between tables are batch clean up or in-app validation.