如何创建链接服务器 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 代理.这与 Linked Servers/dblink 的架构不匹配，但是您可能可以解决使用 Linked Servers/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屋！