List:Replication« Previous MessageNext Message »
From:Rick James Date:November 2 2011 6:33pm
Subject:Re: sql_log_bin
View as plain text  
log_slave_update

On 11/2/11 7:02 AM, Diego Martínez wrote:
> Hi!,
>
> 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!

-- 
Rick James - MySQL Geek

Thread
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