Splitting Queries

[aleks_felipe]

hi, we're working on a project where different mysql databases are stored on separate computers.
is there a way to breakdown queries such as join statements into queries concerning only a particular database?

For example, a query with table1 JOIN table2 (table1 and table2 are from different databases), how are we be able to do this?

Any help would be greatly appreciated.

[lilleman]

Hi,

I'm not 100% sure, but I think you can do something like this:

SELECT * FROM db_1.table_a as a
  INNER JOIN db_2.table_b as b ON b.field = a.field

Edit:

I just realized that my query will probably only work when the databases are located on the same server.

[aleks_felipe]

thanks lilleman. but you're right. What we need is to query different databases on different servers.

Again, more help would be greatly appreciated.

[aleks_felipe]

it seems that no one is replying to my thread. does this mean that what we're trying to do is near impossible?

please, we really need help..

[ghurtado]

I believe that unless you have the two Databases in the same server, so that both can be accessed through the same connection, and thus be used in the same query (as lilleman stated), you will not be able to query two servers in one query. Your only solution is to set up a way to synchronize the servers so that at least one of them always contains all the tables you need to query from.