Master master Mysql replication with ignore table

Discussion in 'HOWTO-Related Questions' started by wxman, May 4, 2009.

  1. wxman

    wxman New Member

    I followed the master master replication how-to's, and they have always worked. This time I needed to add a couple of table to a database that I want the replication to ignore. I thought I understood that I do it something like this:
    Code:
    replicate-do-db = dbispconfig
    replicate-ignore-table=dbispconfig.server
    replicate-ignore-table=dbispconfig.monitor_data
    I want the dbispconfig Db to be replicated, but not the two tables 'server' and 'monitor_data'. Is this the right my.cnf entry?
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Yes, that's ok.
     
  3. wxman

    wxman New Member

    After running through the setup 5 times, I realized I had a typo that was messing it up. Now it works.
     

Share This Page