I have autossh setup to make and reestablish a tunnel with a remote host. The application is MySQL.
There is a script which runs which checks local and remote tables and if there is a mismatch, it will pull new entries from the remote table into the local table.
My issue is, it also pulls blobs. Very large blobs. During blob transfer it will hang and stop transferring data. The only way to fix it is to kill the job and re-establish and restart the transfer.
Does anyone have any ideas of how better to improve this and make it transfer the blobs properly?
The data size is about 3 gigs. The connection is gigabit on our end.