<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-features-blackhole">
      </a>
      19.5.1.2 Replication and BLACKHOLE Tables
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045135964960">
  </a>
  <a class="indexterm" name="idm46045135963472">
  </a>
  <a class="indexterm" name="idm46045135961984">
  </a>
  <a class="indexterm" name="idm46045135960496">
  </a>
  <p>
   The
   <a class="link" href="blackhole-storage-engine.html" title="18.6 The BLACKHOLE Storage Engine">
    <code class="literal">
     BLACKHOLE
    </code>
   </a>
   storage engine
        accepts data but discards it and does not store it. When
        performing binary logging, all inserts to such tables are always
        logged, regardless of the logging format in use. Updates and
        deletes are handled differently depending on whether statement
        based or row based logging is in use. With the statement based
        logging format, all statements affecting
   <code class="literal">
    BLACKHOLE
   </code>
   tables are logged, but their
        effects ignored. When using row-based logging, updates and
        deletes to such tables are simply skipped—they are not
        written to the binary log. A warning is logged whenever this
        occurs.
  </p>
  <p>
   For this reason we recommend when you replicate to tables using
        the
   <a class="link" href="blackhole-storage-engine.html" title="18.6 The BLACKHOLE Storage Engine">
    <code class="literal">
     BLACKHOLE
    </code>
   </a>
   storage engine that
        you have the
   <a class="link" href="replication-options-binary-log.html#sysvar_binlog_format">
    <code class="literal">
     binlog_format
    </code>
   </a>
   server variable set to
   <code class="literal">
    STATEMENT
   </code>
   , and not to
        either
   <code class="literal">
    ROW
   </code>
   or
   <code class="literal">
    MIXED
   </code>
   .
  </p>
 </div>
 <br/>
</div>
