CONNECT storage engines allow us to use a remote table as if it were located in the local server. Local
CONNECT tables act as a proxy between the client and the remote server. When the client sends a SQL statement to the tables, the tables send it to the remote server; when the remote server returns some results, the tables send the result to the client.
This is not the most advanced solution to share data between multiple servers. The
SPIDER storage engine has more features and optimizations, as explained in the next section. However,
CONNECT may have some advantages.
MariaDB Knowledge Base explains that the initial version of
FEDERATEDX has been developed ...