The FEDERATED engine is what you're looking for, but it probably doesn't
quite do what you expect. Full documentation is at
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html .
The major gotcha - in my opinion - is that it doesn't actually use indices.
If you only need to run selects on data that's been inserted remotely, you
might be better served by replicating the remote tables you need to your
local server.
On Mon, Dec 7, 2009 at 7:16 PM, Bryan Cantwell <bcantwell@stripped>wrote:
> Does anyone have a suggestion on how a database link (like in Oracle) could
> be established between two Mysql databases on different servers?
> It would be awesome if I could write sql that will query both databases in
> one query...
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/mysql?unsub=1>
>

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.