multiple databases staying in real-time sync
Posted on 2006-10-23
I'm looking for opinions/suggestions on a project I'm working on. I have four stations/PC's setup which will be used to submit user data from a form to a mysql database housed locally on each station. The reason for housing locally is each station is independent of each other if for some reason hardware/software failure occurs. My problem is: I need to keep all submitted data updated on all 4 stations so that I do not get repeat data entered from two different workstations. I'm thinking some type of automated sync, or sync every second, or sync per transaction. Any opinions/suggestions on the best way to approach this is greatly appreciated.