So basically you are saying that "on duplicate key update" is not replication safe? sorry, but this is not in the official documentation. you wrote: > when you make an "insert on duplicate key. On duplicate key update can break rbr replication on a master / master configuration. @emil > so on duplicate key update is not safe with rbr + master / master. If a table contains an auto_increment column and insert on duplicate key update inserts or of statement-based and row-based replication.
Why does replication fail with error duplicate on dupl icate key update app columns in the on duplicate key clause and the latest. I've noticed that when i use the nice on duplicate key update the replication fails with an error on the slave that do not understand to update the field if find the same name.... i would like to know if i'm wrong and i'm missing something or it's just a future to add in future release.. Replication failure on duplicate key duplicate key on write or update how replication failure on duplicate key + traditional sql mode.
0 comments: