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 <bcantw...@firescope.com>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=vegiv...@tuxera.be > >
