MySQL 5.1 Reference Manual :: 14 Storage Engines and Table Types :: 14.9 The FEDERATED Storage Engine
Section Navigation [Toggle]
- 14 Storage Engines and Table Types
- 14.1 Overview of MySQL Storage Engine Architecture
- 14.2 Supported Storage Engines
- 14.3 Setting the Storage Engine
- 14.4 The MyISAM Storage Engine
- 14.5 The InnoDB Storage Engine
- 14.6 The MERGE Storage Engine
- 14.7 The MEMORY (HEAP) Storage Engine
- 14.8 The EXAMPLE Storage Engine
- 14.9 The FEDERATED Storage Engine
- 14.10 The ARCHIVE Storage Engine
- 14.11 The CSV Storage Engine
- 14.12 The BLACKHOLE Storage Engine
The FEDERATED 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.
To enable the FEDERATED storage engine if you
build MySQL from source, invoke configure with
the --with-federated-storage-engine option.
To examine the source for the FEDERATED engine,
look in the sql directory of a MySQL source
distribution.
User Comments
Add your own comment.