Can I join between two MySQL tables stores on separate machines?

Question

I have a relatively light query that needs information from a local MySQL table along with another MySQL table which is stored on a physically separate machine (on the same network). I'm keen to avoid setting up replication just to facilitate this light query that only needs executed once a day.

Is there any way that I can join with a table on a remote machine using one query? Or run a SELECT INTO into a local table.

---

Notes

• I'm using C# & .NET 4.

Answer 1

This can be done by using the FEDERATED storage engine for the remote table. Find out more.