CODEWITHSUNDEEP
mysqlpostgresqldblink
user145420
user145420

Reputation: 31

MySQL equivalent of PostgreSQL's dblink module?

PostgreSQL's dblink module allows for SQL statements to be written that execute other SQL statements against a remote PostgreSQL database.

Is there an equivalent to PostgreSQL's dblink for MySQL?

Upvotes: 3

Views: 2512

Answers (3)

Bill Karwin
Bill Karwin

Reputation: 562563

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

Upvotes: 1

jason
jason

Reputation: 8918

Not exactly.

There is, however the FEDERATED storage engine (available since 5.0.3), which can be used in certain situations to emulate this behaviour. It is, (put very simply) a VIEW for a remote table.

There is an in-depth explanation, along with examples on its MySQL manual page(s).

Upvotes: 1

hobodave
hobodave

Reputation: 29303

No. This is not possible with MySQL. The closest you can come is to use replication to replicate the tables you need from the "remote" database down to the slave you are querying on. See the documentation for more details.

Upvotes: 1

Related Questions