How to implement offline sync in java MySQL?

Question

I plan to implement offline sync on my java application.

When machine is offline then use local DB data and restrict some feature like create/delete. I Got some idea after find a lot of search from google. But, still not clear exactly.

My doubts are

Is symmetric DS or MySQL replication can help my scenario ?
Sync from server every minute through web service (for server to local and local to server DB data)

What does it mean offline? When the application is not running or when there's no network? — Boris Pavlović, Apr 09 '18 at 07:57
What are the two databases that should be synced? Is there a network between? — Boris Pavlović, Apr 09 '18 at 08:07
One is server : It can store multiple client DB data (server differentiate data by client id) Another one is client: It can store local data only Is there a network between : Yes — Siva, Apr 09 '18 at 08:23
How can they sync if they're offline? If there's no network connection between sync is impossible — Boris Pavlović, Apr 09 '18 at 08:30
@BorisPavlović What are the two databases that should be synced? Is there a network between? Server runs on cloud and clients run locally — Siva, Apr 09 '18 at 12:43
If databases are not having network connection there's no way of establishing communication nor sync — Boris Pavlović, Apr 09 '18 at 15:45

score 0 · Answer 1 · answered Apr 09 '18 at 07:58

0

The answer to the second question is positive. Symmetricds can sync every minute or more often if necessary. It's a configuration parameter

answered Apr 09 '18 at 07:58

Boris Pavlović

63,078
28
122
148

Did you mean "Sync from server every minute through web service" is best ? – Siva Apr 09 '18 at 08:06
I did mean the second question – Boris Pavlović Apr 09 '18 at 08:08

How to implement offline sync in java MySQL?

1 Answers1