title: MySQL -- Joins Between Databases On Different Servers Using Python?
body: <p>In <code>MySQL</code>, I have two different databases -- let's call them <code>A</code> and <code>B</code>.</p>
  
  <p>Database <code>A</code> resides on server <code>server1</code>, while database <code>B</code> resides on server <code>server2</code>.</p>
  
  <p>Both servers {<code>A</code>, <code>B</code>} are <em>physically close to each other</em>, but are on different machines and have different connection parameters (different username, different password etc).</p>
  
  <p>In such a case, is it possible to perform a join between a table that is in database <code>A</code>, to a table that is in database <code>B</code>?</p>
  
  <p>If so, how do I go about it, programatically, in <code>python</code>? (I am using <code>python</code>'s <code>MySQLDB</code> to separately interact with each one of the databases).</p>