How can I synchronous two databases

Question

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

               synchronization

score 0 · Answer 1 · answered Apr 11 '13 at 17:31

0

MySQL Replication

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

https://dev.mysql.com/doc/refman/5.0/en/replication.html

answered Apr 11 '13 at 17:31

Doug

371
2
5
15

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

score 0 · Answer 2 · answered Apr 11 '13 at 20:05

0

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

answered Apr 11 '13 at 20:05

Chakri

1,070
6
8

How can I synchronous two databases

2 Answers2

Related