Partitioning, Sharding

✅ Partitioning

divide big table into small several tables

• 👍🏻 improve query performace
• data is physically divided into seperate tables

• but user can access the data as if it is on the same table

• 🆚 save all data on one computer

✅ Sharding

save divided data in small unit
on several DB server with same schema

• shard: small unit to divide data into

• one of parallel partitioning

• 👍🏻 query performace
• 👍🏻 balance overhead

• 👍🏻 parallel scale-out of DB

• 🆚 save data on several computers