FEDERATED storage engine lets you access data
from a remote MySQL database without using replication or cluster
technology. Querying a local
automatically pulls the data from the remote (federated) tables. No
data is stored on the local tables.
To include the
FEDERATED storage engine if you
build MySQL from source, invoke configure with
Beginning with MySQL 5.1.26, the
storage engine is not enabled by default in the running server; to
FEDERATED, you must start the MySQL server
binary using the
To examine the source for the
look in the
storage/federated directory of a
MySQL source distribution.