CODEWITHSUNDEEP
mysqlsqljoin
Cratylus
Cratylus

Reputation: 54084

Joining tables across multiple servers

I guess we can do database1.table1 join database2.table2 on etc. I.e. join tables in separate databases on the same server.
Is it possible to join tables across different sql servers?

Upvotes: 5

Views: 5066

Answers (1)

Dinup Kandel
Dinup Kandel

Reputation: 2505

you can use FEDERATED Storage Engine.

 The FEDERATED storage engine lets you access data from a remote
 MySQL database without using replication or cluster technology.
 Querying a local FEDERATED table   automatically pulls the data
 from the remote (federated) tables.  No data is stored on the local tables.

The site shows a good illustration

Upvotes: 3

Related Questions