If all the databases exist on the same MySQL server, there is no need to set up anything special. You can query against tables in any database, using dbName.tableName. For example:
SELECT * FROM db1.table1 JOIN db2.table2 ON (table1.id = table2.id);
If your databases are on different servers, you can either set up replication so that one server gets an update copy from the other, or you can use the FEDERATED storage engine to define a sort of symbolic link to a remote table.
Dig Deeper on Linux servers
Related Q&A from Scott Noyes
Get suggestions for choosing MySQL character sets and field collations from expert Scott Noyes. Continue Reading
A MySQL expert describes two ways that the multi-master support can be used. Continue Reading
An expert describes where to find information on detection deadlock algorithms in MySQL. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.