List:Replication« Previous MessageNext Message »
From:Oleg Tsarev Date:November 2 2011 2:18pm
Subject:Re: sql_log_bin
View as plain text  
You can't setup master-slave replication without binary log on master.
So, if you are replicating B to C, you can't disable sql_log_bin on B

2011/11/2 Diego Martínez <tabarem@stripped>:
> 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!
>



-- 
Oleg Tsarev, Software Engineer, Percona Inc.
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