title: Amazon RDS Read Replica -- Skipping Replication Errors
body: <p>I have an amazon rds instance database, and I'm using a read replica for analytics. However, every week or so the read replica crashes with a replication error.</p>
  <p>I've tried looking at the slave status and skipping replication errors as per <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql_rds_skip_repl_error.html" rel="nofollow noreferrer">this help article</a> however, I've only been able to restore it by fiddling around and creating a new read replica.</p>
  <p>This becomes problematic for several reasons because external services depend on the initial read replica.</p>
  <p>The main database is fine, but it seems some integrity errors cause the read replica to crash and not recover.</p>
  <p>Currently my read replica has these parameters:</p>
  <pre><code>Replication State: Error
  Replication Error: Error 'Cannot add or update a child row: a foreign key constraint fails.....
  </code></pre>
  <p>Is there a way I can configure this read replica to skip all errors? I just am trying to figure out how to make it more stable. Thanks!</p>