Synchronous Replication: Novel Strategy of Software Persistence Layer Supporting Heterogeneous System

Synchronous replication is the ideal solution for organizations: search for the fastest possible data recovery, minimal data loss and protection against the problems of database integrity. This ensures that the remote copy of data that is identical to the primary copy is created at the same time the primary copy is updated. However, most of the synchronous replication does not consider the heterogeneous system. In this paper, a software persistence layer for heterogeneous synchronous replication has been designed and developed based on multi-threading known as PLSR. The main objective of this strategy is to make the persistence layer adaptive and make the synchronous replication process reliable and faster than other existing replication processes concerning cost minimization. In the proposed PLSR replication technique, the replication servers are OS independent and the entire replication process is not inter dependent nevertheless on the main server. Adding a new replication server is easier than other processes. The technique also introduces the modification of replication servers without making impairment to the entire process. The comparative Results with SQL server data replication show the PLSR is more acceptable in terms of transactional insertions and sync time. The result shows that PLSR outstanding performs 88.5 % faster than SQL server for transactional insert.