Sharding refers to the process of distributing data across multiple servers which helps in retrieving it easily. When the data set is huge, it is said that sharding significantly improves the query response time.
Let us see how we can implement sharding. Sharding requires a minimum of three servers for test purpose. In production scenario, sharding may require more servers.
Sharding is implemented through the following :-
1) Config Servers – These servers contain the metadata as to where the data belongs to. Means, it holds data as to which shard each data goes. A minimum of 2 config servers in a huge databases system is recommended.
2) Query Router Servers – These servers are the ones that communicate with the application directly...Read More