On 4/27/06, P. Evans <pevansdba@stripped> wrote:
>
> Hello Listers,
> Is it possible to run a query on one mysql server to another database on
> a different server ?
> eg creating an alias in database A on server A to table B on database B on
> server B ?
>
> Like a federated nickname on db2 udb or synonym on informix ?
>
> Thanks
> Pierre
>
>
> ---------------------------------
> Yahoo! Mail goes everywhere you do. Get it on your phone.
>
Yes there is, please look at the FEDERATED Storage Engine starting from
Mysql 5.0.3, but you need the MySQL-Max Binary distribution for the engine..
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Kishore Jalleda
http://kjalleda.googlepages.com/projects
