RE: querying multiple database - Tim....@biomni.com - com.mysql.lists.win32

3 messages in com.mysql.lists.win32RE: querying multiple database

From	Sent On	Attachments
Pradeep Bojan	20 Jun 2005 21:33
Tim....@biomni.com	21 Jun 2005 01:25
Tim....@biomni.com	21 Jun 2005 01:41

Subject:	RE: querying multiple database
From:	Tim....@biomni.com (Tim....@biomni.com)
Date:	06/21/2005 01:41:12 AM
List:	com.mysql.lists.win32

You may also be able create links to your remote tables via federation *and* then aggregate these tables (i.e. union them) via views. You would then have a very transparent/aggregated view of your tables which was dealt with at the MySQL level rather than in client code.

I'm not sure whether it's possible to create views of federated tables though...

Tim.

-----Original Message----- From: Tim Lloyd Sent: 21 June 2005 09:26 To: tref...@brochier.de; win...@lists.mysql.com Subject: RE: querying multiple database

Perhaps using the federated storage engine will be a technique for giving you some degree of transparency for accessing remote tables.

http://dev.mysql.com/doc/mysql/en/federated-use.html

-----Original Message----- From: tref...@brochier.de [mailto:tref...@brochier.de] Sent: 21 June 2005 07:53 To: win...@lists.mysql.com Subject: WG: querying multiple database

I know of two possibilities.

1. If you have a C or C++ program, connect to host1 and fetch result-set-1. switch the connection to host2 and fetch result-set-2. then merge the result-sets and process them

2. create a third database, copy the from host1 and host2 via mysqldump and process it. if possible, transfer only the data you want to process.

mit freundlichen Grüßen

Thomas Treffehn

Hans Brochier GmbH & Co KG

Abteilung S2 - Informationswesen Marthastraße 16 90482 Nürnberg

Fon: +49 0911-9543-355 Fax: +49 0911-9543-383 www.brochier.de

----- Weitergeleitet von Thomas Treffehn/BROCHIER/DE am 21.06.2005 08:50

-----

Pradeep Bojan

<pradeep@atheros.

com> An

win...@lists.mysql.com

21.06.2005 06:34 Kopie

Thema

querying multiple database

Hi,

I have two database in different machine. The structure of the table in both the database is the same. Only records are different. I want to query records from both the database and process the results. How can I do this ?

Database 1: ab...@host1.com Database 2: ab...@host2.com

'abcd' has 4 tables. The structure is same in both machines.

Please let me know.

Thanks, Pradeep