如何创建链接服务器MySQL [英] How to create linked server MySQL

问题描述

是否可以为SQL Server的链接服务器之类的功能创建/配置MySQL?

Is it possible create/configure MySQL for functionality like SQL Server's Linked Server?

如果是，请您告诉我如何?我正在使用MySQL 5.5.

If yes, would you please tell me how? I'm using MySQL 5.5.

推荐答案

MySQL的 FEDERATED引擎提供的功能类似于SQL Server的链接服务器(和Oracle的dblink)功能，但不支持连接到除MySQL之外的其他供应商.从这个问题尚不清楚，是否需要功能来连接到除MySQL以外的供应商.

MySQL's FEDERATED engine provides functionality similar to SQL Server's Linked Server (and Oracle's dblink) functionality, but doesn't support connecting to vendors other than MySQL. It's not clear from the question if you need the functionality to connect to vendors other than MySQL.

您可能想研究 MySQL代理.这与链接服务器/dblink的体系结构不匹配，但是您可能可以解决使用链接服务器/dblink解决的类似问题.

You might want to look into MySQL Proxy. This doesn't match the architecture of Linked Servers/dblink, but you can probably solve a similar set of problems that you would use Linked Servers/dblink to solve.

这篇关于如何创建链接服务器MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！