{"id":40746,"date":"2023-11-13T18:48:11","date_gmt":"2024-01-14T23:01:10","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/"},"modified":"2024-05-04T08:51:38","modified_gmt":"2024-05-04T00:51:38","slug":"%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/","title":{"rendered":"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22"},"content":{"rendered":"<p>\u867d\u7136\u5982\u6b64\uff0c\u4e0d\u76f4\u63a5\u4f7f\u7528MySQL\u8fdb\u884c\u5168\u6587\u641c\u7d22\uff0c\u800c\u662f\u5c06MySQL\u6570\u636e\u5bfc\u5165\u5230Elasticsearch\uff0c\u5e76\u5728Elasticsearch\u4e2d\u8fdb\u884c\u5168\u6587\u641c\u7d22\u3002\u4f7f\u7528\u7684\u64cd\u4f5c\u7cfb\u7edf\u662fCentOS7\u3002<\/p>\n<h1>\u6700\u5f00\u59cb<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Elasticsearch\u306f\u5404\u7a2e\u30d7\u30e9\u30b0\u30a4\u30f3\u306a\u3069\u30de\u30a4\u30ca\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3082\u304b\u306a\u308a\u30b7\u30d3\u30a2\u3067\u3059\u3002\u30c8\u30e9\u30d6\u30eb\u56de\u907f\u306e\u305f\u3081\u306b\u3082\u3001\u3059\u3079\u3066\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u5b8c\u5168\u306b\u5408\u308f\u305b\u307e\u3057\u3087\u3046\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u3053\u306e\u6295\u7a3f\u3082\u5c06\u6765\u7684\u306b\u52d5\u304b\u306a\u3044\u53ef\u80fd\u6027\u3082\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u969b\u306f\u3001\u6700\u65b0\u7248\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u3002\u79c1\u306f\u9069\u5f53\u306b\u30b0\u30b0\u3063\u3066\u30d0\u30fc\u30b8\u30e7\u30f3\u9055\u3044\u3067\u30cf\u30de\u3063\u305f\u306e\u3067\u2026\u3002<\/ul>\n<h1>\u5de8\u5927\u7684\u6d2a\u6d41<\/h1>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u51c6\u5907<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5b89\u88c5Elasticsearch 1.7.1\uff08\u6700\u65b0\u7248\u4e8e2015\/08\/19\u53d1\u5e03\uff09<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5b89\u88c5\u548c\u8bbe\u7f6eElasticsearch\u7684\u63d2\u4ef6<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u51c6\u5907\u6570\u636e\u5728MariaDB\u4e0a<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u914d\u7f6ejdbc\u8fde\u63a5<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u5728MariaDB\u4e0a\u4fee\u6539\u6570\u636e<\/ol>\n<p>\u8fd9\u6b21\u4e0d\u4f1a\u7ec4\u96c6\u7fa4\u3002\u5168\u90e8\u90fd\u4f1a\u7528\u4e00\u53f0\u673a\u5668\u6765\u505a\u3002<\/p>\n<h2>\u505a\u597d\u51c6\u5907<\/h2>\n<p>\u4ee5\u4e0b\u662fCentOS7\u3002<br \/>\n\u7531\u4e8eelasticsearch\u9700\u8981Java\uff0c\u56e0\u6b64\u9700\u8981\u5b89\u88c5Java\u3002\u6b64\u5916\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u6307\u4ee4\u5b89\u88c5jdk1.8\u3002<\/p>\n<pre class=\"post-pre\"><code># yum install java curl wget unzip\r\n<\/code><\/pre>\n<h2>\u5b89\u88c5\u6700\u65b0\u7248\u7684Elasticsearch 1.7.1\uff082015\/08\/19\uff09<\/h2>\n<p>\u6dfb\u52a0\u4ed3\u5e93\u3002\u8bf7\u6ce8\u610f\u7248\u672c\u6307\u5b9a\u3002<\/p>\n<pre class=\"post-pre\"><code># vi \/etc\/yum.repos.d\/elasticsearch.repo\r\n-----\r\n[elasticsearch-1.7]\r\nname=Elasticsearch repository for 1.7.x packages\r\nbaseurl=http:\/\/packages.elastic.co\/elasticsearch\/1.7\/centos\r\ngpgcheck=1\r\ngpgkey=http:\/\/packages.elastic.co\/GPG-KEY-elasticsearch\r\nenabled=1\r\n-----\r\n# yum install elasticsearch\r\n<\/code><\/pre>\n<p>\u987a\u4fbf\u63d0\u4e00\u4e0b\uff0celasticsearch\u4f1a\u5b89\u88c5\u5728\/usr\/share\/elasticsearch\u76ee\u5f55\u4e0b\u3002<\/p>\n<h2>3. \u5b89\u88c5\u548c\u914d\u7f6eElasticsearch\u7684\u63d2\u4ef6<\/h2>\n<h3>\u5404\u79cd\u63d2\u4ef6 (g\u00e8<\/h3>\n<p>\u786e\u8ba4\u5e94\u5b89\u88c5\u7684kuromoji\u7248\u672c\uff0c\u8bf7\u67e5\u770b\u8fd9\u91cc\u3002\u7248\u672c\u5e94\u4e25\u683c\u5bf9\u5e94\u3002\u94fe\u63a5\uff1ahttps:\/\/github.com\/elastic\/elasticsearch-analysis-kuromoji<\/p>\n<pre class=\"post-pre\"><code># \/usr\/share\/elasticsearch\/bin\/plugin -install elasticsearch\/elasticsearch-analysis-kuromoji\/2.7.0\r\n# \/usr\/share\/elasticsearch\/bin\/plugin -install mobz\/elasticsearch-head\r\n<\/code><\/pre>\n<h3>Elasticsearch\u7684\u542f\u52a8\u548c\u81ea\u52a8\u542f\u52a8\u8bbe\u7f6e<\/h3>\n<pre class=\"post-pre\"><code># systemctl start elasticsearch.service\r\n# systemctl enable elasticsearch.service\r\n# systemctl daemon-reload\r\n<\/code><\/pre>\n<h3>\u5bf9Elasticsearch\u8fdb\u884c\u8fd0\u884c\u9a8c\u8bc1<\/h3>\n<pre class=\"post-pre\"><code># curl http:\/\/localhost:9200\r\n<\/code><\/pre>\n<h3>\u786e\u8ba4\u80fd\u591f\u901a\u8fc7\u7f51\u7edc\u6d4f\u89c8\u5668\u4ece\u5916\u90e8\u8bbf\u95ee\u3002<\/h3>\n<p>\uff08\u203bIP\u5730\u5740\u4e3a192.168.0.33\uff0c\u8bf7\u6ce8\u610fselinux\u548cfirewalld\uff09<br \/>\nhttp:\/\/192.168.0.33:9200\/_plugin\/head\/<\/p>\n<h3>\u786e\u8ba4Elasticsearch\u7684\u63d2\u4ef6\u3002<\/h3>\n<pre class=\"post-pre\"><code># curl -XGET 'http:\/\/localhost:9200\/_nodes?plugin=true&amp;pretty'\r\n   :\r\n      \"plugins\" : [ {\r\n        \"name\" : \"analysis-kuromoji\",\r\n        \"version\" : \"2.7.0\",\r\n        \"description\" : \"Kuromoji analysis support\",\r\n        \"jvm\" : true,\r\n        \"site\" : false\r\n      }, {\r\n        \"name\" : \"head\",\r\n        \"version\" : \"NA\",\r\n        \"description\" : \"No description found.\",\r\n        \"url\" : \"\/_plugin\/head\/\",\r\n        \"jvm\" : false,\r\n        \"site\" : true\r\n      } ]\r\n  :\r\n<\/code><\/pre>\n<h3>\u67e5\u770bElasticsearch\u7684\u65e5\u5fd7<\/h3>\n<p>\u5e0c\u671b\u6ca1\u6709\u53d1\u751f\u4efb\u4f55\u9519\u8bef&#8230;\u3002<\/p>\n<pre class=\"post-pre\"><code># less \/var\/log\/elasticsearch\/elasticsearch.log\r\n<\/code><\/pre>\n<h3>\u5c06kuromoji\u8bbe\u7f6e\u4e3a\u9ed8\u8ba4\u7684\u5206\u8bcd\u5668\u3002<\/h3>\n<pre class=\"post-pre\"><code># vi \/etc\/elasticsearch\/elasticsearch.yml\r\n-----\r\nindex.analysis.analyzer.default.type: custom\r\nindex.analysis.analyzer.default.tokenizer: kuromoji_tokenizer\r\n-----\r\n# systemctl restart elasticsearch.service\r\n<\/code><\/pre>\n<h2>4. \u5728MariaDB\u4e2d\u51c6\u5907\u6570\u636e\u3002<\/h2>\n<h3>\u4e0eMariaDB\u7684\u5408\u4f5c<\/h3>\n<p>\u73b0\u5728\uff0c\u6211\u4eec\u5df2\u7ecf\u51c6\u5907\u5c31\u7eea\u3002\u7ec8\u4e8e\u8f6e\u5230MariaDB\uff08MySQL\uff09\u7684\u534f\u4f5c\u4e86\u3002\u7136\u800c\uff0c\u5728\u5f00\u59cb\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u51c6\u5907\u539f\u59cb\u6570\u636e\u3002\u5982\u679c\u60a8\u5df2\u7ecf\u6709\u793a\u4f8b\u6570\u636e\uff0c\u90a3\u4e48\u60a8\u53ef\u4ee5\u8df3\u8fc7\u4e0b\u4e00\u6b65\u3002\u8bf7\u51c6\u5907\u597dselect\u8bed\u53e5\u3002<\/p>\n<h3>\u51c6\u5907\u6570\u636e<\/h3>\n<p>\u6211\u5c06\u4f7f\u7528\u5168\u56fd\u90ae\u653f\u7f16\u7801\u6570\u636e\u3002\u5927\u7ea6\u670912\u4e07\u6761\u6570\u636e\u3002\u56e0\u6b64\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u5c06\u5168\u56fd\u90ae\u653f\u7f16\u7801\u6570\u636e\u6700\u5feb\u901f\u5730\u5b58\u5165MySQL\uff08MariaDB\uff09\u7684\u65b9\u6cd5\u3002<\/p>\n<h2>\u5728\u4f7f\u7528JDBC\u534f\u8bae\u8fdb\u884c\u8fde\u63a5\u4e4b\u524d<\/h2>\n<p>\u53c2\u8003\u306b\u3057\u3001\u5fc5\u8981\u306a\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u308c\u306felasticsearch\u672c\u4f53\u3068\u53b3\u5bc6\u306b\u4e00\u81f4\u3055\u305b\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u79c1\u306f\u30cf\u30de\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002<br \/>\n\u304b\u3064\u3066\u306friver\u30d7\u30e9\u30b0\u30a4\u30f3\u3068\u3057\u3066\u63d0\u4f9b\u3055\u308c\u3066\u3044\u305f\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u3053\u308c\u306b\u3082\u30cf\u30de\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u691c\u7d22\u3059\u308b\u3068\u60c5\u5831\u304c\u932f\u7d9c\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u3053\u306ejdbc\u9023\u643a\u306f\u30d7\u30e9\u30b0\u30a4\u30f3\u3067\u306f\u306a\u304f\u3001\u5358\u72ec\u306e\u30c4\u30fc\u30eb\u3068\u3057\u3066\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n<h2>5. JDBC\u534f\u8bae\u8fde\u63a5<\/h2>\n<h3>\u4e0b\u8f09\u7528\u65bc Elasticsearch 1.7.1 \u7684 JDBC \u9023\u63a5\u5de5\u5177\u3002<\/h3>\n<p>\u73b0\u5728\u662f2015\u5e748\u670819\u65e5\uff0c\u4f7f\u7528wget\u547d\u4ee4\u4e0b\u8f7d\u3002<\/p>\n<pre class=\"post-pre\"><code># wget http:\/\/xbib.org\/repository\/org\/xbib\/elasticsearch\/importer\/elasticsearch-jdbc\/1.7.1.0\/elasticsearch-jdbc-1.7.1.0-dist.zip\r\n# unzip elasticsearch-jdbc-1.7.1.0-dist.zip\r\n# cd elasticsearch-jdbc-1.7.1.0\/\r\n# ls lib\r\n<\/code><\/pre>\n<p>\u5728ls\u547d\u4ee4\u4e0b\uff0c\u6211\u4eec\u80fd\u786e\u8ba4mysql-connector-java-5.1.33.jar\u6587\u4ef6\u662f\u5426\u5df2\u7ecf\u5b58\u5728\u3002<br \/>\n\u6240\u4ee5\uff0c\u4e0d\u9700\u8981\u5355\u72ec\u4e0b\u8f7d\u5b83\u3002<\/p>\n<h3>\u521b\u5efaJDBC\u94fe\u63a5\u811a\u672c\uff08\u540c\u6b65\u811a\u672c\uff09\u3002<\/h3>\n<pre class=\"post-pre\"><code># cd bin\/\r\n# pwd \r\n\/root\/elasticsearch-jdbc-1.7.1.0\/bin\r\n# ls\r\n<\/code><\/pre>\n<p>\u6709\u8bb8\u591a\u4e0d\u540c\u7684\u811a\u672c\u53ef\u4f9b\u9009\u62e9\uff0c\u4f46\u6211\u5c06\u9009\u62e9\u6700\u7b80\u5355\u5374\u6709\u70b9\u51f6\u6076\u7684\u201cmysql-delete-document.sh\u201d\u4f5c\u4e3a\u57fa\u7840\u3002<\/p>\n<pre class=\"post-pre\"><code># cp mysql-delete-document.sh mysql-oreore.sh\r\n# vi mysql-oreore.sh\r\n-----\r\n    \"jdbc\" : {\r\n        \"url\" : \"jdbc:mysql:\/\/localhost:3306\/sampledb\",\r\n        \"user\" : \"root\",\r\n        \"password\" : \"\",\r\n        \"sql\" :  \"select id as _id, jiscode, zipcode_old, zipcode, pref_kana, city_kana, street_kana, pref, city, street from zipcode\"\r\n    }\r\n-----\r\n<\/code><\/pre>\n<p>\u6211\u5c06\u7f16\u8f91mysql\u7684\u8fde\u63a5\u914d\u7f6e\u548csql\u3002\u7136\u540e\uff0c\u5728jdbc\u90e8\u5206\uff0c\u5b83\u53d8\u6210\u4e86\u4e0a\u9762\u7684\u6837\u5b50\u3002<br \/>\n\u8fd9\u4e2asql\u662f\u7528\u6765\u5c06\u5168\u56fd\u90ae\u653f\u7f16\u7801\u6570\u636e\u5c3d\u5feb\u653e\u5165MySQL\uff08MariaDB\uff09\u7684\u3002<br \/>\n\u91cd\u8981\u7684\u5730\u65b9\u662f\uff0c\u5728select\u8bed\u53e5\u4e2d\u7684&#8217;id as _id&#8217;\uff0c\u5c06_id\u6307\u5b9a\u4e3a\u552f\u4e00\u7684id\u3002<\/p>\n<h3>\u6267\u884c\u540c\u6b65\u811a\u672c<\/h3>\n<p>\u73b0\u5728\uff0c\u4e00\u5207\u51c6\u5907\u5c31\u7eea\uff0c\u6211\u4eec\u5f00\u59cb\u6267\u884c\u4eceMySQL\u5230Elasticsearch\u7684\u6570\u636e\u5bfc\u5165\u3002\u8bf7\u8fd0\u884c\u4e0b\u9762\u7684\u540c\u6b65\u811a\u672c\uff0c\u5e76\u7a0d\u7b49\u7247\u523b\u3002<\/p>\n<pre class=\"post-pre\"><code># .\/mysql-oreore.sh\r\n<\/code><\/pre>\n<h3>\u5728Elasticsearch\u4e2d\u6267\u884c\u641c\u7d22<\/h3>\n<pre class=\"post-pre\"><code># curl -XGET 'http:\/\/localhost:9200\/jdbc\/_search?pretty=true' -d '\r\n{\r\n  \"query\": {\r\n    \"match\": {\r\n      \"street\": \"\u9234\u6728\"\r\n    }\r\n  }\r\n}\r\n'\r\n<\/code><\/pre>\n<p>\u641c\u7d22\u7ed3\u679c\u5171\u67093\u6761\u3002<\/p>\n<pre class=\"post-pre\"><code> :\r\n  \"hits\" : {\r\n    \"total\" : 3,\r\n    \"max_score\" : 10.423999,\r\n    \"hits\" : [ {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"26915\",\r\n      \"_score\" : 10.423999,\r\n      \"_source\":{\"jiscode\":\"08443\",\"zipcode_old\":\"30003\",\"zipcode\":\"3000334\",\"pref_kana\":\"\u30a4\u30d0\u30e9\u30ad\u30b1\u30f3\",\"city_kana\":\"\u30a4\u30ca\u30b7\u30ad\u30b0\u30f3\u30a2\u30df\u30de\u30c1\",\"street_kana\":\"\u30b9\u30ba\u30ad\",\"pref\":\"\u8328\u57ce\u770c\",\"city\":\"\u7a32\u6577\u90e1\u963f\u898b\u753a\",\"street\":\"\u9234\u6728\"}\r\n    }, {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"41720\",\r\n      \"_score\" : 6.5149994,\r\n      \"_source\":{\"jiscode\":\"14131\",\"zipcode_old\":\"210  \",\"zipcode\":\"2100801\",\"pref_kana\":\"\u30ab\u30ca\u30ac\u30ef\u30b1\u30f3\",\"city_kana\":\"\u30ab\u30ef\u30b5\u30ad\u30b7\u30ab\u30ef\u30b5\u30ad\u30af\",\"street_kana\":\"\u30b9\u30ba\u30ad\u30c1\u30e7\u30a6\",\"pref\":\"\u795e\u5948\u5ddd\u770c\",\"city\":\"\u5ddd\u5d0e\u5e02\u5ddd\u5d0e\u533a\",\"street\":\"\u9234\u6728\u753a\"}\r\n    }, {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"40372\",\r\n      \"_score\" : 6.514974,\r\n      \"_source\":{\"jiscode\":\"13211\",\"zipcode_old\":\"187  \",\"zipcode\":\"1870011\",\"pref_kana\":\"\u30c8\u30a6\u30ad\u30e7\u30a6\u30c8\",\"city_kana\":\"\u30b3\u30c0\u30a4\u30e9\u30b7\",\"street_kana\":\"\u30b9\u30ba\u30ad\u30c1\u30e7\u30a6\",\"pref\":\"\u6771\u4eac\u90fd\",\"city\":\"\u5c0f\u5e73\u5e02\",\"street\":\"\u9234\u6728\u753a\"}\r\n    } ]\r\n  }\r\n :\r\n<\/code><\/pre>\n<p>\u65e0\u4e8b\u641c\u7d22\u5230\u4e86\u3002\u592a\u68d2\u4e86\u3002<\/p>\n<h2>6. \u5728MariaDB\u4e2d\u8fdb\u884c\u6570\u636e\u66f4\u6539\u3002<\/h2>\n<p>\u73b0\u5728\uff0c\u90ae\u653f\u7f16\u7801\u5e76\u4e0d\u662f\u6bcf\u5929\u90fd\u4f1a\u6539\u53d8\uff0c\u4f46\u5b9e\u9645\u4e0a\u5b83\u4eec\u786e\u5b9e\u4f1a\u76f8\u5f53\u9891\u7e41\u5730\u53d8\u5316\u3002<br \/>\n\u5982\u679c\u6570\u636e\u53d1\u751f\u4e86\u66f4\u6539\uff0c\u90a3\u4f1a\u600e\u6837\u5462\uff1f<\/p>\n<h3>MariaDB\u6570\u636e\u7684\u4fee\u6539<\/h3>\n<p>\u6211\u4f1a\u5728\u66f4\u65b0\u6587\u4ef6\u4e2d\u8fdb\u884c\u4fee\u6539\u3002<\/p>\n<pre class=\"post-pre\"><code># mysql sampledb\r\nMariaDB [sampledb]&gt; select * from zipcode where id = 26915 \\G\r\nMariaDB [sampledb]&gt; update zipcode set street = '\u9234\u6728\u3055\u3093' where id = 26915;\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\nMariaDB [sampledb]&gt; \\q\r\n<\/code><\/pre>\n<p>\u6211\u5c06\u4f7f\u7528\u521a\u624d\u7684\u547d\u4ee4\u518d\u6b21\u67e5\u8be2\u4e00\u6b21\uff0c\u4f46\u663e\u7136\u7ed3\u679c\u76f8\u540c\u3002<br \/>\n\u56e0\u6b64\uff0c\u6211\u5c06\u518d\u6b21\u8fd0\u884c\u540c\u6b65\u7a0b\u5e8f\u3002<\/p>\n<pre class=\"post-pre\"><code># .\/mysql-oreore.sh\r\n<\/code><\/pre>\n<p>\u91cd\u65b0\u641c\u7d22\u3002<\/p>\n<pre class=\"post-pre\"><code># curl -XGET 'http:\/\/localhost:9200\/jdbc\/_search?pretty=true' -d '\r\n{\r\n  \"query\": {\r\n    \"match\": {\r\n      \"street\": \"\u9234\u6728\"\r\n    }\r\n  }\r\n}\r\n'\r\n<\/code><\/pre>\n<p>\u7136\u540e\uff0c&#8230;<\/p>\n<pre class=\"post-pre\"><code>{\r\n :\r\n  \"hits\" : {\r\n    \"total\" : 3,\r\n    \"max_score\" : 6.5149994,\r\n    \"hits\" : [ {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"26915\",\r\n      \"_score\" : 6.5149994,\r\n      \"_source\":{\"jiscode\":\"08443\",\"zipcode_old\":\"30003\",\"zipcode\":\"3000334\",\"pref_kana\":\"\u30a4\u30d0\u30e9\u30ad\u30b1\u30f3\",\"city_kana\":\"\u30a4\u30ca\u30b7\u30ad\u30b0\u30f3\u30a2\u30df\u30de\u30c1\",\"street_kana\":\"\u30b9\u30ba\u30ad\",\"pref\":\"\u8328\u57ce\u770c\",\"city\":\"\u7a32\u6577\u90e1\u963f\u898b\u753a\",\"street\":\"\u9234\u6728\u3055\u3093\"}\r\n    }, {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"41720\",\r\n      \"_score\" : 6.5149994,\r\n      \"_source\":{\"jiscode\":\"14131\",\"zipcode_old\":\"210  \",\"zipcode\":\"2100801\",\"pref_kana\":\"\u30ab\u30ca\u30ac\u30ef\u30b1\u30f3\",\"city_kana\":\"\u30ab\u30ef\u30b5\u30ad\u30b7\u30ab\u30ef\u30b5\u30ad\u30af\",\"street_kana\":\"\u30b9\u30ba\u30ad\u30c1\u30e7\u30a6\",\"pref\":\"\u795e\u5948\u5ddd\u770c\",\"city\":\"\u5ddd\u5d0e\u5e02\u5ddd\u5d0e\u533a\",\"street\":\"\u9234\u6728\u753a\"}\r\n    }, {\r\n      \"_index\" : \"jdbc\",\r\n      \"_type\" : \"jdbc\",\r\n      \"_id\" : \"40372\",\r\n      \"_score\" : 6.514974,\r\n      \"_source\":{\"jiscode\":\"13211\",\"zipcode_old\":\"187  \",\"zipcode\":\"1870011\",\"pref_kana\":\"\u30c8\u30a6\u30ad\u30e7\u30a6\u30c8\",\"city_kana\":\"\u30b3\u30c0\u30a4\u30e9\u30b7\",\"street_kana\":\"\u30b9\u30ba\u30ad\u30c1\u30e7\u30a6\",\"pref\":\"\u6771\u4eac\u90fd\",\"city\":\"\u5c0f\u5e73\u5e02\",\"street\":\"\u9234\u6728\u753a\"}\r\n    } ]\r\n  }\r\n :\r\n<\/code><\/pre>\n<p>\u54c7\uff0c\u7b2c\u4e00\u6761\u6570\u636e\u4ece\u201c\u9234\u6728\u201d\u6210\u529f\u53d8\u66f4\u4e3a\u201c\u9234\u6728\u3055\u3093\u201d\uff01<\/p>\n<p>&#8216;_id&#8217;\u662f\u91cd\u8981\u7684\uff0c\u5982\u679c\u6ca1\u6709\u6307\u5b9a\uff0c\u7cfb\u7edf\u4f1a\u81ea\u52a8\u5206\u914d_id\uff0c\u5e76\u4e14\u5728\u8fd0\u884cjdbc\u540c\u6b65\u811a\u672c\u65f6\u6bcf\u6b21\u90fd\u4f1a\u6dfb\u52a0\uff0c\u5bfc\u81f4\u91cd\u590d\u6570\u636e\u7684\u4ea7\u751f\u3002<\/p>\n<h2>7. \u603b\u7ed3<\/h2>\n<p>\u6211\u7528\u4e00\u79cd\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u8bd5\u7740\u505a\u4e86\u4e00\u904d\uff0c\u76f4\u5230\u5b83\u52a8\u8d77\u6765\u3002<\/p>\n<p>\u5373\u4f7f\u6709\u590d\u6742\u7684\u8868\u7ed3\u6784\uff0c\u53ea\u8981\u4fee\u6539select\u8bed\u53e5\uff0c\u5c31\u53ef\u4ee5\u8fdb\u884c\u5404\u79cd\u641c\u7d22\uff0c\u5e76\u4e14\u53ef\u4ee5\u4f7f\u7528crontab\u5b9a\u671f\u8fd0\u884c\u540c\u6b65\u811a\u672c\uff0c\u5728\u6570\u636e\u91cf\u4e0d\u591a\u4e14\u53d8\u5316\u4e0d\u5927\u7684\u60c5\u51b5\u4e0b\uff0c\u5927\u7ea6\u51e0\u4e07\u6761\u6570\u636e\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n<p>\u5b9e\u9645\u4e0a\uff0c\u5728Elasticsearch\u4e2d\u9700\u8981\u8fdb\u884c\u6a21\u5f0f\u8bbe\u7f6e\u548c\u96c6\u7fa4\u914d\u7f6e\u3002<\/p>\n<p>\u53e6\u5916\uff0c\u5982\u679c\u67e5\u770bbin\u76ee\u5f55\u4e2d\u4e0eschedule\u76f8\u5173\u7684\u811a\u672c\uff0c\u6bd4\u5982https:\/\/github.com\/jprante\/elasticsearch-jdbc\uff0c\u4f3c\u4e4e\u53ef\u4ee5\u66f4\u9ad8\u6548\u5730\u8fd0\u884c\u3002\u8bf7\u6ce8\u610f\uff0c\u6b64\u6b21\u64cd\u4f5c\u6d89\u53ca\u5168\u91cf\u83b7\u53d6\uff0c\u56e0\u6b64\u4f1a\u7a0d\u5fae\u5360\u7528\u4e00\u4e9b\u8d44\u6e90\u3002<\/p>\n<p>\u6700\u597d\u4e0d\u8981\u5728Elasticsearch\u4e2d\u8fdb\u884c\u641c\u7d22\u5e76\u6355\u83b7ID\uff0c\u7136\u540e\u5728MySQL\u4e2d\u901a\u8fc7IN\u8fdb\u884c\u7b5b\u9009\u3002\u6700\u597d\u5c06\u6240\u6709\u4e0e\u5c55\u793a\u65e0\u5173\u4f46\u662f\u5fc5\u8981\u7684\u6570\u636e\u4e00\u8d77\u5e26\u5230Elasticsearch\uff0c\u5e76\u4ec5\u901a\u8fc7Elasticsearch\u7684\u641c\u7d22\u7ed3\u679c\u521b\u5efa\u753b\u9762\u3002\u4f46\u662f\uff0c\u8bf7\u6ce8\u610f\u5bf9\u4e8e\u5bf9\u65f6\u95f4\u5ef6\u8fdf\u8981\u6c42\u654f\u611f\u7684\u9700\u6c42\u9700\u8981\u5c0f\u5fc3\u5904\u7406\u65f6\u95f4\u5ef6\u8fdf\u3002<\/p>\n<h2>\u5982\u679c\u8981\u91cd\u65b0\u8fdb\u884c\u5168\u90e8\u64cd\u4f5c\uff0c\u8bf7\u5220\u9664\u7d22\u5f15\u3002<\/h2>\n<pre class=\"post-pre\"><code># curl -XDELETE 'http:\/\/localhost:9200\/jdbc'\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u867d\u7136\u5982\u6b64\uff0c\u4e0d\u76f4\u63a5\u4f7f\u7528MySQL\u8fdb\u884c\u5168\u6587\u641c\u7d22\uff0c\u800c\u662f\u5c06MySQL\u6570\u636e\u5bfc\u5165\u5230Elasticsearch\uff0c\u5e76\u5728Elas [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40746","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528elasticsearch\u5b9e\u73b0\u5bf9mysql\uff08mariadb\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\" \/>\n<meta property=\"og:description\" content=\"\u867d\u7136\u5982\u6b64\uff0c\u4e0d\u76f4\u63a5\u4f7f\u7528MySQL\u8fdb\u884c\u5168\u6587\u641c\u7d22\uff0c\u800c\u662f\u5c06MySQL\u6570\u636e\u5bfc\u5165\u5230Elasticsearch\uff0c\u5e76\u5728Elas [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528elasticsearch\u5b9e\u73b0\u5bf9mysql\uff08mariadb\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-14T23:01:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T00:51:38+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/\",\"name\":\"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-01-14T23:01:10+00:00\",\"dateModified\":\"2024-05-04T00:51:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528elasticsearch\u5b9e\u73b0\u5bf9mysql\uff08mariadb\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22","og_description":"\u867d\u7136\u5982\u6b64\uff0c\u4e0d\u76f4\u63a5\u4f7f\u7528MySQL\u8fdb\u884c\u5168\u6587\u641c\u7d22\uff0c\u800c\u662f\u5c06MySQL\u6570\u636e\u5bfc\u5165\u5230Elasticsearch\uff0c\u5e76\u5728Elas [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528elasticsearch\u5b9e\u73b0\u5bf9mysql\uff08mariadb\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-01-14T23:01:10+00:00","article_modified_time":"2024-05-04T00:51:38+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/","name":"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-01-14T23:01:10+00:00","dateModified":"2024-05-04T00:51:38+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Elasticsearch\u5b9e\u73b0\u5bf9MySQL\uff08MariaDB\uff09\u6570\u636e\u7684\u5168\u6587\u68c0\u7d22"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8elasticsearch%e5%ae%9e%e7%8e%b0%e5%af%b9mysql%ef%bc%88mariadb%ef%bc%89%e6%95%b0%e6%8d%ae%e7%9a%84%e5%85%a8%e6%96%87%e6%a3%80%e7%b4%a2%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=40746"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40746\/revisions"}],"predecessor-version":[{"id":97337,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40746\/revisions\/97337"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=40746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=40746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=40746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}