Efficient Horizontal Scaling of Databases using Data Sharding Technique

Abstract

As the new era of computing technology begins with the start of the 21st century, the data produced by each person are increasing enormously day-by-day. Companies started to track one’s personal details from applications like media sharing, social networks, eCommerce, etc. since they have started to generate a lot of data traffic. The Database, where these heavy loads of generated data have been stored, had to scale out to handle the network traffic. Cloud computing arrival carves a solution for this trafficking problem by making data sharding a suitable option for scaling the data. This paper discusses about the importance of database sharding and the distribution of the database over the different server and also how sharding is helpful to scale the incoming amount of enormous data to control the data trafficking issues in the cloud database. Also compares the difference in the performance of database with and without sharding techniques using SQL server instance.