Search code examples
mysqlsqlmysqlbinlog

Disable BinLogging for particular table, where to execute parameter change

To disable bin logging for a given table I understand I can use this command:

replicate-ignore-table=db_name.tbl_name

However I am unsure where I need to execute it?

Thanks,

Solution

  • You have to add it to the configuration file (my.cfg) and restart MySQL.

    This however is a SLAVE option, meaning that it should be in the config on the slave servers, and it tells them to ignore the updates to a particular table. It does not disable binary logging for that table, and other slaves can proceed the statements.