This is a discussion on HOWTO IGNORE STATEMENTS SQL REPLICATION IN MASTER within the MySQL forums, part of the Database Server Software category; --> Hi! I have Mysql 5.0.27, one master and several slaves. I would like to know if there is any ...
| |||||||
| Register | 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. |