in mysql, have 2 different databases -- let's call them a , b.
database a resides on server server1, while database b resides on server server2.
both servers {a, b} physically close each other, on different machines , have different connection parameters (different username, different password etc).
in such case, possible perform join between table in database a, table in database b?
if so, how go it, programatically, in python? (i using python's mysqldb separately interact each 1 of databases).
try use federated storage engine.
workaround: possible use dbms retrieve data between 2 databases, example using linked servers in ms sql server (see sp_addlinkedserver stored procedure). documentation:
a linked server allows access distributed, heterogeneous queries against ole db data sources.
Comments
Post a Comment