Synchronous and Asynchronous Replication

The objective of this study is to analyse the various technical aspects of synchronization between databases while replication is occurred. To achieve this feat, we embarked in a systematic review of the literature around this theme, an examination that revealed that synchronization is not done with more than one Peer at the time. Therefore, we have been motivated to develop an algorithm which supports the synchronization with more than one Peer. Background and Objective: This paper presents a systematic review of the two replication approaches, namely: synchronous replication and asynchronous replication. The purpose of this study is to analyse the different technical aspects of synchronization between databases during replication. Methodology: To achieve this, we used the documentary method that allowed us to collect the necessary documents containing the literature that fits with this research and that allowed us to conduct this review. Apart from this one, algorithmic helped us to develop a model that supports synchronization with more than one peer. Result: Our long-awaited result being an algorithm, we have similarly taken care to present the fruits of the efforts of our predecessors who would have proceeded in the same way as us. Conclusion: Finally, we found that it is necessary to have a synchronization algorithm independently of the DBMSs that can be used by the designers of distributed databases.