Mysql – the difference between Replication and Synchronization

databaseMySQL

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

Best Answer

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
Related Topic