14.11 The FEDERATED Storage Engine

14.11.1 FEDERATED Storage Engine Overview
14.11.2 How to Create FEDERATED Tables
14.11.3 FEDERATED Storage Engine Notes and Tips
14.11.4 FEDERATED Storage Engine Resources

The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table 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 the --with-federated-storage-engine option.

Beginning with MySQL 5.1.26, the FEDERATED storage engine is not enabled by default in the running server; to enable FEDERATED, you must start the MySQL server binary using the --federated option.

To examine the source for the FEDERATED engine, look in the storage/federated directory of a MySQL source distribution.