What is data partitioning or sharding, and how do you decide on a partition strategy for a database?

Sample answer preview

Data partitioning, also called sharding when distributed across multiple database instances, divides a large dataset into smaller, more manageable pieces. It is the primary technique for horizontally scaling databases beyond the capacity of a single server.