Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

migrated from superuser.com Jan 26 '11 at 15:46

This question came from our site for computer enthusiasts and power users.

2 Answers

up vote 7 down vote accepted

After some digging, the answer in the MySQL/phpMyAdmin context is as follows:

  • Synchronization: Brings 2 DBs in sync (schema and data)
    Note: This is a 1-time process, which can be run every time you would like to sync 2 DBs, but is triggered manually.
  • Replication: This is used to continuously (automatically) replicate data between 2 DBs. This is done asynchronously, which means that you do not have to have a permanent connection between the 2 DBs.

Note:
To setup replication the sequence is this:

  • Run Synchronization to sync DBs
  • Setup Replication
share|improve this answer
add comment

Replication is used to describe the event of copying data. Synchronization is 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.

share|improve this answer
3  
The question is tagged [mysql] and [phpmyadmin] -- I have the impression the user is asking for more specific information. –  Daniel Beck Jan 24 '11 at 10:48
    
Thanks for the feedback Daniel, I found more specific information and included it and a source link. –  Mark Essel Jan 26 '11 at 19:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.