Victus Spiritus

home

Replication versus Synchronization, my first serverfault answer

26 Jan 2011

While I've looked up plenty of questions and answers on serverfault.com in the past, before a couple of days ago I had yet to answer a question (or log in). While skimming related questions to one I was looking up information on, I came across an unanswered query:

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization.

* What is the difference between Replication and Synchronization?
* When do you should use the one or the other?

Thanks, Udo

I decided to keep my response short and sweet, and responded with a working definition of those two database terms:

Replication is used to describe the event of copying data. Synchronization is usually continuous (at least one way) replication that maintains consistency between multiple data sources.

From phpmyadmin.net documentation

9.1 How can I synchronize two databases/tables in phpMyAdmin?

You can now synchronize databases/tables in phpMyAdmin using the Synchronize feature. It allows you to connect to local as well as remote servers. This requires you to enter server host name, username, password, port and the name of the database. Therefore you can now synchronize your databases placed on the same server or some remote server.

This feature is helpful for developers who need to replicate their database’s structure as well as data. Moreover, this feature not only helps replication but also facilitates the user to keep his/her database in sync with another database. Other than the full database, certain tables of the databases can also be synchronized.