Shard Mapping Manager for Database Sharing to Provide High Availability and Fault Tolerance on the Cloud

  • Vandana Sivaraj et al.

Abstract

The logical split of entities or tables into an independent small portion that can be manageable with better performance and availability is high during the process which has been done appropriately. However, the strategy of portioning is made for distributing database components are made-up conceptual to perform from logical perspective and its utilization through physical and logical that is through software. One of the major developments in partitioning is sharding that act as horizontal portioning which is traditional but until it performs to be challenging during implementation due to frequent need of customer code and enhancing complexness for the application layer. The availability of elastic database tools for simplifying the shared application to create and manage over SQL database using elastic database client library. Moreover this tool is utilized for distributing database for both one shard per customer and multi shard. This paper discuss about architecture of multi-shard mapping manager and its implementation on cloud environment utilized for distributing database system to various vendors and also provide better scalability to large database, high availability and fault tolerance. Multi shard plays a major role in scattering the data among data node presented over redundant server for efficient management of Microsoft Azure cloud SQL.

Published
2019-12-21
How to Cite
et al., V. S. (2019). Shard Mapping Manager for Database Sharing to Provide High Availability and Fault Tolerance on the Cloud. International Journal of Advanced Science and Technology, 28(17), 932 - 945. Retrieved from http://sersc.org/journals/index.php/IJAST/article/view/2457