| List: | Replication | « Previous MessageNext Message » | |
| From: | Diego Martínez | Date: | November 2 2011 2:02pm |
| Subject: | sql_log_bin | ||
| View as plain text | |||
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!
| Thread | ||
|---|---|---|
| • sql_log_bin | Diego Martínez | 2 Nov |
| • Re: sql_log_bin | Oleg Tsarev | 2 Nov |
| • Re: sql_log_bin | Johan De Meersman | 2 Nov |
| • Re: sql_log_bin | Marcus Bointon | 2 Nov |
| • Re: sql_log_bin | MySQL) | 2 Nov |
| • Re: sql_log_bin | Rick James | 2 Nov |
| • Re: sql_log_bin | Marcus Bointon | 2 Nov |
| • Re: sql_log_bin | Ricardo | 2 Nov |
| • Re: sql_log_bin | Marcus Bointon | 2 Nov |
| • Re: sql_log_bin | Ricardo | 2 Nov |
| • Re: sql_log_bin | Diego Martínez | 3 Nov |
