Replicating Warnings

Posted by on November 8, 2011 in Database, MySQL | 0 comments

Warning Statement may not be safe to log in statement format

You may get this error if you are replicating using statement based replication and not row based replication. The fix for the most part is simply to avoid “LIMIT” clauses. Do not use limits on Updates or Deletes because the records may be stored physically different on the replicated server and if you aren’t careful, you may delete undesired data.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>