<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="replication-configuration">
      </a>
      19.1 Configuring Replication
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="binlog-replication-configuration-overview.html">
       19.1.1 Binary Log File Position Based Replication Configuration Overview
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-howto.html">
       19.1.2 Setting Up Binary Log File Position Based Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-gtids.html">
       19.1.3 Replication with Global Transaction Identifiers
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-mode-change-online.html">
       19.1.4 Changing GTID Mode on Online Servers
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-multi-source.html">
       19.1.5 MySQL Multi-Source Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-options.html">
       19.1.6 Replication and Binary Logging Options and Variables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-administration.html">
       19.1.7 Common Replication Administration Tasks
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   This section describes how to configure the different types of
    replication available in MySQL and includes the setup and
    configuration required for a replication environment, including
    step-by-step instructions for creating a new replication
    environment. The major components of this section are:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      For a guide to setting up two or more servers for replication
        using binary log file positions,
      <a class="xref" href="replication-howto.html" title="19.1.2 Setting Up Binary Log File Position Based Replication">
       Section 19.1.2, “Setting Up Binary Log File Position Based Replication”
      </a>
      , deals with the
        configuration of the servers and provides methods for copying
        data between the source and replicas.
     </p>
    </li>
    <li class="listitem">
     <p>
      For a guide to setting up two or more servers for replication
        using GTID transactions,
      <a class="xref" href="replication-gtids.html" title="19.1.3 Replication with Global Transaction Identifiers">
       Section 19.1.3, “Replication with Global Transaction Identifiers”
      </a>
      ,
        deals with the configuration of the servers.
     </p>
    </li>
    <li class="listitem">
     <p>
      Events in the binary log are recorded using a number of formats.
        These are referred to as statement-based replication (SBR) or
        row-based replication (RBR). A third type, mixed-format
        replication (MIXED), uses SBR or RBR replication automatically
        to take advantage of the benefits of both SBR and RBR formats
        when appropriate. The different formats are discussed in
      <a class="xref" href="replication-formats.html" title="19.2.1 Replication Formats">
       Section 19.2.1, “Replication Formats”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Detailed information on the different configuration options and
        variables that apply to replication is provided in
      <a class="xref" href="replication-options.html" title="19.1.6 Replication and Binary Logging Options and Variables">
       Section 19.1.6, “Replication and Binary Logging Options and Variables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Once started, the replication process should require little
        administration or monitoring. However, for advice on common
        tasks that you may want to execute, see
      <a class="xref" href="replication-administration.html" title="19.1.7 Common Replication Administration Tasks">
       Section 19.1.7, “Common Replication Administration Tasks”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
