What are some data replication strategies?

  • 2
  • 7
PeerSpot user

2 Answers

Real User
Top 5
Nov 23, 2022

There are a few common methods, or strategies as you called them, for data replication. Yes, they will correspond with your company needs, but you also should take them into consideration when selecting a data replication software, as they determine its way of work. The following are some of the most popular strategies for companies to replicate their data:

  • Snapshot replication

  • Bidirectional replication

  • Log-based incremental replication

  • Key-based incremental replication

  • Merge replication

  • Full table replication

  • Transactional replication

You can research each one for more detail, but in my opinion you should do it before, not after, you start looking for a solution for data replication.

Search for a product comparison in Data Replication
Real User
Top 5
Nov 23, 2022

I assume you're not currently using data replication or any software for it. If that's your case, then you should really consider what your organization is aiming for through this process. Then you can explore different data replication strategies, and potentially softwares, that cover your needs. But basically the difference between them is how they allow you to replicate, store, and change data.

If you take the most common strategy, the snapshot one, it's the easiest to use. It snapshots the source and replicates the data in the snapshot in the replicas. But it doesn't track the changes to the source database. Then there's transactional replication, in which changes are reflected immediately in copies.

Like I said, I suggest you first find the priorities of your company related to data replication and then explore the types of strategies you can use.

Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication. Updated: November 2023.
744,865 professionals have used our research since 2012.
Data Replication
What is data replication? Data replication is the process of copying data from one to a different location.
Download Data Replication ReportRead more

Data Replication experts

Siddharth Matalia - PeerSpot reviewer
Abdul-Salam - PeerSpot reviewer
Enric Cuixeres - PeerSpot reviewer
Sarthak Panchal - PeerSpot reviewer
Erik Jones - PeerSpot reviewer
BharathKumar2 - PeerSpot reviewer
Mina_Magdy - PeerSpot reviewer