title: Cancel DELETE on MySQL REPLICATE
body: <p>I'm looking for a way to prevent DELETE statement on a MySQL replication Master/Slave.</p>
  
  <p>In my case, the Master is a live database, with fresh entries (not older than a week), and the Slave is an archive database which must contains all entries.</p>
  
  <p>I have several problems with my test:</p>
  
  <ul>
  <li>If I raise an exception in a Slave BEFORE DELETE trigger, like <code>SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'DELETE canceled';</code></li>
  </ul>
  
  <p>The SQL exception raise an error and stop my Slave.</p>
  
  <ul>
  <li>If I raise a warning, the Slave keep running but the delete is not canceled</li>
  <li>I can't modify the my.cnf of MySQL.</li>
  <li>I can't use a boolean attribute for hide on master, show on slave (Master database must be as little as possible).</li>
  </ul>
  
  <p>I rack my brain on this since a few days, and I 'm running out of ideas ...</p>