System Design Fundamentals
Vote

0% completed

​

Data Replication vs. Data Mirroring

Both make copies of data. They are used for different reasons, and the differences follow from that.

Data Replication

Data replication is copying data from one location to another. It can be synchronous (in real time) or asynchronous (with some delay).

It often creates multiple copies, stored across different servers or locations.

Its purpose is enhancing data availability and accessibility. It is used for load balancing, and it lets you run analysis against a copy without touching the primary data source.

.....

.....

.....

Like the course? Get enrolled and start learning!
Tan Chin Siang

Tan Chin Siang

· 2 years ago

Can we say that mirroring is a backup system?

Show 1 reply
T

thandra82

· 2 months ago

why not create a table for this content

  1. Real-Time Synchronization:
    • Replication: Can be either synchronous or asynchronous.
    • Mirroring: Typically synchronous.
  2. Purpose and Use:
    • Replication: Used for load balancing, data localization, and reporting.
    • Mirroring: Primarily for disaster recovery and high availability.
  3. Number of Copies:
    • Replication: Can create multiple copies of data in different locations.
    • Mirroring: Usually involves a single mirror copy.
  4. Performance Impact:
    • Replication: Can be designed to minimize performance impact.
    • Mirroring: Since it’s synchronous, it might have a more significant impact on performance.
  5. Flexibility:
    • Replication: More flexible in terms