I have a stream of data arrivinng in one server say every minute or so where they are parsed. Parsing is very fast
and at the end of parsing some files have been written. While I am waiting for the
new data, I want to LOAD these files in a database
on a different machine. Sure, I can ftp them there and run LOAD DATA infile there. Is it possible to do a LOAD DATA INFILE on the remote machine and is it faster than doing the ftp first then load data infile?
Thanks, svar
and at the end of parsing some files have been written. While I am waiting for the
new data, I want to LOAD these files in a database
on a different machine. Sure, I can ftp them there and run LOAD DATA infile there. Is it possible to do a LOAD DATA INFILE on the remote machine and is it faster than doing the ftp first then load data infile?
Thanks, svar