I'm thinking two changes may make sense:
1) use insert ... ON DUPLICATE KEY UPDATE col1=VALUES(col1), col2=VALUES(col2), ... 2) seems "set FOREIGN_KEY_CHECKS=0" should always be set. The goal is to not change the master just replicate what is already there
I'm thinking two changes may make sense:
1) use insert ... ON DUPLICATE KEY UPDATE col1=VALUES(col1), col2=VALUES(col2), ... KEY_CHECKS= 0" should always be set. The goal is to not change the master just replicate what is already there
2) seems "set FOREIGN_