Sync mysql databases to master server

Question

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.)

1. I'd use one db for each store (any better approach?)
2. I use common mysql 5, should I use enterprise/cluster or another version for this?
3. 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,

Answer 1

Maybe you can use Maatkit's mk-table-sync: http://www.maatkit.org/doc/mk-table-sync.html

Cheers