MySQL: Multiple select from some servers in one query?

Question

Can I select data from some servers in one query?

MySQL:

server1:
database:
users

server2
database:
users

serverN
database
users

Is it possible to select records from users tables from all servers with one query?

Is `users` a table or a database? You are confusing us. – ypercubeᵀᴹ Feb 02 '13 at 14:33 — ypercubeᵀᴹ, Feb 02 '13 at 14:33
database - DB name. Users - table name. – Eugene Feb 02 '13 at 14:34 — Eugene, Feb 02 '13 at 14:34
http://stackoverflow.com/a/5371062/1073631 – sgeddes Feb 02 '13 at 14:37 — sgeddes, Feb 02 '13 at 14:37

score 1 · Accepted Answer · answered Feb 02 '13 at 14:36

1

No you can't. you can only use select on the same server you connected to.

answered Feb 02 '13 at 14:36

Orel Eraki

11,940
3
28
36

score 0 · Answer 2 · edited May 23 '17 at 11:56

0

I am not sure but it is often quoted that database engines aren't designed for this purpose. Here's something related to it multiple_db_across_multiple_servers may be this answers your question to some limit.

edited May 23 '17 at 11:56

Community

1
1

answered Feb 02 '13 at 14:38

ro ko

2,906
3
37
58

MySQL: Multiple select from some servers in one query?

2 Answers2