I am developing a
Java application which will be used in 3 physical locations. Of these 3, on is the head office. I need to design in such a way that the head office application can see data from all 3 locations. My design is as follows:
I am not making a web app with the DB hosted on web server.
I will install the same DB at 3 locations. The headoffice will have the DBs of other 2 locations as well.
I want to write a component in java which can update the daily changes in DBs of other 2 locations to their backup/master DB instances at the headoffice computer.
Is my design correct?
How can i implement the synchronization in MySQL? Has anyone used Maatkit (mk-table-sync)