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(repost)

Completed Posted Apr 15, 2008 Paid on delivery
Completed 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.** The tables on each of the remote servers contain a time/date field with the time and date of that entry to help with this process.

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.

Finally, a warning email must be sent by the local server to a preset email address if it does not receive data from any of the remote servers after, say, 3 days. The email must detail which of the servers has failed to respond and how long it has been since the last update.

Engineering Linux MySQL PHP Project Management Software Architecture Software Testing

Project ID: #3872070

About the project

9 proposals Remote project Active Apr 17, 2008

Awarded to:

oscommercevw

See private message.

$170 USD in 14 days
(137 Reviews)
5.6

9 freelancers are bidding on average $156 for this job

isurugiu

See private message.

$170 USD in 14 days
(224 Reviews)
6.3
wheelronix

See private message.

$170 USD in 14 days
(54 Reviews)
5.8
hinoglu

See private message.

$144.5 USD in 14 days
(39 Reviews)
5.5
bocodevw

See private message.

$170 USD in 14 days
(75 Reviews)
6.0
nxsoft

See private message.

$127.5 USD in 14 days
(1 Review)
2.5
cybersagetechvw

See private message.

$153 USD in 14 days
(3 Reviews)
2.6
CodeExplode

See private message.

$127.5 USD in 14 days
(0 Reviews)
0.0
heliocampos

See private message.

$170 USD in 14 days
(0 Reviews)
0.0