CODEWITHSUNDEEP
mysqldrupalreplicationbinary-log
Alaa
Alaa

Reputation: 4611

how to exclude some tables from being binlogged in mysql?

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

Upvotes: 4

Views: 12788

Answers (4)

PLoginoff
PLoginoff

Reputation: 11

I found a feature request on MariaDB's issue tracker. So, this is a feature that many have dreamed about since 2016. You can vote for it.

https://jira.mariadb.org/browse/MDEV-9353

Upvotes: 0

Ankit Singhal
Ankit Singhal

Reputation: 834

You can try this option:-

SET @@session.sql_log_bin=0;

LOAD DATA INFILE 'file_name' --other LOAD DATA INFILE options ;

SET @@session.sql_log_bin=1;

Upvotes: 0

Rodo
Rodo

Reputation: 1588

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 =

Upvotes: 1

Neo
Neo

Reputation: 5463

mysql has parameters: 

replicate-ignore-table=db_name.tbl_name
replicate-wild-ignore-table=db_name.%

u can try it

Upvotes: 1

Related Questions