Migration Of SQL Database To Mongodb Database With A Multi-Thread Approach

Abstract

A cloud computing is an emerging and the current choice of computing model by its dynamically elastic and often virtualized resources delivery nature at the levels of infrastructures, platforms, and software. It is becoming a possible choice for most IT industries and other sectors to benefit out of its advantages. Most of the industries are migrating their legacy IT infrastructures, platforms, and software to the cloud computing environment and also from one cloud service provider to the other even if the migration process is difficult. One of the reasons that make the migration process more difficult is, the incompatibility of data format on the existing and destination platform. The concern of this study is to design a database migration algorithm by using a multi-threaded approach to migrate data concurrently, JSON data interchange format for the transmission of data and an SSL protocol for securing the transmission of data. The database migration process is separated into pre-migration, during migration and post-migration stages. The proposed solution tried to migrate a database by dividing the total migration task into subtasks based on three conditions: a relational database with multiple schemas, a single schema with multiple relations and one database schema with a single relation but with a large number of records and the solution migrates the database based on thread per schema, thread per relation and thread per 100,000 records respectively.