Database synchronization system

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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