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

Posted by CuriousCoder on Stack Overflow See other posts from Stack Overflow or by CuriousCoder
Published on 2010-05-20T09:10:10Z Indexed on 2010/05/20 9:20 UTC
Read the original article Hit count: 227

Filed under:

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.

© Stack Overflow or respective owner

Related posts about mysql