Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two databases. First one is local and the other is at Internet, in my domain. I want to synchronous two databases. Is it possible to do so ? How can I synchronous two databases ?

Some detailed note on the databases, master databases is the local one, I wish to update Internet database from local one so that even Internet goes down, my databases reside in the my domain would be available.

To update the databases, I am mostly using the MySQL.

Visualization :

I mainly work on the local database.

      |-----|                   |-----|
      |     |                   |     | 
      |     |  <---->           |     |
      |-----|                   |-----|
       local                     database at my domain

share|improve this question

MySQL Replication

"Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves)"

share|improve this answer
If I use sqlite in the local one. Still, can replication be used? – slaki Apr 11 '13 at 17:34
@slaki - you, you cannot replicate between sqlite and mysql. – EEAA Apr 11 '13 at 17:54

Try greplicator

greplicator is indeed a-time solution made to replicate data from MySQL database holiday to a relational database, for example Oracle, Microsoft SQL Server, IBM DB2 UDB and MySQL

share|improve this answer

Your Answer


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.