Sharding or Data Partitioning

Important way to increase scalability:

• Horizontal Partition: split the same table across multiple servers, usually based on column

• Vertical Partition: store different tables in different servers.

Common problems of Sharding

Joins and Denomalization

Referential Integrity

Rebalancing

Data skew.