MySQL Cross Server Select Query
how about using federated tables on one of the servers? create the federated tables based on the remote tables you will use in the query and just run your query as if your database was all local. example below from MySQL site The procedure for using FEDERATED tables is very simple. Normally, you have two … Read more