mysql query in two sever on two table

Asked Feb 23 '15 at 09:19

Active Feb 23 '15 at 09:33

Viewed 47 times

Is it possible to write select join query using MySQL in php.

SERVER 1 is 1.2.3.4 SERVER 2 is 1.5.8.3
server 1 database is customars and SERVER 2 database name is sales

I want to write a query that will select rows from Test Database on 1.2.3.4 and Test Database on a.b.c.d.

Is it possible?

edited Feb 23 '15 at 09:33

asked Feb 23 '15 at 09:19

When you say a 'cross-server select query', do you mean a JOINed query? – BenM Feb 23 '15 at 09:28
sorry brother your are correct i want to write join query. @BenM – Ashaduzaman Bhuiyan Feb 23 '15 at 09:34
You could either use `FEDERATED` tables or sync the entire database from server2 to server1 for better performance. – Brewal Feb 23 '15 at 09:40

0 Answers0