0

I have a web based system in php that works locally in multiple places and in each place has a local database in mysqli.

Also my system in every place connect remotely to another database that get all of information from specific tables of local systems as an example when you insert a record in any place,this record insert to remote database ,too. and so on ,to tell summary sync information from local to remote database.

schema of the system

Now I know replication can be a good idea for this.

but I don't know when my remote database has a problem and my system can't connected to remote database how to apply changes in local database to remote database?

Dharman
  • 30,962
  • 25
  • 85
  • 135
zoro.cut
  • 31
  • 1
  • 1
  • 8
  • To solve this you can apply multiple distributed DB implementation plans. Its better to follow some tutorials first and then try the most suitable pattern by yourself. Post here for an exact answer with info about what you have already done. – kuma DK Jul 11 '16 at 11:14
  • @kuma-dk using of replication is a bad idea in this case? – zoro.cut Jul 11 '16 at 11:36
  • If your local application cannot connect to the remote database / synchronisation layer, then there is no way to apply any changes. – Shadow Jul 11 '16 at 13:18
  • Maybe for a short time my master can't be accessable – zoro.cut Jul 11 '16 at 14:30
  • Search for "occasionally connected applications data synchronization" – kuma DK Jul 11 '16 at 16:18

0 Answers0