The FEDERATEDX and CONNECT storage engines
The FEDERATEDX and
CONNECT storage engines allow us to use a remote table as if it were located in the local server. Local FEDERATEDX and 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, FEDERATEDX and CONNECT may have some advantages.
MariaDB Knowledge Base explains that the initial version of FEDERATEDX has been developed ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
