<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndb-innodb-workloads">
      </a>
      25.2.6.2 NDB and InnoDB Workloads
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045123763744">
  </a>
  <a class="indexterm" name="idm46045123762240">
  </a>
  <a class="indexterm" name="idm46045123760752">
  </a>
  <a class="indexterm" name="idm46045123759264">
  </a>
  <a class="indexterm" name="idm46045123757776">
  </a>
  <a class="indexterm" name="idm46045123756288">
  </a>
  <p>
   NDB Cluster has a range of unique attributes that make it ideal
        to serve applications requiring high availability, fast
        failover, high throughput, and low latency. Due to its
        distributed architecture and multi-node implementation, NDB
        Cluster also has specific constraints that may keep some
        workloads from performing well. A number of major differences in
        behavior between the
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   and
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   storage engines with regard
        to some common types of database-driven application workloads
        are shown in the following table::
  </p>
  <div class="table">
   <a name="idm46045123751408">
   </a>
   <p class="title">
    <b>
     Table 25.2 Differences between InnoDB and NDB storage engines, common
types of data-driven application workloads.
    </b>
   </p>
   <div class="table-contents">
    <table>
     <colgroup>
      <col style="width: 33%"/>
      <col style="width: 34%"/>
      <col style="width: 33%"/>
     </colgroup>
     <thead>
      <tr>
       <th scope="col">
        Workload
       </th>
       <th scope="col">
        <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
         <code class="literal">
          InnoDB
         </code>
        </a>
       </th>
       <th scope="col">
        NDB Cluster (
        <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>
       <th scope="row">
        High-Volume OLTP Applications
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        DSS Applications (data marts, analytics)
       </th>
       <td>
        Yes
       </td>
       <td>
        Limited (Join operations across OLTP datasets not exceeding 3TB in size)
       </td>
      </tr>
      <tr>
       <th scope="row">
        Custom Applications
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        Packaged Applications
       </th>
       <td>
        Yes
       </td>
       <td>
        Limited (should be mostly primary key access); NDB Cluster
              8.4 supports foreign keys
       </td>
      </tr>
      <tr>
       <th scope="row">
        In-Network Telecoms Applications (HLR, HSS, SDP)
       </th>
       <td>
        No
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        Session Management and Caching
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        E-Commerce Applications
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        User Profile Management, AAA Protocol
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
      </tr>
     </tbody>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
