MySQL replication with binlog update.
We have two MySQL cluster
Cluster 1
Cluster 2
Cluster 1 is a master for Cluster 2 then from Cluster 2 we replicate to MySQL Enterprise.
Application is connected to cluster 1
In application we are using query like
INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1;
This insert is populated correctly to Cluster 2, but from cluster 2 to Enterprise instance it is causing an error – duplicated entry. An update is not executed.