MySQL equivalent of PostgreSQL's dblink module?

Question

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?

Answer 1

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.

Answer 2

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