A system or script to automatically synchronise the MySQL database on several remote Linux servers with a master copy on a single Linux server over the internet

Cancelled Posted Mar 14, 2008 Paid on delivery
Cancelled Paid on delivery

We run several VoIP telephone servers spread over the United Kingdom. The call information is stored in a single table in a MySQL database on each of the servers. We would like a script that we can schedule that will synchronise the contents of each table onto a copy in a MySQL database server based in our office.

## Deliverables

We run several VoIP telephone servers spread over the United Kingdom. The call information is stored in a single table in a MySQL database on each of the servers. We would like a script that we can schedule that will synchronise the contents of each table onto a copy in a MySQL database server based in our office.

The data transfer has to be secure.

The tables are quite large therefore we’d like only the new data to be transferred each time the script is run, not the entire table.

Each remote server will have a separate table on the local server. For example, the table might be called tbl_calls on each of the remote sites but we’d need the copies to be called tbl_calls_exeter, tbl_calls_london, tbl_calls_edinburgh on the server at our office location.

We do not want any of the remote servers to have call data relating to any other (remote) server.

As an addition to the project we’d like any data that has been successfully synchronised **and is more than six months old** to be deleted from the remote servers **but not from the local one.

**SSH access will be given to the local server and one or more of the remote servers. Completion of the project will be when the remote server syncs the table data that has changed with the local server on a scheduled basis.

Engineering Linux MySQL PHP Project Management Software Architecture Software Testing

Project ID: #3797131

About the project

14 proposals Remote project Active Apr 11, 2008

14 freelancers are bidding on average $131 for this job

meral

See private message.

$102 USD in 14 days
(153 Reviews)
7.9
yunusyb

See private message.

$114.75 USD in 14 days
(179 Reviews)
6.3
isurugiu

See private message.

$170 USD in 14 days
(223 Reviews)
6.3
jawadh

See private message.

$160.65 USD in 14 days
(78 Reviews)
5.9
khabros

See private message.

$127.5 USD in 14 days
(14 Reviews)
5.3
teresk

See private message.

$170 USD in 14 days
(8 Reviews)
3.5
techcom

See private message.

$85 USD in 14 days
(10 Reviews)
3.4
reedoxvw

See private message.

$170 USD in 14 days
(15 Reviews)
3.2
bernardlok

See private message.

$127.5 USD in 14 days
(3 Reviews)
1.1
90st

See private message.

$102 USD in 14 days
(0 Reviews)
0.0
walidzohair

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
jeanclaudemagras

See private message.

$85 USD in 14 days
(1 Review)
0.0
vw519400vw

See private message.

$170 USD in 14 days
(0 Reviews)
0.0
inderpreeta

See private message.

$170 USD in 14 days
(1 Review)
0.0