通過replicate-wild-do-table解決replicate-do-db的一些問題

• --replicate-wild-do-table=db_name.tbl_name

  Command-Line Format	--replicate-wild-do-table=name
  Permitted Values	Type	string

  Creates a replication filter by telling the slave thread to restrict replication to statements where any of the updated tables match the specified database and table name patterns. Patterns can contain the “%” and “_” wildcard characters, which have the same meaning as for the LIKE pattern-matching operator. To specify more than one table, use this option multiple times, once for each table. This works for cross-database updates. 

  通過告訴從線程創(chuàng)建一個(gè)復(fù)制篩選器來約束任何與指定的數(shù)據(jù)庫和表名稱相匹配的更新表相關(guān)的語句。模式可以包含“%”和“_”通配符，它與模式匹配算法類似。要指定多個(gè)表，使用此選項(xiàng)多次，每個(gè)表一次。這是跨數(shù)據(jù)庫更新的工作。

  跨數(shù)據(jù)庫這一點(diǎn)是重點(diǎn)，不像replicate-do-db那樣，其他的庫操作，就不會(huì)同步設(shè)定的庫。這個(gè)參數(shù)，只要涉及到的該表，就會(huì)同步。
  

  
  

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

  Command-Line Format	--replicate-wild-ignore-table=name
  Permitted Values	Type	string

  Creates a replication filter which keeps the slave thread from replicating a statement in which any table matches the given wildcard pattern. To specify more than one table to ignore, use this option multiple times, once for each table. This works for cross-database updates.