Joining tables from different Instances

--0016e6db2a8f024c2204a4185149
Content-Type: text/plain; charset=ISO-8859-1

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?

--0016e6db2a8f024c2204a4185149--

Re: Joining tables from different Instances

--------------enig5C8B5FB667744E996E9ED555
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



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

in theory
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-eng ine.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


--------------enig5C8B5FB667744E996E9ED555
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3c8LUACgkQhmBjz394AnnQIgCglF+m6oYeciTOTdPANftT ir22
mGUAnjlpg4GPGG3LqCWbiRBdDTvnAN4i
=KfC9
-----END PGP SIGNATURE-----

--------------enig5C8B5FB667744E996E9ED555--

Re: Joining tables from different Instances

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=gcdmg-mysql-2@m.gmane.org