List:Replication« Previous MessageNext Message »
From:Diego Martínez Date:November 2 2011 2:02pm
View as plain text  

I have 3 servers A, B and C

A is master, B is slave of A
C is a slave, B is master of C

if i do a delete in A, i need that the deletes replicate in B.. its ok,
work ok.

But.. in need that in B the delete don't affect the binlog and C without
deletes from B.

I try to put a set session sql_log_bin=0 or set session sql_log_bin=1 in
triggers in B (before delete value 0, after delete value 1)... not work :(

C must have all the data, no delete of any kind.

any ideas??

Thank you!

sql_log_binDiego Martínez2 Nov
  • Re: sql_log_binOleg Tsarev2 Nov
  • Re: sql_log_binJohan De Meersman2 Nov
    • Re: sql_log_binMarcus Bointon2 Nov
    • Re: sql_log_binMySQL)2 Nov
  • Re: sql_log_binRick James2 Nov
    • Re: sql_log_binMarcus Bointon2 Nov
      • Re: sql_log_binRicardo2 Nov
        • Re: sql_log_binMarcus Bointon2 Nov
          • Re: sql_log_binRicardo2 Nov
            • Re: sql_log_binDiego Martínez3 Nov