What is Sharding?
Splitting a large database across multiple servers so each one holds a portion of the data.
Why It Matters
Sharding allows databases to scale beyond the limits of a single server by distributing the load.
Real-World Example
Splitting users A-M on one database server and N-Z on another to halve the load on each.
“Understanding terms like Sharding matters because it helps you have better conversations with developers and make smarter decisions about your software. You do not need to be technical. You just need to know enough to ask the right questions.”
Related Terms
Replication
Copying data from one database server to others so multiple servers have the same information.
Horizontal Scaling
Adding more servers to handle increased load
Database
An organised collection of data that your application can store, retrieve, and update
Scalability
Your application's ability to handle growth in users, data, or traffic
Learn More at buildDay Melbourne
Want to understand these concepts hands-on? Join our one-day workshop and build a real web application from scratch.
Related Terms
Database
An organised collection of data that your application can store, retrieve, and update
Scalability
Your application's ability to handle growth in users, data, or traffic
Horizontal Scaling
Adding more servers to handle increased load
Replication
Copying data from one database server to others so multiple servers have the same information.
SQL
A language for communicating with databases, used to create, read, update, and delete data
NoSQL
Databases that store data differently from traditional tables, often as flexible documents or key-value pairs