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?
Thanks for your support
Cheers Kristian
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]