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