Re: Joining tables from different Instances

2011-05-25 Thread Rik Wasmus 
On 2011-05-25 13:50:32 Ramesh wrote:
> I have a different schemas in different instances.
> 
>  I would like to join the tables in different instances for the required
> result.
> 
> Is it possible?
> 
> Example
> =
> 
> Server I - table_1a, table_2b
> Server II - table_2a,table_2b.
> 
> I want to join the table_1a with table_2b.

Options as far as I can see it:
1. Use a FEDERATED table (not advisable, excrutiatingly slow and inefficient).
2. Replicate table_2b from Server II to Server I if possible, and allow for a 
small delay, and just run the query locally on Server I
-- 
Rik Wasmus

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Joining tables from different Instances

2011-05-25 Thread Reindl Harald 


Am 25.05.2011 13:50, schrieb Ramesh:
> Hi
> 
> I have a different schemas in different instances.
> 
>  I would like to join the tables in different instances for the required
> result.
> 
> Is it possible?
> 
> Example
> =
> 
> Server I - table_1a, table_2b
> Server II - table_2a,table_2b.
> 
> I want to join the table_1a with table_2b.
> 
> Is is possible?

in theory
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html

but no one want to do this really because if you need data on a server
you should have them on this machine or use replication which can
replicate only selected tables/databases if you need read-only access
for your query



signature.asc
Description: OpenPGP digital signature

Joining tables from different Instances

2011-05-25 Thread Ramesh 
Hi

I have a different schemas in different instances.

 I would like to join the tables in different instances for the required
result.

Is it possible?

Example
=

Server I - table_1a, table_2b
Server II - table_2a,table_2b.

I want to join the table_1a with table_2b.

Is is possible?