MySql one query from two servers

[abou.hmed]

Hello
I have two server each one contain a different database, i want to make one query and join this two database together
is there any way for this?
thank you

[chazzy]

two separate servers? no. you'd have to use replication to make them seem like one server, but is it worth it?

[abou.hmed]

i dnt want to make replication, as i have different structure for this two database

[chazzy]

The replication approach is the closest thing that mysql has to a database link. but really, if they're two completely separate, distinct items, why would you want to query for them both at the same time? any reduction in network bandwidth is going to be offset by the cost of having to parse the response to this weird message.

[abou.hmed]

i have two different database, once contain read and write for the public, where i make some calculation depending in the application and some other points, i was trying to find a way to move the latest calculated data to the other database which is on seperated server, if there are no way using mysql i guess i will use php

[chazzy]

Hi. Just as a comment, the problem you describe in #5 sounds nothing like the problem you describe in #1.

1. Using replication, you could have access to both databases on a single server. If this still isn't an option,

2. I would recommend a perl script. The bottom line is that you need to have 2 connection handles, 1 for each server involved.