This is a discussion on HOWTO IGNORE STATEMENTS SQL REPLICATION IN MASTER within the MySQL Database forums, part of the Database Forums category; Hi! I have Mysql 5.0.27, one master and several slaves. I would like to know if there is ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi!
I have Mysql 5.0.27, one master and several slaves. I would like to know if there is any option to ignore SQL statements executed in master, affecting certain tables not to write on the files BINLOG. I know that if I execute in master, for example: $mysql bbdd -e "SET SQL_LOG_BIN=0;UPDATE Customer SET CODE=1 WHERE ID=2;SET SQL_LOG_BIN=1;" this statement will not be written in the BINLOG in master, but I want an option like "--replicate-ignore-table=Customer", but this option is only for slave not to master. Thanks very much. |