Skipping MySQL replication errors
I was talking to my buddy Jeff Buchbinder and he mentioned that he recently added following to mySQL in order to reduce mySQL replication breakages
What this does is not stop replication in case following errors are encountered
Message: Table '%s' already exists
Message: Unknown table '%s'
Message: Server shutdown in progress
Message: Duplicate entry '%s' for key %d
Message: Table '%s.%s' doesn't exist
This will avoid the very common primary key collisions and "temporary tables aren't there" problems. Writing this down for posterity. Use with caution.
Marius Ducea has a post about it as well