I have some business processes I run that require pulling and comparing data from two different MySQL servers, which, by virtue of being MySQL, are unable to talk to each other. Currently this is done by loading the result sets I need from each server into Excel and doing the comparison (very, very slowly) on my desktop machine. I would prefer to nab the data from one server and load it into the other server and do all of the comparison on server.
I don't want to use FEDERATED tables to do this.
While I can access the two databases, I do not have permissions to access the servers themselves (so mysqldump'ing/INTO OUTFILE'ing the result set and FTP/sending the results that way is right out).
I can't spend any money on this, unless its coming out of my own wallet.
I'm looking for a good piece of open source, free ETL middleware that will allow me to pass a query to one server, grab the result set, and load it into a staging table in the other server with (dare I hope), the ability to automate that process to run nightly.