I'm developing an application in CakePHP, with MySQL database. A part is already working but from the beginning I need a solution to the following problem:
My application should work online, but also offline. The internet may fall, in which case the application should save and consult a local database, but when online, these two banks should be synchronized. Remembering that in the meantime, the online bank could also undergo some changes.
What is the best way to do something like this?
The application is an ordering system. It's for a mercantile. The applications with type information are registered: Value, date, date of delivery, date of payment, vendor, form of payment, etc ... And there are users, simple cakephp authentication.
What happens is that you do not always have internet, so it is necessary that the system can work saving to a local bank and then synchronizing with BD online when there is a connection.
At a second time I can think of making an application for Desktop, which will probably use this synchronization logic as well as a Mobile application. But always centralizing and distributing the information through a single web server.