O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required