Re: Mysql version of database link?

2009-12-07 Thread Johan De Meersman
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 sel

Re: Mysql version of database link?

2009-12-07 Thread Steve Edberg
At 12:16 PM -0600 12/7/09, Bryan Cantwell 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... You are probab

Mysql version of database link?

2009-12-07 Thread Bryan Cantwell
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.mys