how to exclude some tables from being binlogged in mysql?
10,297
Solution 1
mysql has parameters:
replicate-ignore-table=db_name.tbl_name
replicate-wild-ignore-table=db_name.%
u can try it
Solution 2
Unless someone finds something better. The only way I could find, a part from using "SET SQL_LOG_BIN = 0" was to move the table into another database and use the binlog-ignore-db =
Comments
-
Alaa almost 2 years
I need to exclude some files from being logged in the binary log to avoid wasting my network bandwidth and time on replication of caching tables.
i know there is[mysqld] binlog-ignore-db=DB_TO_BE_SKIPPED
how can i do so for specific tables (Caching tables)??
is there something likebinlog-ignore-table=tbl_boost_cache
** Edit **
i am using drupal, and there is a functional defect with boost caching in drupal. the binlog files get large exponentially. (sometimes about 100MB/minute!!) and the only one to avoid such cases is to stop logging for these tables Thanks!!