What data partitioning strategies would you use for a large-scale database?

Sample answer preview

Data partitioning, also called sharding, distributes data across multiple database instances to handle scale beyond a single machine's capacity. Horizontal partitioning splits rows across shards. All columns stay together, but different rows live on different shards.