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.
