Hi Baron, In production we have three servers.
A----------------> B ---------------------C A is replicating to B. B is replicating to C A mysql-5.0.32 (Write) B mysql-5.0.32 (Read) C mysql-5.1.30 (Report Server) Complex and big queries scanning all data. *ISSUE*: If any query like 'update set col1='val', col2=null where userid=12345;' gets executed by webserver on A. (col2 is not null column) Then query gets executed and data gets changed on A and B. But it gives replication error on C. If i skip that error then data will be inconsistent. Server C will have different data than A and C. How to solve this issue. Krishna Chandra Prajapati