Database synchronization system

已完成 已发布的 Dec 19, 2011 货到付款
已完成 货到付款

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.

MySQL PHP 软件构架 软件测试 系统管理 网络主机 网站管理 网站测试

项目ID: #3761487

关于项目

8个方案 远程项目 活跃的Jan 3, 2012

授予:

jared23

See private message.

$1300.5 USD 在180天内
(251条评论)
7.5

有8名威客正在参与此工作的竞标,均价$1398/小时

zestinfotech

See private message.

$1700 USD 在180天内
(31条评论)
7.1
theclientisking

See private message.

$1275 USD 在180天内
(82条评论)
6.4
Eliteprog

See private message.

$1700 USD 在180天内
(31条评论)
6.2
tvoodoo

See private message.

$1000.45 USD 在180天内
(85条评论)
5.6
devl

See private message.

$1207 USD 在180天内
(48条评论)
5.6
hassana19

See private message.

$1400.8 USD 在180天内
(23条评论)
4.4
pradeepgmishrasl

See private message.

$1600.55 USD 在180天内
(0条评论)
0.0