MySQL Forums :: Synchronization :: Attendance system - syncing records - best strategy?
Attendance system - syncing records - best strategy?
Posted by: Robert Stone
Date: March 31, 2012 03:34PM
We are developing an attendance system using barcode readers, php, and mysql for a university. There is one central db running on a shared MySQL server accessed over the Internet (not on the university LAN).
Because the db is not on the LAN we cannot operate in "real time" with a direct connection between each station and the central db. We are constrained to operate in "store and forward" mode where each barcode reader/computer station records attendance data and provides appropriate confirmation of valid scans to the users locally.
Once every 24 hours we need to upload the locally collected attendance records from each station to the central db and simultaneously to download any changes (new users, deactivated users, etc.) from the central db to the stations.
There are 10 locations and 14 reader/computer stations - two locations have enough traffic that more than one station is required. These stations are on the university LAN.
The question is how best should we keep the list of valid barcodes and other data synchronized with the central db?
Also what do you recommend for storing the data locally: MySQL, a spreadsheet, a flat db, or . . . ?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.