All geek questions in one place

MySQL equivalent of PostgreSQL dblink module?

The PostgreSQL dblink module allows you to write SQL statements that execute other SQL queries for the remote PostgreSQL database.

Is there a PostgreSQL dblink equivalent for MySQL?

+3
source share
3 answers

Not really.

However, there is a storage mechanism FEDERATED(available since 5.0.3) that can be used in certain situations to emulate this behavior. This is, (very simple) a VIEWfor a remote table.

There is a detailed explanation, as well as examples of its MySQL manual pages .

+1
source

, MySQL Proxy. dblink, , , , dblink .

+1

No. This is not possible with MySQL. Closest you can use replication to replicate the required tables from the "remote" database to the slave slave. For more information, see. In the documentation .

0
source

Source: https://habr.com/ru/post/1713596/

More articles:


All Articles