> I'm going to setup a mySQL database that has to be accessed from Asia
> and Europe. Due to the huge distance I plan to duplicate the database
> and store one copy both in Europe and Asia. To achive data consistency
> both databases has to synchronize each other. Because of the long
> distance a disconnect for several hours is possible (worst case).
> Is database replication an adequate solution for synchronizing the
> databases or is there maybe a better way? How does mySQL replication
> handle disconnects in respect to the synchronization?
1. Yes
2. Well
Check the archive of this list - several people have reported doing similar
things. E.g. replicating
a net-connected database to a slave over a dial-up which connects only
every few hours. Replication
attempts to connect regularly. If connection fails, replication does not
occur, When the connection
reappears, the slave smoothly catches up.
Have you solved the update problem? Remember that all updates must go to
the Master, and then be
replicates to the slave. Is Europe or Asia the master copy?
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
