MySQL schronization

[peggypph]

I use MySQL as the backend database and client MDB program to access the database via ODBC. It works fine. Meanwhile, the application (including client program and backend database) will be put in 2 different places. In order to make 2 MySQL database synchronize, I use tools under MySQL that both MySQL will update the other concurrently. It works fine when the internet connection between 2 sites has no problem. However, when any one party connection has problem and resume OK later. The synchronization process does not work until I stop/start the MySQL service at both site. In other words, the system will not resume automatically synchronization.

Does any experts have such exercise/projects before?
Or anyone has FAQ site on MySQL similar to this kinds of Forum that I can address this problem more specific?

Thanks

Regards,
Peggy