<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndb-innodb-usage">
      </a>
      25.2.6.3 NDB and InnoDB Feature Usage Summary
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045123713984">
  </a>
  <a class="indexterm" name="idm46045123712480">
  </a>
  <a class="indexterm" name="idm46045123710992">
  </a>
  <a class="indexterm" name="idm46045123709504">
  </a>
  <a class="indexterm" name="idm46045123708016">
  </a>
  <a class="indexterm" name="idm46045123706512">
  </a>
  <a class="indexterm" name="idm46045123705008">
  </a>
  <p>
   When comparing application feature requirements to the
        capabilities of
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   with
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   , some are clearly more
        compatible with one storage engine than the other.
  </p>
  <p>
   The following table lists supported application features
        according to the storage engine to which each feature is
        typically better suited.
  </p>
  <div class="table">
   <a name="idm46045123699920">
   </a>
   <p class="title">
    <b>
     Table 25.3 Supported application features according to the
          storage engine to which each feature is typically better
suited
    </b>
   </p>
   <div class="table-contents">
    <table>
     <colgroup>
      <col style="width: 50%"/>
      <col style="width: 50%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Preferred application requirements for
        <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
         <code class="literal">
          InnoDB
         </code>
        </a>
       </th>
       <th>
        Preferred application requirements for
        <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
         <code class="literal">
          NDB
         </code>
        </a>
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            Foreign keys
           </p>
           <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
            <div class="admon-title">
             Note
            </div>
            <p>
             NDB Cluster 8.4 supports foreign keys
            </p>
           </div>
          </li>
          <li class="listitem">
           <p>
            Full table scans
           </p>
          </li>
          <li class="listitem">
           <p>
            Very large databases, rows, or transactions
           </p>
          </li>
          <li class="listitem">
           <p>
            Transactions other than
            <a class="link" href="innodb-transaction-isolation-levels.html#isolevel_read-committed">
             <code class="literal">
              READ COMMITTED
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            Write scaling
           </p>
          </li>
          <li class="listitem">
           <p>
            99.999% uptime
           </p>
          </li>
          <li class="listitem">
           <p>
            Online addition of nodes and online schema
                    operations
           </p>
          </li>
          <li class="listitem">
           <p>
            Multiple SQL and NoSQL APIs (see
            <a class="ulink" href="/doc/ndbapi/en/mysql-cluster-api-overview.html" target="_top">
             NDB Cluster APIs: Overview and Concepts
            </a>
            )
           </p>
          </li>
          <li class="listitem">
           <p>
            Real-time performance
           </p>
          </li>
          <li class="listitem">
           <p>
            Limited use of
            <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
             <code class="literal">
              BLOB
             </code>
            </a>
            columns
           </p>
          </li>
          <li class="listitem">
           <p>
            Foreign keys are supported, although their use may
                    have an impact on performance at high throughput
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
     </tbody>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
