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
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
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