I'm having trouble finding the differences between data synchronization and replication.
From what I can tell, replication is making all data between 2 databases the same. Synchronization doesn't necessarily make ALL DATA between the two databases the same. Replication is a one time transfer, where synchronization can be small updates to keep data consistent? I'm not too sure, please correct me here?
If I was to have a central mySQL database which stores multiple mobiles data, and my aim was to keep the data from the phone the same as the data from mySQL (only the certain users data), would that be synchronization or replication or both? It would initially get all the users data(replication), and then sent any updated data after that(synchronization)?
Hope can someone can clear up the confusion, many thanks!
Data backup is a process of storing data in more than one location to ensure that the data can be recovered if necessary. Data replication involves making copies of all or specific parts of your data so that you have multiple versions of the same thing on hand if something happens with one version.
Synchronous replication is the process of copying data over a storage area network, local area network or wide area network so there are multiple, current copies of the data. Synchronous replication is mainly used for high-end transactional applications that need instant failover if the primary node fails.
One of the major differences between a Synchronization task and a Replication task is that, in a synchronization task, you can transform the data before loading it to the target. However, in a Replication task, you can replicate the data from source to target without transforming the data.
Replication is simply the repetitive action of a same array or coloms of information, while duplication means that each time an array is produced for example each result is identical to the first one.
To put it very bluntly:
But I'd wager the terms are often used interchangeably, I'm pretty sure I could find plenty of examples of "replication" being used to describe multiple databases being kept in sync.
So don't get too hung up on these two terms - they mean the same general thing, but obviously there can be a vast difference in how different database systems or tools achieve whatever they refer to as "replication" or "synchronization".
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With