<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="federated-storage-engine">
      </a>
      18.8 The FEDERATED Storage Engine
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="federated-description.html">
       18.8.1 FEDERATED Storage Engine Overview
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="federated-create.html">
       18.8.2 How to Create FEDERATED Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="federated-usagenotes.html">
       18.8.3 FEDERATED Storage Engine Notes and Tips
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="federated-storage-engine-resources.html">
       18.8.4 FEDERATED Storage Engine Resources
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045147213952">
  </a>
  <a class="indexterm" name="idm46045147212864">
  </a>
  <p>
   The
   <code class="literal">
    FEDERATED
   </code>
   storage engine lets you access data
    from a remote MySQL database without using replication or cluster
    technology. Querying a local
   <code class="literal">
    FEDERATED
   </code>
   table
    automatically pulls the data from the remote (federated) tables. No
    data is stored on the local tables.
  </p>
  <p>
   To include the
   <code class="literal">
    FEDERATED
   </code>
   storage engine if you
    build MySQL from source, invoke
   <span class="command">
    <strong>
     CMake
    </strong>
   </span>
   with the
   <a class="link" href="source-configuration-options.html#option_cmake_storage_engine_options" title="Storage Engine Options">
    <code class="option">
     -DWITH_FEDERATED_STORAGE_ENGINE
    </code>
   </a>
   option.
  </p>
  <p>
   The
   <code class="literal">
    FEDERATED
   </code>
   storage engine is not enabled by
    default in the running server; to enable
   <code class="literal">
    FEDERATED
   </code>
   , you must start the MySQL server binary
    using the
   <code class="option">
    --federated
   </code>
   option.
  </p>
  <p>
   To examine the source for the
   <code class="literal">
    FEDERATED
   </code>
   engine,
    look in the
   <code class="filename">
    storage/federated
   </code>
   directory of a
    MySQL source distribution.
  </p>
 </div>
 <br/>
</div>
