{"id":526,"date":"2026-01-27T02:51:21","date_gmt":"2026-01-27T02:51:21","guid":{"rendered":"https:\/\/blog.gpst.net.cn:4008\/?p=526"},"modified":"2026-01-28T06:24:12","modified_gmt":"2026-01-28T06:24:12","slug":"mysql%e4%b8%adchange-replication-filter-%e8%af%ad%e5%8f%a5%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/opshub.com.cn\/?p=526","title":{"rendered":"MySQL\u4e2dCHANGE REPLICATION FILTER \u8bed\u53e5\u8be6\u89e3"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\u4ee5\u4e0b\u5217\u8868\u663e\u793a\u4e86 CHANGE REPLICATION FILTER \u9009\u9879\u53ca\u5176\u4e0e --replicate-* \u670d\u52a1\u5668\u9009\u9879\u7684\u5173\u7cfb\uff1a\n\n\n\n\n    REPLICATE_DO_DB\uff1a\u6839\u636e\u6570\u636e\u5e93\u540d\u5305\u542b\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-do-db\u3002\n\n\n\n\n    REPLICATE_IGNORE_DB\uff1a\u6839\u636e\u6570\u636e\u5e93\u540d\u6392\u9664\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-ignore-db\u3002\n\n\n\n\n    REPLICATE_DO_TABLE\uff1a\u6839\u636e\u8868\u540d\u5305\u542b\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-do-table\u3002\n\n\n\n\n    REPLICATE_IGNORE_TABLE\uff1a\u6839\u636e\u8868\u540d\u6392\u9664\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-ignore-table\u3002\n\n\n\n\n    REPLICATE_WILD_DO_TABLE\uff1a\u6839\u636e\u901a\u914d\u7b26\u5339\u914d\u8868\u540d\u5305\u542b\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-wild-do-table\u3002\n\n\n\n\n    REPLICATE_WILD_IGNORE_TABLE\uff1a\u6839\u636e\u901a\u914d\u7b26\u5339\u914d\u8868\u540d\u6392\u9664\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-wild-ignore-table\u3002\n\n\n\n\n    REPLICATE_REWRITE_DB\uff1a\u5728\u590d\u5236\u540e\u5728\u526f\u672c\u4e0a\u7528\u65b0\u540d\u5b57\u66ff\u6362\u6e90\u4e0a\u6307\u5b9a\u7684\u6570\u636e\u5e93\u540d\u8fdb\u884c\u66f4\u65b0\u3002\u76f8\u5f53\u4e8e --replicate-rewrite-db\u3002<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt;stop slave;\n&gt;change replication filter replicate_wild_ignore_table=('tioaeha_uav.tioaeha_uav_work_info%');\n&gt;start slave;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=526"}],"version-history":[{"count":2,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/526\/revisions"}],"predecessor-version":[{"id":600,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/526\/revisions\/600"}],"wp:attachment":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}