Replication
It allows you to have multiple copies of same database at different locations. At most basic level, replication is implemented using materialized views. In case of synchronous replication, transactions are either successfully propagated to all sites or it is rolled back. It ensures no conflict will occur between sites. It requires stable network environment and mostly used for read only materialized views. In asynchronous replication, changes to each site is stored locally and forwarded to other sites. In this case, conflict resolution processes are required.Replication generally improves performance across network. For example, if you use a database for online transactions as well as reporting, you can replicate the database and run transactions and reporting on different versions.
No comments:
Post a Comment