November 2015
Beginner to intermediate
248 pages
5h 24m
English
In a production environment, we replicate data to multiple systems for the purpose of reporting or disaster recovery. When the source system fails, the replicated data is used to recover the system. Thus, replication provides a way to fail-over the system when there is a disaster. Other than disasters, a replicated system is also often used for the reporting purpose. In order to minimize load on main transaction servers, we can replicate data so that ad hoc reporting queries are executed in the replica system without loading the transaction system. These are very common in crucial transaction systems.
Most database systems provide a mechanism to replicate data between systems through log shipping, mirroring ...
Read now
Unlock full access