FEDERATED

The FEDERATED storage engine allows you to access data from a remote MySQL database without using replication or cluster technology. No data is stored on the local tables. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables.
To enable FEDERATED, you must start the MySQL server binary using the --federated option.