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...
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.