It is a storage engine that accesses data in tables of remote databases rather than in local tables.The FEDERATED storage engine is available beginning with MySQL 5.0.3.
This storage engine enables data to be accessed from a remote MySQL database on a local server without using replication or cluster technology. When using a FEDERATED table, queries on the local server are automatically executed on the remote (federated) tables. No data is stored on the local tables.