Geek Answers Handbook

The difference between data replication and synchronization?

I'm having trouble finding the differences between data synchronization and replication.

From what I can tell, replication makes all the data between two databases the same. Synchronization does not necessarily make ALL DATA between the two databases the same. Replication is a one-time transfer where synchronization can be a small update to maintain data consistency? I'm not too sure, please correct me here?

If I had a central mySQL database that stored several mobile data, and my goal was to make the data from the phone the same as mySQL data (only certain user data), it would be synchronization or replication, or both ? First, it will receive all user data (replication), and then send after that any updated data (synchronization)?

Hope someone can fix the confusion, thank you very much!

+4
source share
3 answers

In other words:

  • Replication implies that there are two or more copies of (all) data
  • Synchronization implies that two or more copies of the data are kept up to date, but it is not necessary that each copy contains all the data (although this is usually the case for database synchronization)

But I would say that conditions are often used interchangeably, I am pretty sure that I can find many examples of using "replication" to describe the synchronization of several databases.

So don’t get too obsessed with these two terms - they mean the same common thing, but obviously there can be a huge difference in how different database systems or tools achieve what they call “replication” or “synchronization” "

+7
source

As the previous poster explained, they are used interchangeably, but they must have different meanings.

As he said, replication is a situation where two or more replicas of a database exist at the same time. This allows users to work with the “same” database without competing for access time or overcoming technical limitations such as data transfer times or network delays.

Synchronization will be performed after a certain predetermined period of time (maybe minutes, hours, days, weeks) and comes down to redistributing the changes made to different replicas of the database into the main database.

+2
source

1) In fact, replication makes several databases at once with an almost zero or almost zero time interval.

2) Synchronization is the same as above, but time delay => 0 in (seconds, mins, days, months, etc.).

3) Time delay is a significant difference.

4) Thus, technical replication is a subset of synchronization. That's why you hear things like Replicated Sync .

0
source

More articles:


All Articles