I have a question, how to INNER JOIN two tables between two Database server...
If INNER JOIN in one server is okay, but how about two ?
Any idea ?...
Asked
Active
Viewed 529 times
-2
-
Not sure if this is possible in pure SQL. – Kao Dec 10 '12 at 10:15
-
Have you tried this: http://stackoverflow.com/questions/2132654/querying-multiple-databases-at-once ? – Leandro Barreto Dec 10 '12 at 10:19
-
@Leandro Barreto - That question is for fixing Multiple database and not for multiple/two database SERVER ... – Michael Antonius Dec 10 '12 at 10:22
-
Go read up on the federated engine for mysql. – symcbean Dec 10 '12 at 11:25
2 Answers
0
You can join tables from multiple servers you can do it using Spider storage engine check this link http://spiderformysql.com/product.html
Pankaj Khairnar
- 3,028
- 3
- 25
- 34
-
how you are going to query in PHP? you must have to use mysql and this is the best way to query multiple databases located on different servers – Pankaj Khairnar Dec 10 '12 at 17:14
0
You can’t use a standard InnoDB storage engine for your use case. The best way to accommodate your case in the database layer, you can use Spider Storage Engine for MySQL. Otherwise, you need to JOIN in the application layer or use the data warehouse mechanism to do that.
Severalnines
- 106
- 5