--replicate-wild-do-table=
db_name.tbl_name
荊州ssl適用于網(wǎng)站、小程序/APP、API接口等需要進(jìn)行數(shù)據(jù)傳輸應(yīng)用場景,ssl證書未來市場廣闊!成為創(chuàng)新互聯(lián)的ssl證書銷售渠道,可以享受市場價格4-6折優(yōu)惠!如果有意向歡迎電話聯(lián)系或者加微信:18982081108(備注:SSL證書合作)期待與您的合作!
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)建一個復(fù)制篩選器來約束任何與指定的數(shù)據(jù)庫和表名稱相匹配的更新表相關(guān)的語句。模式可以包含“%”和“_”通配符,它與模式匹配算法類似。要指定多個表,使用此選項多次,每個表一次。這是跨數(shù)據(jù)庫更新的工作。
跨數(shù)據(jù)庫這一點是重點,不像replicate-do-db那樣,其他的庫操作,就不會同步設(shè)定的庫。這個參數(shù),只要涉及到的該表,就會同步。
--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.