how to exclude some tables from being binlogged in mysql?

mysql drupal replication binary-log
Alaa picture Alaa · Jun 8, 2011 · Viewed 10.3k times · Source

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

Answer

neocanable picture neocanable · Jun 8, 2011

mysql has parameters: 

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

u can try it

Related questions

Error #1046 - No database selected SQL import on XAMPP

I am trying to import the SQL database from my Drupal production site into a sandbox testing site on my local machine. I currently use XAMPP on my machine here at work. I have downloaded my db aipiadxxm_if9DHdr.…

Read More
What is Drupal's default password encryption method?

I am trying to figure out what is the security that Drupal 6/7 uses by default to store passwords. Is it MD5, AES, SHA? I have been unable to find anything.

Read More
What does max_connections really mean?

I'm trying to set the ideal performance setup for MySQL and resources needed on a shared hosting. My question is, what does max_connections really mean? Is it the number of unique concurrent requests made to the server? So if …

Read More