From: Rik Wasmus
Date: May 25 2011 12:16pm
Subject: Re: Joining tables from different Instances
List-Archive: http://lists.mysql.com/mysql/225110
Message-Id: <201105251416.54298.rik@grib.nl>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit

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