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 =

Share:
10,297
Alaa
Author by

Alaa

Senior PHP Developer and Mysql DBA

Updated on June 04, 2022

Comments

  • Alaa
    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 like

    binlog-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!!