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

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.