Introducing different types of replication
An organization might want to serve users in different geographies from a central database. If the datacenter is located in the US, and some of the users are located in Asia, the network latency for the database queries generated in Asia might be longer than the expected response time for the application. In such cases, the organization might want to maintain another local database in a datacenter in Asia. Once a second database is added to the system, these two databases have to be maintained in sync with each other so that the users in Asia see the same results as the users in the US. Another example is the duplication of state level data sets in the local state plane projection at a state level database, while the national database has the same data in a geodetic system. One way to achieve this data duplication is to use a replication strategy to push the changes from one database to the other database. In this distributed system, there are different...