I need to do a database synchronization from each store to central store. Each store employee should be able to do this sync once or twice a day, due ISPs unavailability here. Owner would check at night, the movements from each store (sales, stock, etc.)
- I'd use one db for each store (any better approach?)
- I use common mysql 5, should I use enterprise/cluster or another version for this?
- Any guides / tutorials?
Software is being developed with a php/mysql framework in lamp environment, and we were not given/assigned budget for licensing other software. Is there still any possibilities?
Thanks a lot in advance,