<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="replication-features">
      </a>
      19.5.1 Replication Features and Issues
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="replication-features-auto-increment.html">
       19.5.1.1 Replication and AUTO_INCREMENT
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-blackhole.html">
       19.5.1.2 Replication and BLACKHOLE Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-charset.html">
       19.5.1.3 Replication and Character Sets
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-checksum-table.html">
       19.5.1.4 Replication and CHECKSUM TABLE
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-create-alter-drop-server.html">
       19.5.1.5 Replication of CREATE SERVER, ALTER SERVER, and DROP SERVER
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-create-if-not-exists.html">
       19.5.1.6 Replication of CREATE ... IF NOT EXISTS Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-create-select.html">
       19.5.1.7 Replication of CREATE TABLE ... SELECT Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-current-user.html">
       19.5.1.8 Replication of CURRENT_USER()
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-differing-tables.html">
       19.5.1.9 Replication with Differing Table Definitions on Source and Replica
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-directory.html">
       19.5.1.10 Replication and DIRECTORY Table Options
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-drop-if-exists.html">
       19.5.1.11 Replication of DROP ... IF EXISTS Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-floatvalues.html">
       19.5.1.12 Replication and Floating-Point Values
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-flush.html">
       19.5.1.13 Replication and FLUSH
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-functions.html">
       19.5.1.14 Replication and System Functions
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-fractional-seconds.html">
       19.5.1.15 Replication and Fractional Seconds Support
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-invoked.html">
       19.5.1.16 Replication of Invoked Features
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-json.html">
       19.5.1.17 Replication of JSON Documents
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-limit.html">
       19.5.1.18 Replication and LIMIT
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-load-data.html">
       19.5.1.19 Replication and LOAD DATA
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-max-allowed-packet.html">
       19.5.1.20 Replication and max_allowed_packet
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-memory.html">
       19.5.1.21 Replication and MEMORY Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-mysqldb.html">
       19.5.1.22 Replication of the mysql System Schema
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-optimizer.html">
       19.5.1.23 Replication and the Query Optimizer
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-partitioning.html">
       19.5.1.24 Replication and Partitioning
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-repair-table.html">
       19.5.1.25 Replication and REPAIR TABLE
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-reserved-words.html">
       19.5.1.26 Replication and Reserved Words
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-row-searches.html">
       19.5.1.27 Replication and Row Searches
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-shutdowns.html">
       19.5.1.28 Replication and Source or Replica Shutdowns
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-errors.html">
       19.5.1.29 Replica Errors During Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-sql-mode.html">
       19.5.1.30 Replication and Server SQL Mode
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-temptables.html">
       19.5.1.31 Replication and Temporary Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-timeout.html">
       19.5.1.32 Replication Retries and Timeouts
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-timezone.html">
       19.5.1.33 Replication and Time Zones
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-transaction-inconsistencies.html">
       19.5.1.34 Replication and Transaction Inconsistencies
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-transactions.html">
       19.5.1.35 Replication and Transactions
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-triggers.html">
       19.5.1.36 Replication and Triggers
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-truncate.html">
       19.5.1.37 Replication and TRUNCATE TABLE
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-user-names.html">
       19.5.1.38 Replication and User Name Length
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-variables.html">
       19.5.1.39 Replication and Variables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-features-views.html">
       19.5.1.40 Replication and Views
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045136027184">
  </a>
  <a class="indexterm" name="idm46045136025728">
  </a>
  <a class="indexterm" name="idm46045136024656">
  </a>
  <a class="indexterm" name="idm46045136023168">
  </a>
  <a class="indexterm" name="idm46045136022096">
  </a>
  <a class="indexterm" name="idm46045136021024">
  </a>
  <p>
   The following sections provide information about what is supported
      and what is not in MySQL replication, and about specific issues
      and situations that may occur when replicating certain statements.
  </p>
  <p>
   Statement-based replication depends on compatibility at the SQL
      level between the source and replica. In other words, successful
      statement-based replication requires that any SQL features used be
      supported by both the source and the replica servers. If you use a
      feature on the source server that is available only in the current
      version of MySQL, you cannot replicate to a replica that uses an
      earlier version of MySQL. Such incompatibilities can also occur
      within a release series as well as between versions.
  </p>
  <p>
   If you are planning to use statement-based replication between
      MySQL 8.4 and a previous MySQL release series, it is
      a good idea to consult the edition of the
   <em class="citetitle">
    MySQL
      Reference Manual
   </em>
   corresponding to the earlier release
      series for information regarding the replication characteristics
      of that series.
  </p>
  <p>
   With MySQL's statement-based replication, there may be issues with
      replicating stored routines or triggers. You can avoid these
      issues by using MySQL's row-based replication instead. For a
      detailed list of issues, see
   <a class="xref" href="stored-programs-logging.html" title="27.7 Stored Program Binary Logging">
    Section 27.7, “Stored Program Binary Logging”
   </a>
   . For more information
      about row-based logging and row-based replication, see
   <a class="xref" href="binary-log-formats.html" title="7.4.4.1 Binary Logging Formats">
    Section 7.4.4.1, “Binary Logging Formats”
   </a>
   , and
   <a class="xref" href="replication-formats.html" title="19.2.1 Replication Formats">
    Section 19.2.1, “Replication Formats”
   </a>
   .
  </p>
  <p>
   For additional information specific to replication and
   <code class="literal">
    InnoDB
   </code>
   , see
   <a class="xref" href="innodb-and-mysql-replication.html" title="17.19 InnoDB and MySQL Replication">
    Section 17.19, “InnoDB and MySQL Replication”
   </a>
   . For information
      relating to replication with NDB Cluster, see
   <a class="xref" href="mysql-cluster-replication.html" title="25.7 NDB Cluster Replication">
    Section 25.7, “NDB Cluster Replication”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
