MySQL: Join Query Across Multiple Databases Located on Different Servers

Question

In SQL Server there is a way to join tables from multiple sql servers by using link tables.

I wonder whether is it possible to do the same? I am using PHP, does PHP provides this kind of facilities?

Answer 1

It isn't necessarily easy, nor pretty, but this article gives some solutions to your problem: http://www.linux.com/archive/feature/52390