Hi, I would like to implement a system of several databases on for each store and then have the master database stored at a sever for all company. Each store can read/write data to the local database and then synchronize the databases. Or should I enforce read/write only on master server database and then have only local read copies for each store? Or only server databases with redundancy data?
I would like to know what is pros and cons of implementing such a system based on web2py and even if this is feasible to do with web2py. Can anyone give me some pointers?