Database synchronization system

I am looking for someone to develop a database synchronization system. I need to synchronize two identical databases. The network that the databases reside on could be down at any given moment once the network is up then the databases will sync up automatically. The network can be a VPN between to remote sites or a local network. Since the database sync system will primarily be via VPN size of data being transferred needs to be minimized by either compressing it or only sending necessary record changes. To add a layer of security the communication should somehow be encrypted. The idea that I had was to develop a windows application that monitors the databse. The application will then create packets based on the records changes. Those packets are zipped and encrypted and are stored in a directory of the machine hosting the database. The other database host will then grab its packets and synchronize itself. The synchronization needs to be two way and we need the application to include some type of data validation to make sure all the "packets" we're successfully received. If the packets were not receive for not successfully processed on application can send a request to the other application to resend the missing/ corrupted packet. The packet that I was I visioning would be XML, CSV or some type of flat file format. The application would also act as a utility to monitor the communication. We can also have a master daabase that would essentially store the data from multiply databases and could eventually be used to create consolidated reports. the sync system needs to e scalable where one app is syncing the data for db1, db2 and db3 into dbX. Another app can be syncing data for db4, db5 and db6 into dbY. We can then have another app syncing dbX and dbY.... I hope I am explaining myself... I would prefer if the app can detect database structure changes and automatically start syncing the new fields or tables as well. I have the database structure that my need to be modified a bit to accommodate the sync system. Update: The application that syncs the databases will reside on each machine that is hosting a database. So computer 1 hosting db1 will run a app that will send sync packets to a path. Computer 2 hosting db2 will have its own app that creates sync packets for computer 1 hosting db1. All databases are the same, structure and type. The databases are MySQL. ## Deliverables Please see attachment for architecture example. * * *This broadcast message was sent to all bidders on Tuesday Dec 20, 2011 11:30:27 AM: I have added a diagram to show what I am envisioning for the architecture. Please see attachment.