The FEDERATED Storage Engine is a legacy storage engine no longer being supported. A fork, FederatedX is being actively maintained. Since MariaDB 10.0, the CONNECT storage engine also permits accessing a remote database via MySQL or ODBC connection (table types: MYSQL, ODBC).
The FEDERATED Storage Engine was originally designed to let one access data remotely without using clustering or replication, and perform local queries that automatically access the remote data.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/federated-storage-engine/