<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="replication-solutions">
      </a>
      19.4 Replication Solutions
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="replication-solutions-backups.html">
       19.4.1 Using Replication for Backups
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-unexpected-replica-halt.html">
       19.4.2 Handling an Unexpected Halt of a Replica
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-rbr-monitoring.html">
       19.4.3 Monitoring Row-based Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-diffengines.html">
       19.4.4 Using Replication with Different Source and Replica Storage Engines
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-scaleout.html">
       19.4.5 Using Replication for Scale-Out
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-partitioning.html">
       19.4.6 Replicating Different Databases to Different Replicas
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-performance.html">
       19.4.7 Improving Replication Performance
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-solutions-switch.html">
       19.4.8 Switching Sources During Failover
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-asynchronous-connection-failover.html">
       19.4.9 Switching Sources and Replicas with Asynchronous Connection Failover
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-semisync.html">
       19.4.10 Semisynchronous Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replication-delayed.html">
       19.4.11 Delayed Replication
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   Replication can be used in many different environments for a range
    of purposes. This section provides general notes and advice on using
    replication for specific solution types.
  </p>
  <p>
   For information on using replication in a backup environment,
    including notes on the setup, backup procedure, and files to back
    up, see
   <a class="xref" href="replication-solutions-backups.html" title="19.4.1 Using Replication for Backups">
    Section 19.4.1, “Using Replication for Backups”
   </a>
   .
  </p>
  <p>
   For advice and tips on using different storage engines on the source
    and replica, see
   <a class="xref" href="replication-solutions-diffengines.html" title="19.4.4 Using Replication with Different Source and Replica Storage Engines">
    Section 19.4.4, “Using Replication with Different Source and Replica Storage Engines”
   </a>
   .
  </p>
  <p>
   Using replication as a scale-out solution requires some changes in
    the logic and operation of applications that use the solution. See
   <a class="xref" href="replication-solutions-scaleout.html" title="19.4.5 Using Replication for Scale-Out">
    Section 19.4.5, “Using Replication for Scale-Out”
   </a>
   .
  </p>
  <p>
   For performance or data distribution reasons, you may want to
    replicate different databases to different replicas. See
   <a class="xref" href="replication-solutions-partitioning.html" title="19.4.6 Replicating Different Databases to Different Replicas">
    Section 19.4.6, “Replicating Different Databases to Different Replicas”
   </a>
  </p>
  <p>
   As the number of replicas increases, the load on the source can
    increase and lead to reduced performance (because of the need to
    replicate the binary log to each replica). For tips on improving
    your replication performance, including using a single secondary
    server as the source, see
   <a class="xref" href="replication-solutions-performance.html" title="19.4.7 Improving Replication Performance">
    Section 19.4.7, “Improving Replication Performance”
   </a>
   .
  </p>
  <p>
   For guidance on switching sources, or converting replicas into
    sources as part of an emergency failover solution, see
   <a class="xref" href="replication-solutions-switch.html" title="19.4.8 Switching Sources During Failover">
    Section 19.4.8, “Switching Sources During Failover”
   </a>
   .
  </p>
  <p>
   For information on security measures specific to servers in a
    replication topology, see
   <a class="xref" href="replication-security.html" title="19.3 Replication Security">
    Section 19.3, “Replication Security”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
