{"id":759,"date":"2026-02-18T21:15:02","date_gmt":"2026-02-18T13:15:02","guid":{"rendered":"http:\/\/47.100.165.17\/wordpress\/?p=759"},"modified":"2026-02-18T21:15:03","modified_gmt":"2026-02-18T13:15:03","slug":"%e3%80%90mysql%e3%80%91%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6%e8%bf%87%e6%bb%a4%e9%85%8d%e7%bd%ae%e5%85%a8%e8%a7%a3%e6%9e%90%ef%bc%9a%e5%ba%93%e4%b8%8e%e8%a1%a8%e7%ba%a7%e5%90%8c%e6%ad%a5%e6%8e%a7","status":"publish","type":"post","link":"https:\/\/yunyanglib.cn\/?p=759","title":{"rendered":"\u3010MySQL\u3011\u4e3b\u4ece\u590d\u5236\u8fc7\u6ee4\u914d\u7f6e\u5168\u89e3\u6790\uff1a\u5e93\u4e0e\u8868\u7ea7\u540c\u6b65\u63a7\u5236\u5b9e\u6218"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5728\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u4e2d\uff0cMySQL \u4e3b\u4ece\u590d\u5236\u67b6\u6784\u51e0\u4e4e\u662f\u6807\u914d\uff0c\u4f46\u9ed8\u8ba4\u7684\u5168\u91cf\u540c\u6b65\u5f80\u5f80\u4f1a\u5e26\u6765\u4e0d\u5fc5\u8981\u7684\u8d44\u6e90\u6d88\u8017 \u2014\u2014 \u6bd4\u5982\u65e5\u5fd7\u8868\u3001\u6d4b\u8bd5\u8868\u7684\u6570\u636e\u540c\u6b65\uff0c\u4e0d\u4ec5\u5360\u7528\u4ece\u5e93\u78c1\u76d8\u7a7a\u95f4\uff0c\u8fd8\u4f1a\u589e\u52a0\u7f51\u7edc\u4f20\u8f93\u538b\u529b\u3002\u56e0\u6b64\uff0c\u7cbe\u7ec6\u5316\u63a7\u5236\u540c\u6b65\u8303\u56f4\uff08\u53ea\u540c\u6b65\u6838\u5fc3\u6570\u636e\u3001\u5ffd\u7565\u975e\u5fc5\u8981\u8868 \/ \u5e93\uff09\u5c31\u663e\u5f97\u5c24\u4e3a\u91cd\u8981\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u8fd1\u521a\u597d\u5728\u4f18\u5316\u516c\u53f8\u7684\u4e3b\u4ece\u67b6\u6784\uff0c\u6574\u7406\u4e86\u4e00\u5957\u5b8c\u6574\u7684\u8fc7\u6ee4\u914d\u7f6e\u5b9e\u9a8c\u65b9\u6848\uff0c\u4ece\u73af\u5883\u51c6\u5907\u5230\u516d\u79cd\u6838\u5fc3\u573a\u666f\u6d4b\u8bd5\uff0c\u5168\u7a0b\u5b9e\u64cd\u9a8c\u8bc1\uff0c\u4eca\u5929\u5c31\u628a\u8fd9\u4e9b\u5e72\u8d27\u5206\u4eab\u7ed9\u5927\u5bb6\uff5e<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"p44FX\">\u4e00\u3001\u5b9e\u9a8c\u73af\u5883\u51c6\u5907\uff08\u57fa\u7840\u94fa\u57ab\u4e0d\u80fd\u5c11\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u4d969c76\">\u9996\u5148\u5f97\u6709\u4e00\u4e2a\u6b63\u5e38\u8fd0\u884c\u7684 MySQL \u4e3b\u4ece\u67b6\u6784\uff08\u4e3b\u4ece\u5df2\u5b9e\u73b0\u57fa\u7840\u540c\u6b65\uff09\uff0c\u6211\u8fd9\u91cc\u7528\u7684\u662f MySQL 8.0.25 \u7248\u672c\uff0c\u64cd\u4f5c\u7cfb\u7edf\u662f CentOS 7\u3002\u6838\u5fc3\u64cd\u4f5c\u5206\u4e3a<strong>\u4e3b\u5e93\u6267\u884c<\/strong>\uff08\u521b\u5efa\u6d4b\u8bd5\u6570\u636e\uff09\u548c<strong>\u4ece\u5e93\u6267\u884c<\/strong>\uff08\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219\u4e0e\u9a8c\u8bc1\uff09\u4e24\u90e8\u5206\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"uRWjm\">1.1 \u4e3b\u5e93\uff1a\u521b\u5efa\u6d4b\u8bd5\u5e93\u4e0e\u8868<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u70f487e7\">\u4e3a\u4e86\u9a8c\u8bc1\u4e0d\u540c\u8fc7\u6ee4\u89c4\u5219\uff0c\u6211\u7279\u610f\u521b\u5efa\u4e86 2 \u4e2a\u5e93\u30014 \u5f20\u8868\uff0c\u5305\u542b\u4e1a\u52a1\u8868\u3001\u65e5\u5fd7\u8868\uff0c\u65b9\u4fbf\u540e\u7eed\u533a\u5206\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n<pre id=\"QaV47\" class=\"wp-block-code\"><code>-- 1. \u521b\u5efa\u6d4b\u8bd5\u6570\u636e\u5e93\n\ncreate database db1;\n\ncreate database db2;\n\n-- 2. db1\u5e93\uff1a\u4e1a\u52a1\u8868+\u65e5\u5fd7\u8868\uff08\u6a21\u62df\u771f\u5b9e\u573a\u666f\uff09\n\nuse db1;\n\ncreate table table_01(\n\n   id int not null auto_increment primary key,\n\n   name varchar(10)  -- \u5b58\u50a8\u968f\u673a\u5b57\u7b26\u4e32\uff0c\u7528\u4e8e\u9a8c\u8bc1\u6570\u636e\u540c\u6b65\n\n);\n\ncreate table table_02(\n\n  id int not null auto_increment primary key,\n\n  name varchar(10)\n\n);\n\ncreate table log_01(  -- \u6a21\u62df\u65e5\u5fd7\u8868\uff0c\u540e\u7eed\u7528\u4e8e\u6d4b\u8bd5\"\u5ffd\u7565\u540c\u6b65\"\n\n   id int not null auto_increment primary key,\n\n   name varchar(10)\n\n);\n\n-- 3. db2\u5e93\uff1a\u666e\u901a\u6d4b\u8bd5\u8868\n\nuse db2;\n\ncreate table test_01(\n\n   id int not null auto_increment primary key,\n\n   name varchar(10)\n\n);<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"445\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-192-1024x445.png\" alt=\"\" class=\"wp-image-765\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-192-1024x445.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-192-300x130.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-192-768x334.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-192.png 1133w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Hfk30\">1.2 \u4e3b\u5e93\uff1a\u5199\u5165\u6d4b\u8bd5\u6570\u636e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uacc96292\">\u901a\u8fc7<code>SUBSTRING(MD5(RAND()), 1, 10)<\/code>\u751f\u6210\u968f\u673a 10 \u4f4d\u5b57\u7b26\u4e32\uff0c\u6a21\u62df\u4e1a\u52a1\u6570\u636e\u5199\u5165\uff1a<\/p>\n\n\n\n<pre id=\"itOBA\" class=\"wp-block-code\"><code>-- \u5411db1\u76843\u5f20\u8868\u548cdb2\u76841\u5f20\u8868\u63d2\u5165\u6570\u636e\n\ninsert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));\n\ninsert into db1.table_02(name) values (SUBSTRING(MD5(RAND()), 1, 10));\n\ninsert into db1.log_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));\n\ninsert into db2.test_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"299\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-193-1024x299.png\" alt=\"\" class=\"wp-image-766\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-193-1024x299.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-193-300x88.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-193-768x224.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-193.png 1034w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"hYC6W\">1.3 \u4ece\u5e93\uff1a\u9a8c\u8bc1\u521d\u59cb\u540c\u6b65<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u1f6da5c9\">\u5728\u4ece\u5e93\u6267\u884c\u67e5\u8be2\uff0c\u786e\u8ba4\u57fa\u7840\u4e3b\u4ece\u540c\u6b65\u6b63\u5e38\uff08\u6240\u6709\u8868\u5747\u80fd\u67e5\u8be2\u5230\u4e3b\u5e93\u63d2\u5165\u7684\u6570\u636e\uff09\uff1a<\/p>\n\n\n\n<pre id=\"hMENS\" class=\"wp-block-code\"><code>-- \u4ece\u5e93\u67e5\u8be24\u5f20\u6d4b\u8bd5\u8868\u6570\u636e\n\nselect * from db1.table_01;\n\nselect * from db1.table_02;\n\nselect * from db1.log_01;\n\nselect * from db2.test_01;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1008\" height=\"723\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-194.png\" alt=\"\" class=\"wp-image-767\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-194.png 1008w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-194-300x215.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-194-768x551.png 768w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u16c771d9\">\u82e5\u5747\u80fd\u8fd4\u56de\u6570\u636e\uff0c\u8bf4\u660e\u4e3b\u4ece\u67b6\u6784\u57fa\u7840\u6b63\u5e38\uff0c\u53ef\u8fdb\u5165\u8fc7\u6ee4\u914d\u7f6e\u5b9e\u9a8c\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aTpFV\">\u4e8c\u3001\u516d\u79cd\u6838\u5fc3\u8fc7\u6ee4\u65b9\u6848\uff08\u573a\u666f\u5316\u5b9e\u64cd\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uaa4f70d3\">\u6240\u6709\u8fc7\u6ee4\u89c4\u5219\u5747\u5728<strong>\u4ece\u5e93<\/strong>\u914d\u7f6e\uff0c\u6838\u5fc3\u903b\u8f91\u662f\u901a\u8fc7<code>CHANGE REPLICATION FILTER<\/code>\u547d\u4ee4\u4e34\u65f6\u751f\u6548\uff0c\u6216\u4fee\u6539 MySQL \u914d\u7f6e\u6587\u4ef6\u5b9e\u73b0\u6301\u4e45\u5316\uff08\u9700\u91cd\u542f\u670d\u52a1\uff09\u3002\u6bcf\u4e2a\u5b9e\u9a8c\u5747\u9075\u5faa \u201c\u505c\u6b62SQL\u7ebf\u7a0b \u2192 \u914d\u7f6e\u89c4\u5219 \u2192 \u91cd\u542fSQL\u7ebf\u7a0b \u2192 \u6d4b\u8bd5\u6548\u679c \u2192 \u6e05\u7406\u89c4\u5219\u201d \u6d41\u7a0b\uff0c\u907f\u514d\u89c4\u5219\u6b8b\u7559\u5f71\u54cd\u540e\u7eed\u5b9e\u9a8c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"BMT9e\">2.1 \u65b9\u6848 1\uff1a\u53ea\u590d\u5236\u67d0\u4e00\u4e2a\u5e93\uff08REPLICATE_DO_DB\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u1b158bfe\"><strong>\u9002\u7528\u573a\u666f<\/strong>\uff1a\u53ea\u9700\u8981\u540c\u6b65\u6838\u5fc3\u4e1a\u52a1\u5e93\uff08\u6bd4\u5982 db1\uff09\uff0c\u975e\u6838\u5fc3\u5e93\uff08\u5982 db2\uff09\u65e0\u9700\u540c\u6b65\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"QOaRo\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"dYRoZ\" class=\"wp-block-code\"><code>-- 1. \u505c\u6b62\u4ece\u5e93SQL\u7ebf\u7a0b\uff08\u907f\u514d\u914d\u7f6e\u4fee\u6539\u65f6\u540c\u6b65\u5f02\u5e38\uff09\n\nSTOP SLAVE SQL_THREAD;\n\n-- 2. \u914d\u7f6e\"\u53ea\u590d\u5236db1\"\uff08\u4e34\u65f6\u751f\u6548\uff0c\u91cd\u542f\u4ece\u5e93\u540e\u5931\u6548\uff09\n\nCHANGE REPLICATION FILTER REPLICATE_DO_DB=(db1);\n\n-- 3. \u91cd\u542fSQL\u7ebf\u7a0b\uff0c\u5e94\u7528\u914d\u7f6e\n\nstart slave sql_thread;\n\n-- 4. \u9a8c\u8bc1\u914d\u7f6e\u72b6\u6001\uff08\u67e5\u770bFilter\u76f8\u5173\u53c2\u6570\uff09\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"716\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-195.png\" alt=\"\" class=\"wp-image-768\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-195.png 1000w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-195-300x215.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-195-768x550.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ueb9a0172\">\u5982\u679c\u9700\u8981\u957f\u671f\u751f\u6548\uff0c\u5c31\u8981\u6539\u914d\u7f6e\u6587\u4ef6\uff08\u8bb0\u5f97\u91cd\u542f\u670d\u52a1\uff09\uff1a<\/p>\n\n\n\n<pre id=\"S8OcY\" class=\"wp-block-code\"><code># \u7f16\u8f91MySQL\u914d\u7f6e\u6587\u4ef6\n\nvim \/data\/mysql\/conf\/my.cnf\n\n# \u65b0\u589e\u914d\u7f6e\uff08\u6307\u5b9a\u53ea\u590d\u5236db1\uff09\n\nreplicate-do-db=db1\n\n# \u91cd\u542fMySQL\u670d\u52a1\u751f\u6548\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"V8Gvq\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"KDCap\" class=\"wp-block-code\"><code>insert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- db1\u8868\n\ninsert into db2.test_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- db2\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1004\" height=\"167\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-196.png\" alt=\"\" class=\"wp-image-769\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-196.png 1004w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-196-300x50.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-196-768x128.png 768w\" sizes=\"(max-width: 1004px) 100vw, 1004px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">     2. <strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>db1.table_01<\/code>\uff1a\u65b0\u589e\u6570\u636e\u540c\u6b65\u6210\u529f\uff08\u7b26\u5408\u8fc7\u6ee4\u89c4\u5219\uff09<\/li>\n\n\n\n<li><code>db2.test_01<\/code>\uff1a\u65b0\u589e\u6570\u636e\u672a\u540c\u6b65\uff08\u88ab\u8fc7\u6ee4\uff09<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1001\" height=\"395\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-197.png\" alt=\"\" class=\"wp-image-770\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-197.png 1001w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-197-300x118.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-197-768x303.png 768w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6d4b\u8bd5\u7ed3\u679c<\/strong>\uff1a\u4e3b\u5e93\u5f80 db1 \u63d2\u6570\u636e\u540c\u6b65\u6210\u529f\uff0cdb2 \u63d2\u6570\u636e\u4ece\u5e93\u65e0\u53cd\u5e94\uff0c\u7b26\u5408\u9884\u671f\uff5e<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Rbwd9\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"HZHsI\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_DO_DB=();  -- \u7a7a\u503c\u6e05\u7a7a\u89c4\u5219\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"664\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-198-1024x664.png\" alt=\"\" class=\"wp-image-771\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-198-1024x664.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-198-300x195.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-198-768x498.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-198.png 1033w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"fYYCD\">2.2 \u65b9\u6848 2\uff1a\u5ffd\u7565\u67d0\u4e2a\u5e93\u7684\u590d\u5236\uff08REPLICATE_IGNORE_DB\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ud26cf693\"><strong>\u573a\u666f<\/strong>\uff1a\u9700\u540c\u6b65\u9664<code>db1<\/code>\uff08\u65e5\u5fd7\u5e93 \/ \u6d4b\u8bd5\u5e93\uff09\u5916\u7684\u6240\u6709\u5e93\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"QXr5T\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"WKEpM\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\n-- \u914d\u7f6e\"\u5ffd\u7565db1\"\uff08\u4e34\u65f6\u751f\u6548\uff09\n\nCHANGE REPLICATION FILTER REPLICATE_IGNORE_DB=(db1);\n\nstart slave sql_thread;\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-199-1024x577.png\" alt=\"\" class=\"wp-image-772\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-199-1024x577.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-199-300x169.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-199-768x433.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-199.png 1044w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u2a094243\"><strong>\u6301\u4e45\u5316\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<pre id=\"WqFrF\" class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf\n\nreplicate-ignore-db=db1  # \u65b0\u589e\u914d\u7f6e\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"gmgo8\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"SshPp\" class=\"wp-block-code\"><code>insert into db1.log_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- db1\u8868\n\ninsert into db2.test_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- db2\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1008\" height=\"175\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-200.png\" alt=\"\" class=\"wp-image-773\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-200.png 1008w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-200-300x52.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-200-768x133.png 768w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">  2. <strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>db1.log_01<\/code>\uff1a\u65b0\u589e\u6570\u636e\u672a\u540c\u6b65\uff08\u88ab\u5ffd\u7565\uff09<\/li>\n\n\n\n<li><code>db2.test_01<\/code>\uff1a\u65b0\u589e\u6570\u636e\u540c\u6b65\u6210\u529f<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"354\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-201.png\" alt=\"\" class=\"wp-image-774\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-201.png 1000w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-201-300x106.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-201-768x272.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6d4b\u8bd5\u611f\u609f<\/strong>\uff1a\u8fd9\u4e2a\u89c4\u5219\u9002\u5408\u628a\u6d4b\u8bd5\u5e93\u3001\u65e5\u5fd7\u5e93\u6392\u9664\u5728\u5916\uff0c\u51cf\u5c11\u4ece\u5e93\u538b\u529b\uff0c\u4eb2\u6d4b\u597d\u7528\uff01<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"QGPi2\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"FLgls\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_IGNORE_DB=();\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"637\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-202.png\" alt=\"\" class=\"wp-image-775\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-202.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-202-300x187.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-202-768x478.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"qIbrq\">2.3 \u65b9\u6848 3\uff1a\u53ea\u590d\u5236\u6307\u5b9a\u7684\u8868\uff08REPLICATE_DO_TABLE\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ua67dc89a\"><strong>\u9002\u7528\u573a\u666f<\/strong>\uff1a\u540c\u4e00\u5e93\u4e0b\u53ea\u9700\u8981\u540c\u6b65\u6838\u5fc3\u8868\uff08\u6bd4\u5982 db1.table_01\uff09\uff0c\u5176\u4ed6\u8868\u5ffd\u7565\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"A1ALM\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"UIY9z\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\n-- \u914d\u7f6e\"\u53ea\u590d\u5236db1.table_01\"\uff08\u9700\u6307\u5b9a\u5e93\u540d.\u8868\u540d\uff09\n\nCHANGE REPLICATION FILTER REPLICATE_DO_TABLE=(db1.table_01);\n\nstart slave sql_thread;\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"663\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-203.png\" alt=\"\" class=\"wp-image-776\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-203.png 1003w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-203-300x198.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-203-768x508.png 768w\" sizes=\"(max-width: 1003px) 100vw, 1003px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6ce8\u610f<\/strong>\uff1a\u5982\u679c\u53ea\u5199\u8868\u540d\u4f1a\u5931\u6548\uff01\u4e4b\u524d\u8e29\u8fc7\u8fd9\u4e2a\u5751\uff0c\u5927\u5bb6\u4e00\u5b9a\u8981\u6ce8\u610f\uff5e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u84a31371\"><strong>\u6301\u4e45\u5316\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<pre id=\"i914M\" class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf\n\nreplicate-do-table=db1.table_01  # \u65b0\u589e\u914d\u7f6e\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"iyzxA\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"fypkV\" class=\"wp-block-code\"><code>insert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u76ee\u6807\u8868\n\ninsert into db1.table_02(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u540c\u5e93\u5176\u4ed6\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1010\" height=\"179\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-204.png\" alt=\"\" class=\"wp-image-777\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-204.png 1010w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-204-300x53.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-204-768x136.png 768w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">  2. <strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>db1.table_01<\/code>\uff1a\u540c\u6b65\u6210\u529f<\/li>\n\n\n\n<li><code>db1.table_02<\/code>\uff1a\u672a\u540c\u6b65<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1013\" height=\"403\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-205.png\" alt=\"\" class=\"wp-image-778\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-205.png 1013w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-205-300x119.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-205-768x306.png 768w\" sizes=\"(max-width: 1013px) 100vw, 1013px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"o2iXj\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"EZLGf\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_DO_TABLE=();\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"661\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-206-1024x661.png\" alt=\"\" class=\"wp-image-779\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-206-1024x661.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-206-300x194.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-206-768x496.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-206.png 1041w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"x67xq\">2.4 \u65b9\u6848 4\uff1a\u5ffd\u7565\u590d\u5236\u6307\u5b9a\u7684\u8868\uff08REPLICATE_IGNORE_TABLE\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ufbdf06e2\"><strong>\u9002\u7528\u573a\u666f<\/strong>\uff1a\u540c\u6b65\u67d0\u5e93\u5927\u90e8\u5206\u8868\uff0c\u4f46\u5ffd\u7565\u65e5\u5fd7\u8868\u3001\u4e34\u65f6\u8868\uff08\u6bd4\u5982 db1.log_01\uff09\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"p72Oi\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"WIenE\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\n-- \u914d\u7f6e\"\u5ffd\u7565db1.log\\_01\"\n\nCHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE=(db1.log_01);\n\nstart slave sql_thread;\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"731\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-207.png\" alt=\"\" class=\"wp-image-780\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-207.png 1005w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-207-300x218.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-207-768x559.png 768w\" sizes=\"(max-width: 1005px) 100vw, 1005px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ud0ef0c83\"><strong>\u6301\u4e45\u5316\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<pre id=\"OTheA\" class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf\n\nreplicate-ignore-table=db1.log_01  # \u65b0\u589e\u914d\u7f6e\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"l9JWq\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"naGGI\" class=\"wp-block-code\"><code>insert into db1.log_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u88ab\u5ffd\u7565\u8868\n\ninsert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u5176\u4ed6\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"141\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-220-1024x141.png\" alt=\"\" class=\"wp-image-796\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-220-1024x141.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-220-300x41.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-220-768x106.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-220.png 1031w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">     2. <strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>db1.log_01<\/code>\uff1a\u672a\u540c\u6b65<\/li>\n\n\n\n<li><code>db1.table_01<\/code>\uff1a\u540c\u6b65\u6210\u529f<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"444\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-208.png\" alt=\"\" class=\"wp-image-781\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-208.png 1000w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-208-300x133.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-208-768x341.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Vc1Yh\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"STrSu\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE=();\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1021\" height=\"745\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-209.png\" alt=\"\" class=\"wp-image-782\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-209.png 1021w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-209-300x219.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-209-768x560.png 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b9e\u64cd\u5fc3\u5f97<\/strong>\uff1a\u65e5\u5fd7\u8868\u6570\u636e\u91cf\u5927\u4e14\u65e0\u9700\u5907\u4efd\uff0c\u7528\u8fd9\u4e2a\u89c4\u5219\u80fd\u8282\u7701\u5927\u91cf\u78c1\u76d8\u7a7a\u95f4\uff5e<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"jNjbn\">2.5 \u65b9\u6848 5\uff1a\u6307\u5b9a\u540c\u6b65\u67d0\u4e9b\u8868\uff08\u901a\u914d\u7b26\uff0cREPLICATE_WILD_DO_TABLE\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u078049cd\"><strong>\u9002\u7528\u573a\u666f<\/strong>\uff1a\u540c\u6b65\u67d0\u5e93\u4e0b\u7b26\u5408\u524d\u7f00 \/ \u540e\u7f00\u89c4\u5219\u7684\u8868\uff08\u6bd4\u5982 db1 \u4e0b\u6240\u6709 table \u5f00\u5934\u7684\u8868\uff09\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"aXI7L\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"Js0Gm\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\n-- \u901a\u914d\u7b26%\u5339\u914d\u4efb\u610f\u5b57\u7b26\uff0c\u914d\u7f6e\"\u53ea\u590d\u5236db1.table%\"\n\nCHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE=('db1.table%');\n\nstart slave sql_thread;\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"674\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-210-1024x674.png\" alt=\"\" class=\"wp-image-783\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-210-1024x674.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-210-300x198.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-210-768x506.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-210.png 1054w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u0bd5f3f9\"><strong>\u6301\u4e45\u5316\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<pre id=\"Dx7Jc\" class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf\n\nreplicate-wild-do-table=db1.table%  # \u65b0\u589e\u914d\u7f6e\uff08\u65e0\u9700\u5f15\u53f7\uff09\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"FoAEe\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"RGMmG\" class=\"wp-block-code\"><code>insert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u5339\u914d\u524d\u7f00\n\ninsert into db1.table_02(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u5339\u914d\u524d\u7f00\n\ninsert into db1.log_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));    -- \u4e0d\u5339\u914d\u524d\u7f00<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"219\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-211-1024x219.png\" alt=\"\" class=\"wp-image-784\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-211-1024x219.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-211-300x64.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-211-768x164.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-211.png 1028w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>table_01<\/code>\u3001<code>table_02<\/code>\uff1a\u540c\u6b65\u6210\u529f<\/li>\n\n\n\n<li><code>log_01<\/code>\uff1a\u672a\u540c\u6b65<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"650\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-213.png\" alt=\"\" class=\"wp-image-786\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-213.png 1012w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-213-300x193.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-213-768x493.png 768w\" sizes=\"(max-width: 1012px) 100vw, 1012px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6d4b\u8bd5\u6548\u679c<\/strong>\uff1atable_01\u3001table_02 \u90fd\u80fd\u540c\u6b65\uff0clog_01 \u88ab\u5ffd\u7565\uff0c\u6279\u91cf\u5339\u914d\u8d85\u9ad8\u6548\uff01<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"b0mRC\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"GIwxj\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE=();\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"997\" height=\"702\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-214.png\" alt=\"\" class=\"wp-image-787\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-214.png 997w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-214-300x211.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-214-768x541.png 768w\" sizes=\"(max-width: 997px) 100vw, 997px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Psdur\">2.6 \u65b9\u6848 6\uff1a\u5ffd\u7565\u67d0\u4e9b\u8868\u7684\u540c\u6b65\uff08\u901a\u914d\u7b26\uff0cREPLICATE_WILD_IGNORE_TABLE\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u8e9d454c\"><strong>\u9002\u7528\u573a\u666f<\/strong>\uff1a\u5ffd\u7565\u67d0\u5e93\u4e0b\u7b26\u5408\u89c4\u5219\u7684\u8868\uff08\u6bd4\u5982 db1 \u4e0b\u6240\u6709 table \u5f00\u5934\u7684\u8868\uff09\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"TBCQ0\">\u6b65\u9aa4 1\uff1a\u4ece\u5e93\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"Nek6v\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\n-- \u914d\u7f6e\"\u5ffd\u7565db1.table%\"\n\nCHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE=('db1.table%');\n\nstart slave sql_thread;\n\nshow slave status\\G<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"654\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-215-1024x654.png\" alt=\"\" class=\"wp-image-788\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-215-1024x654.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-215-300x192.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-215-768x490.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-215.png 1090w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ub53f1b8f\"><strong>\u6301\u4e45\u5316\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<pre id=\"i0fPy\" class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf\n\nreplicate-wild-ignore-table=db1.table%  # \u65b0\u589e\u914d\u7f6e\n\nsystemctl restart mysqld<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"NFgBY\">\u6b65\u9aa4 2\uff1a\u6d4b\u8bd5\u540c\u6b65\u6548\u679c<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e3b\u5e93\u63d2\u5165\u65b0\u6570\u636e<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"oE4Mb\" class=\"wp-block-code\"><code>insert into db1.table_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));  -- \u88ab\u5ffd\u7565\u524d\u7f00\n\ninsert into db1.log_01(name) values (SUBSTRING(MD5(RAND()), 1, 10));    -- \u5176\u4ed6\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"177\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-217-1024x177.png\" alt=\"\" class=\"wp-image-790\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-217-1024x177.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-217-300x52.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-217-768x133.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-217.png 1057w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">    2. <strong>\u4ece\u5e93\u9a8c\u8bc1<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>table_01<\/code>\uff1a\u672a\u540c\u6b65<\/li>\n\n\n\n<li><code>log_01<\/code>\uff1a\u540c\u6b65\u6210\u529f<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"993\" height=\"487\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-216.png\" alt=\"\" class=\"wp-image-789\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-216.png 993w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-216-300x147.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-216-768x377.png 768w\" sizes=\"(max-width: 993px) 100vw, 993px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"WO8HE\">\u6b65\u9aa4 3\uff1a\u53d6\u6d88\u8fc7\u6ee4\u89c4\u5219<\/h4>\n\n\n\n<pre id=\"tLcdJ\" class=\"wp-block-code\"><code>STOP SLAVE SQL_THREAD;\n\nCHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE=();\n\nstart slave sql_thread;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1001\" height=\"688\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-218.png\" alt=\"\" class=\"wp-image-791\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-218.png 1001w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-218-300x206.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-218-768x528.png 768w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4f7f\u7528\u5efa\u8bae<\/strong>\uff1a\u5982\u679c\u9700\u8981\u6279\u91cf\u6392\u9664\u540c\u7c7b\u8868\uff0c\u8fd9\u4e2a\u89c4\u5219\u6bd4\u9010\u4e2a\u5199 REPLICATE_IGNORE_TABLE \u66f4\u65b9\u4fbf\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"KdOlx\">2.7 \u5b9e\u9a8c\u540e\u6570\u636e\u6e05\u7406<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u3658b1a9\">\u7531\u4e8e\u8fc7\u6ee4\u914d\u7f6e\u4f1a\u5bfc\u81f4\u4e3b\u4ece\u6570\u636e\u4e0d\u4e00\u81f4\uff08\u90e8\u5206\u8868\u672a\u540c\u6b65\uff09\uff0c\u5b9e\u9a8c\u7ed3\u675f\u540e\u5efa\u8bae\u5728<strong>\u4e3b\u5e93\u548c\u4ece\u5e93<\/strong>\u540c\u65f6\u5220\u9664\u6d4b\u8bd5\u5e93\uff0c\u907f\u514d\u6b8b\u7559\u6570\u636e\u5e72\u6270\uff1a<\/p>\n\n\n\n<pre id=\"Wz9Ro\" class=\"wp-block-code\"><code>-- \u4e3b\u5e93\u548c\u4ece\u5e93\u5747\u6267\u884c\n\ndrop database db1;\n\ndrop database db2;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"996\" height=\"415\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-219.png\" alt=\"\" class=\"wp-image-793\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-219.png 996w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-219-300x125.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-219-768x320.png 768w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bgbEw\">\u4e09\u3001\u5b9e\u9a8c\u603b\u7ed3\uff08\u5feb\u901f\u9009\u578b\u6307\u5357\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ub2277482\">\u4e3a\u65b9\u4fbf\u5feb\u901f\u9009\u578b\uff0c\u5c06 7 \u79cd\u914d\u7f6e\u65b9\u6848\u6574\u7406\u4e3a\u5bf9\u6bd4\u8868\uff0c\u6db5\u76d6\u6838\u5fc3\u53c2\u6570\u3001\u9002\u7528\u573a\u666f\u53ca\u914d\u7f6e\u65b9\u5f0f\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>\u914d\u7f6e\u65b9\u6848<\/strong><\/td><td><strong>\u6838\u5fc3\u53c2\u6570<\/strong><\/td><td><strong>\u63a7\u5236\u7c92\u5ea6<\/strong><\/td><td><strong>\u9002\u7528\u573a\u666f<\/strong><\/td><td><strong>\u4e34\u65f6\u914d\u7f6e\u547d\u4ee4\uff08\u4ece\u5e93\uff09<\/strong><\/td><td><strong>\u6301\u4e45\u5316\u914d\u7f6e\uff08my.cnf\uff09<\/strong><\/td><\/tr><tr><td><strong>\u53ea\u590d\u5236\u67d0\u5e93<\/strong><\/td><td>REPLICATE_DO_DB<\/td><td>\u5e93\u7ea7<\/td><td>\u4ec5\u540c\u6b65\u6838\u5fc3\u4e1a\u52a1\u5e93<\/td><td>CHANGE REPLICATION FILTER REPLICATE_DO_DB=(\u5e93\u540d);<\/td><td>replicate-do-db = \u5e93\u540d<\/td><\/tr><tr><td><strong>\u5ffd\u7565\u67d0\u5e93<\/strong><\/td><td>REPLICATE_IGNORE_DB<\/td><td>\u5e93\u7ea7<\/td><td>\u6392\u9664\u975e\u6838\u5fc3\u5e93\uff08\u5982\u6d4b\u8bd5\u5e93\u3001\u65e5\u5fd7\u5e93\uff09<\/td><td>CHANGE REPLICATION FILTER REPLICATE_IGNORE_DB=(\u5e93\u540d);<\/td><td>replicate-ignore-db = \u5e93\u540d<\/td><\/tr><tr><td><strong>\u53ea\u590d\u5236\u6307\u5b9a\u8868<\/strong><\/td><td>REPLICATE_DO_TABLE<\/td><td>\u8868\u7ea7<\/td><td>\u4ec5\u540c\u6b65\u5355\u5e93\u4e0b\u7684\u6838\u5fc3\u8868<\/td><td>CHANGE REPLICATION FILTER REPLICATE_DO_TABLE=(\u5e93\u540d.\u8868\u540d);<\/td><td>replicate-do-table = \u5e93\u540d.\u8868\u540d<\/td><\/tr><tr><td><strong>\u5ffd\u7565\u6307\u5b9a\u8868<\/strong><\/td><td>REPLICATE_IGNORE_TABLE<\/td><td>\u8868\u7ea7<\/td><td>\u6392\u9664\u5355\u5e93\u4e0b\u7684\u975e\u6838\u5fc3\u8868\uff08\u5982\u65e5\u5fd7\u8868\uff09<\/td><td>CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE=(\u5e93\u540d.\u8868\u540d);<\/td><td>replicate-ignore-table = \u5e93\u540d.\u8868\u540d<\/td><\/tr><tr><td><strong>\u901a\u914d\u7b26\u5339\u914d\u540c\u6b65\u8868<\/strong><\/td><td>REPLICATE_WILD_DO_TABLE<\/td><td>\u901a\u914d\u7b26\u7ea7<\/td><td>\u540c\u6b65\u5355\u5e93\u4e0b\u7b26\u5408\u524d\u7f00 \/ \u540e\u7f00\u89c4\u5219\u7684\u8868<\/td><td>CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE=(&#8216; \u5e93\u540d.\u524d\u7f00 %&#8217;);<\/td><td>replicate-wild-do-table = \u5e93\u540d.\u524d\u7f00 %<\/td><\/tr><tr><td><strong>\u901a\u914d\u7b26\u5339\u914d\u5ffd\u7565\u8868<\/strong><\/td><td>REPLICATE_WILD_IGNORE_TABLE<\/td><td>\u901a\u914d\u7b26\u7ea7<\/td><td>\u6392\u9664\u5355\u5e93\u4e0b\u7b26\u5408\u524d\u7f00 \/ \u540e\u7f00\u89c4\u5219\u7684\u8868<\/td><td>CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE=(&#8216; \u5e93\u540d.\u524d\u7f00 %&#8217;);<\/td><td>replicate-wild-ignore-table = \u5e93\u540d.\u524d\u7f00 %<\/td><\/tr><tr><td><strong>\u6e05\u7406\u8fc7\u6ee4\u89c4\u5219<\/strong><\/td><td>&#8211;<\/td><td>&#8211;<\/td><td>\u5b9e\u9a8c\u540e\u6216\u89c4\u5219\u53d8\u66f4\u524d\uff0c\u6e05\u7a7a\u6240\u6709\u8fc7\u6ee4\u914d\u7f6e<\/td><td>CHANGE REPLICATION FILTER \u5bf9\u5e94\u53c2\u6570 =();<\/td><td>\u5220\u9664\u5bf9\u5e94\u914d\u7f6e\u9879\u5e76\u91cd\u542f\u670d\u52a1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"OwfBh\">\u56db\u3001\u907f\u5751\u6307\u5357\uff08\u5b9e\u64cd\u7ecf\u9a8c\u5206\u4eab\uff09<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u914d\u7f6e\u751f\u6548\u987a\u5e8f<\/strong>\uff1a\u4e34\u65f6\u914d\u7f6e\uff08<code>CHANGE REPLICATION FILTER<\/code>\uff09\u4f18\u5148\u7ea7\u9ad8\u4e8e\u914d\u7f6e\u6587\u4ef6\uff0c\u4e14\u65e0\u9700\u91cd\u542f\uff1b\u82e5\u9700\u957f\u671f\u751f\u6548\uff0c\u9700\u540c\u6b65\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u3002<\/li>\n\n\n\n<li><strong>\u591a\u89c4\u5219\u51b2\u7a81<\/strong>\uff1a\u82e5\u540c\u65f6\u914d\u7f6e \u201c\u53ea\u590d\u5236\u201d \u548c \u201c\u5ffd\u7565\u201d \u89c4\u5219\uff0c\u201c\u5ffd\u7565\u201d \u89c4\u5219\u4f18\u5148\u7ea7\u66f4\u9ad8\uff08\u5373\u5148\u5224\u65ad\u662f\u5426\u88ab\u5ffd\u7565\uff0c\u518d\u5224\u65ad\u662f\u5426\u9700\u590d\u5236\uff09\u3002<\/li>\n\n\n\n<li><strong>\u8868\u540d\u5927\u5c0f\u5199<\/strong>\uff1aMySQL \u5728 Linux \u73af\u5883\u4e0b\u9ed8\u8ba4\u533a\u5206\u8868\u540d\u5927\u5c0f\u5199\uff0c\u914d\u7f6e\u65f6\u9700\u4e0e\u5b9e\u9645\u8868\u540d\u5927\u5c0f\u5199\u4e00\u81f4\uff0c\u907f\u514d\u89c4\u5219\u5931\u6548\u3002<\/li>\n\n\n\n<li><strong>\u91cd\u542f\u5f71\u54cd<\/strong>\uff1a\u4e34\u65f6\u914d\u7f6e\u5728\u4ece\u5e93\u91cd\u542f\u540e\u5931\u6548\uff0c\u751f\u4ea7\u73af\u5883\u9700\u4f18\u5148\u4f7f\u7528\u914d\u7f6e\u6587\u4ef6\u6301\u4e45\u5316\uff0c\u907f\u514d\u670d\u52a1\u91cd\u542f\u540e\u89c4\u5219\u4e22\u5931\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u6700\u540e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u5c31\u662f MySQL \u4e3b\u4ece\u590d\u5236\u8fc7\u6ee4\u914d\u7f6e\u7684\u5168\u90e8\u5b9e\u64cd\u5185\u5bb9\u5566\uff5e \u5176\u5b9e\u8fc7\u6ee4\u89c4\u5219\u4e0d\u96be\uff0c\u5173\u952e\u662f\u6839\u636e\u4e1a\u52a1\u573a\u666f\u9009\u5bf9\u65b9\u6848\uff0c\u5e76\u4e14\u6ce8\u610f\u907f\u5751\u3002\u5982\u679c\u5927\u5bb6\u6709\u5176\u4ed6\u573a\u666f\u7684\u8fc7\u6ee4\u9700\u6c42\uff0c\u6216\u8005\u5728\u5b9e\u64cd\u4e2d\u9047\u5230\u95ee\u9898\uff0c\u6b22\u8fce\u5728\u8bc4\u8bba\u533a\u4ea4\u6d41\u63a2\u8ba8\uff01<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ue62ece28\">\u540e\u7eed\u8fd8\u4f1a\u5206\u4eab\u66f4\u591a MySQL \u4e3b\u4ece\u590d\u5236\u7684\u4f18\u5316\u6280\u5de7\uff0c\u6bd4\u5982\u5e76\u884c\u590d\u5236\u3001\u5ef6\u8fdf\u540c\u6b65\u7b49\uff0c\u611f\u5174\u8da3\u7684\u670b\u53cb\u53ef\u4ee5\u5173\u6ce8\u4e00\u6ce2\uff5e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u4e2d\uff0cMySQL \u4e3b\u4ece\u590d\u5236\u67b6\u6784\u51e0\u4e4e\u662f\u6807\u914d\uff0c\u4f46\u9ed8\u8ba4\u7684\u5168\u91cf\u540c\u6b65\u5f80\u5f80\u4f1a\u5e26\u6765\u4e0d\u5fc5\u8981\u7684\u8d44\u6e90\u6d88\u8017 \u2014\u2014 \u6bd4\u5982\u65e5<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"https:\/\/yunyanglib.cn\/?p=759\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-759","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=759"}],"version-history":[{"count":8,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions"}],"predecessor-version":[{"id":808,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions\/808"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/media\/794"}],"wp:attachment":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}