List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:December 7 2009 6:46pm
Subject:Re: Mysql version of database link?
View as plain text  
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
>
>

Thread
Mysql version of database link?Bryan Cantwell7 Dec
  • Re: Mysql version of database link?Steve Edberg7 Dec
  • Re: Mysql version of database link?Johan De Meersman7 Dec