<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-compared">
      </a>
      25.2.6 MySQL Server Using InnoDB Compared with NDB Cluster
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndb-innodb-engines.html">
       25.2.6.1 Differences Between the NDB and InnoDB Storage Engines
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndb-innodb-workloads.html">
       25.2.6.2 NDB and InnoDB Workloads
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndb-innodb-usage.html">
       25.2.6.3 NDB and InnoDB Feature Usage Summary
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045123918208">
  </a>
  <a class="indexterm" name="idm46045123916784">
  </a>
  <a class="indexterm" name="idm46045123915296">
  </a>
  <p>
   MySQL Server offers a number of choices in storage engines. Since
      both
   <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>
   can serve as transactional
      MySQL storage engines, users of MySQL Server sometimes become
      interested in NDB Cluster. They see
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   as a possible alternative or
      upgrade to the default
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   storage
      engine in MySQL. While
   <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>
   share common characteristics,
      there are differences in architecture and implementation, so that
      some existing MySQL Server applications and usage scenarios can be
      a good fit for NDB Cluster, but not all of them.
  </p>
  <p>
   In this section, we discuss and compare some characteristics of
      the
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   storage engine used by NDB
      8.4 with
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   used in
      MySQL 8.4. The next few sections provide a technical
      comparison. In many instances, decisions about when and where to
      use NDB Cluster must be made on a case-by-case basis, taking all
      factors into consideration. While it is beyond the scope of this
      documentation to provide specifics for every conceivable usage
      scenario, we also attempt to offer some very general guidance on
      the relative suitability of some common types of applications for
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   as opposed to
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   back ends.
  </p>
  <a class="indexterm" name="idm46045123898864">
  </a>
  <a class="indexterm" name="idm46045123897376">
  </a>
  <a class="indexterm" name="idm46045123895888">
  </a>
  <p>
   NDB Cluster 8.4 uses a
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   based on MySQL
      8.4, including support for
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   1.1. While it is possible to use
   <code class="literal">
    InnoDB
   </code>
   tables
      with NDB Cluster, such tables are not clustered. It is also not
      possible to use programs or libraries from an NDB Cluster 8.4
      distribution with MySQL Server 8.4, or the reverse.
  </p>
  <p>
   While it is also true that some types of common business
      applications can be run either on NDB Cluster or on MySQL Server
      (most likely using the
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   storage
      engine), there are some important architectural and implementation
      differences.
   <a class="xref" href="mysql-cluster-ndb-innodb-engines.html" title="25.2.6.1 Differences Between the NDB and InnoDB Storage Engines">
    Section 25.2.6.1, “Differences Between the NDB and InnoDB Storage Engines”
   </a>
   ,
      provides a summary of the these differences. Due to the
      differences, some usage scenarios are clearly more suitable for
      one engine or the other; see
   <a class="xref" href="mysql-cluster-ndb-innodb-workloads.html" title="25.2.6.2 NDB and InnoDB Workloads">
    Section 25.2.6.2, “NDB and InnoDB Workloads”
   </a>
   . This in turn
      has an impact on the types of applications that better suited for
      use with
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   or
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   . See
   <a class="xref" href="mysql-cluster-ndb-innodb-usage.html" title="25.2.6.3 NDB and InnoDB Feature Usage Summary">
    Section 25.2.6.3, “NDB and InnoDB Feature Usage Summary”
   </a>
   , for a comparison
      of the relative suitability of each for use in common types of
      database applications.
  </p>
  <p>
   For information about the relative characteristics of 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="memory-storage-engine.html" title="18.3 The MEMORY Storage Engine">
    <code class="literal">
     MEMORY
    </code>
   </a>
   storage engines, see
   <a class="xref" href="memory-storage-engine.html#memory-storage-engine-compared-cluster" title="When to Use MEMORY or NDB Cluster">
    When to Use MEMORY or NDB Cluster
   </a>
   .
  </p>
  <p>
   See
   <a class="xref" href="storage-engines.html" title="Chapter 18 Alternative Storage Engines">
    Chapter 18,
    <i>
     Alternative Storage Engines
    </i>
   </a>
   , for additional information
      about MySQL storage engines.
  </p>
 </div>
 <br/>
</div>
