Hi all, we want to transfer big amount of data from one mysql database(database1) to a remote database(database2) by using camel. the local database(database1) is isolated with the help of dmz, implemented by firewall rules. firewall rule, open and close the connection port for every 15 minutes.(the port is open for 15 minutes and will be close for next 15 minutes.) I need to transfer my data from database1 into database2 in order they have been received to database1 and without any data lost. (for example msg1,msg2,msg3,...)
I've tried using a activemq broker between two databases.and now the firewall is between database1 and broker. but when connection is interrupted for 15 minutes, some of my data will be lost. and I can not recognize them from others. So my main problem is to transfer data from a database to another database with camel. without any data lost and changing the order of messages in that 15 min disconnecting condition. If there are some other suggestions instead of using broker between databases or anything else, please let me know. any suggestions would be appreciated. -- *Maryam Eslahi*
