Abstract:
All over the world, as IT technology is increasingly, important services are also becoming more convenient. As a result of it; most of the enterprises are using database system. A distributed database system manages and controls the entire databases as a single collection of data. Many distributed database application need to replicate data to improve data and availability and query response time. [8] Most of database products use asynchronous replication, which is very efficient but can compromise consistency. As an alternative, synchronous replication guarantees consistency. [7] In this paper, we use Two-Phase Commit Protocol (2PC) to ensure that both master and slaves install the updates and analyze existing synchronous replication based on server architecture: master and group replicated databases implemented by sale processing system.
