I need a program who will copy data from tables on the local MySQL server to the tables at the remote MySQL server on the Internet .
The program must copy data every second .
The connection to the local server will be permanent , and for the remote will be through the Internet , which means that it can be interrupted .
When there was connection interrupted, program must continue to work and attempt to re-connect to the remote server when Internet connection come back.
We will have five tables in database. ( table1, table2, table3, table4, table5 ).
Program need to put data to table : table1_b and after this he need to - > RENAME TABLE table1 TO tmp_table1, table1_b TO table1, tmp_table1 TO table_b1;
With this action we will not have problems with empty table during transfer.
I would need project in source code too.
Décerné à :
Updated Bid . Please ignore last amount. The approach was to use daemon thread to manage the transaction of operation. And also it wont stp even if an exception occurs in main thread.
15 freelance ont fait une offre moyenne de 161 $ pour ce travail
Hi. Copying data from one DB to another needs a lot of db managing and xml data transfering skills. I have a lot of experience of db working and transfering and back-up, restore.... I am a SQL expert! Thanks.
Hello sir! I will do it for you.I am new here and looking for opportunities to excel in this field.Give me a chance to prove my self. Thank you