{"id":4006,"date":"2019-12-05T10:16:53","date_gmt":"2019-12-05T02:16:53","guid":{"rendered":"https:\/\/damogame.cn\/wordpress\/?p=4006"},"modified":"2019-12-05T10:16:53","modified_gmt":"2019-12-05T02:16:53","slug":"leaf-%e7%be%8e%e5%9b%a2%e7%82%b9%e8%af%84%e5%88%86%e5%b8%83%e5%bc%8fid%e7%94%9f%e6%88%90%e7%b3%bb%e7%bb%9f","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/4006","title":{"rendered":"Leaf\u2014\u2014\u7f8e\u56e2\u70b9\u8bc4\u5206\u5e03\u5f0fID\u751f\u6210\u7cfb\u7edf"},"content":{"rendered":"<p class=\"post-title\"><a href=\"https:\/\/tech.meituan.com\/2017\/04\/21\/mt-leaf.html\">\u539f\u6587\u5730\u5740<\/a><\/p>\n<p>&nbsp;<\/p>\n<div class=\"meta-box\"><span class=\"m-post-date\"><i class=\"fa fa-calendar-o\"><\/i>2017\u5e7404\u670821\u65e5<\/span>\u00a0<span class=\"m-post-nick\">\u4f5c\u8005: \u7167\u4e1c<\/span>\u00a0<span class=\"m-post-permalink\"><i class=\"fa fa-link-o\"><\/i><a href=\"https:\/\/tech.meituan.com\/2017\/04\/21\/mt-leaf.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u6587\u7ae0\u94fe\u63a5<\/a><\/span>\u00a0<span class=\"m-post-count\"><i class=\"fa fa-pencil\"><\/i>6154\u5b57<\/span>\u00a0<span class=\"m-post-reading\"><i class=\"fa fa-hourglass-start\"><\/i>13\u5206\u949f\u9605\u8bfb<\/span><\/div>\n<div class=\"post-content\">\n<div class=\"content\">\n<p>\u5728\u590d\u6742\u5206\u5e03\u5f0f\u7cfb\u7edf\u4e2d\uff0c\u5f80\u5f80\u9700\u8981\u5bf9\u5927\u91cf\u7684\u6570\u636e\u548c\u6d88\u606f\u8fdb\u884c\u552f\u4e00\u6807\u8bc6\u3002\u5982\u5728\u7f8e\u56e2\u70b9\u8bc4\u7684\u91d1\u878d\u3001\u652f\u4ed8\u3001\u9910\u996e\u3001\u9152\u5e97\u3001\u732b\u773c\u7535\u5f71\u7b49\u4ea7\u54c1\u7684\u7cfb\u7edf\u4e2d\uff0c\u6570\u636e\u65e5\u6e10\u589e\u957f\uff0c\u5bf9\u6570\u636e\u5206\u5e93\u5206\u8868\u540e\u9700\u8981\u6709\u4e00\u4e2a\u552f\u4e00ID\u6765\u6807\u8bc6\u4e00\u6761\u6570\u636e\u6216\u6d88\u606f\uff0c\u6570\u636e\u5e93\u7684\u81ea\u589eID\u663e\u7136\u4e0d\u80fd\u6ee1\u8db3\u9700\u6c42\uff1b\u7279\u522b\u4e00\u70b9\u7684\u5982\u8ba2\u5355\u3001\u9a91\u624b\u3001\u4f18\u60e0\u5238\u4e5f\u90fd\u9700\u8981\u6709\u552f\u4e00ID\u505a\u6807\u8bc6\u3002\u6b64\u65f6\u4e00\u4e2a\u80fd\u591f\u751f\u6210\u5168\u5c40\u552f\u4e00ID\u7684\u7cfb\u7edf\u662f\u975e\u5e38\u5fc5\u8981\u7684\u3002\u6982\u62ec\u4e0b\u6765\uff0c\u90a3\u4e1a\u52a1\u7cfb\u7edf\u5bf9ID\u53f7\u7684\u8981\u6c42\u6709\u54ea\u4e9b\u5462\uff1f<\/p>\n<ol>\n<li>\u5168\u5c40\u552f\u4e00\u6027\uff1a\u4e0d\u80fd\u51fa\u73b0\u91cd\u590d\u7684ID\u53f7\uff0c\u65e2\u7136\u662f\u552f\u4e00\u6807\u8bc6\uff0c\u8fd9\u662f\u6700\u57fa\u672c\u7684\u8981\u6c42\u3002<\/li>\n<li>\u8d8b\u52bf\u9012\u589e\uff1a\u5728MySQL InnoDB\u5f15\u64ce\u4e2d\u4f7f\u7528\u7684\u662f\u805a\u96c6\u7d22\u5f15\uff0c\u7531\u4e8e\u591a\u6570RDBMS\u4f7f\u7528B-tree\u7684\u6570\u636e\u7ed3\u6784\u6765\u5b58\u50a8\u7d22\u5f15\u6570\u636e\uff0c\u5728\u4e3b\u952e\u7684\u9009\u62e9\u4e0a\u9762\u6211\u4eec\u5e94\u8be5\u5c3d\u91cf\u4f7f\u7528\u6709\u5e8f\u7684\u4e3b\u952e\u4fdd\u8bc1\u5199\u5165\u6027\u80fd\u3002<\/li>\n<li>\u5355\u8c03\u9012\u589e\uff1a\u4fdd\u8bc1\u4e0b\u4e00\u4e2aID\u4e00\u5b9a\u5927\u4e8e\u4e0a\u4e00\u4e2aID\uff0c\u4f8b\u5982\u4e8b\u52a1\u7248\u672c\u53f7\u3001IM\u589e\u91cf\u6d88\u606f\u3001\u6392\u5e8f\u7b49\u7279\u6b8a\u9700\u6c42\u3002<\/li>\n<li>\u4fe1\u606f\u5b89\u5168\uff1a\u5982\u679cID\u662f\u8fde\u7eed\u7684\uff0c\u6076\u610f\u7528\u6237\u7684\u6252\u53d6\u5de5\u4f5c\u5c31\u975e\u5e38\u5bb9\u6613\u505a\u4e86\uff0c\u76f4\u63a5\u6309\u7167\u987a\u5e8f\u4e0b\u8f7d\u6307\u5b9aURL\u5373\u53ef\uff1b\u5982\u679c\u662f\u8ba2\u5355\u53f7\u5c31\u66f4\u5371\u9669\u4e86\uff0c\u7ade\u5bf9\u53ef\u4ee5\u76f4\u63a5\u77e5\u9053\u6211\u4eec\u4e00\u5929\u7684\u5355\u91cf\u3002\u6240\u4ee5\u5728\u4e00\u4e9b\u5e94\u7528\u573a\u666f\u4e0b\uff0c\u4f1a\u9700\u8981ID\u65e0\u89c4\u5219\u3001\u4e0d\u89c4\u5219\u3002<\/li>\n<\/ol>\n<p>\u4e0a\u8ff0123\u5bf9\u5e94\u4e09\u7c7b\u4e0d\u540c\u7684\u573a\u666f\uff0c3\u548c4\u9700\u6c42\u8fd8\u662f\u4e92\u65a5\u7684\uff0c\u65e0\u6cd5\u4f7f\u7528\u540c\u4e00\u4e2a\u65b9\u6848\u6ee1\u8db3\u3002<\/p>\n<p>\u540c\u65f6\u9664\u4e86\u5bf9ID\u53f7\u7801\u81ea\u8eab\u7684\u8981\u6c42\uff0c\u4e1a\u52a1\u8fd8\u5bf9ID\u53f7\u751f\u6210\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u8981\u6c42\u6781\u9ad8\uff0c\u60f3\u8c61\u4e00\u4e0b\uff0c\u5982\u679cID\u751f\u6210\u7cfb\u7edf\u762b\u75ea\uff0c\u6574\u4e2a\u7f8e\u56e2\u70b9\u8bc4\u652f\u4ed8\u3001\u4f18\u60e0\u5238\u53d1\u5238\u3001\u9a91\u624b\u6d3e\u5355\u7b49\u5173\u952e\u52a8\u4f5c\u90fd\u65e0\u6cd5\u6267\u884c\uff0c\u8fd9\u5c31\u4f1a\u5e26\u6765\u4e00\u573a\u707e\u96be\u3002<\/p>\n<p>\u7531\u6b64\u603b\u7ed3\u4e0b\u4e00\u4e2aID\u751f\u6210\u7cfb\u7edf\u5e94\u8be5\u505a\u5230\u5982\u4e0b\u51e0\u70b9\uff1a<\/p>\n<ol>\n<li>\u5e73\u5747\u5ef6\u8fdf\u548cTP999\u5ef6\u8fdf\u90fd\u8981\u5c3d\u53ef\u80fd\u4f4e\uff1b<\/li>\n<li>\u53ef\u7528\u60275\u4e2a9\uff1b<\/li>\n<li>\u9ad8QPS\u3002<\/li>\n<\/ol>\n<h3 id=\"uuid\">UUID<\/h3>\n<p>UUID(Universally Unique Identifier)\u7684\u6807\u51c6\u578b\u5f0f\u5305\u542b32\u4e2a16\u8fdb\u5236\u6570\u5b57\uff0c\u4ee5\u8fde\u5b57\u53f7\u5206\u4e3a\u4e94\u6bb5\uff0c\u5f62\u5f0f\u4e3a8-4-4-4-12\u768436\u4e2a\u5b57\u7b26\uff0c\u793a\u4f8b\uff1a<code>550e8400-e29b-41d4-a716-446655440000<\/code>\uff0c\u5230\u76ee\u524d\u4e3a\u6b62\u4e1a\u754c\u4e00\u5171\u67095\u79cd\u65b9\u5f0f\u751f\u6210UUID\uff0c\u8be6\u60c5\u89c1IETF\u53d1\u5e03\u7684UUID\u89c4\u8303\u00a0<a href=\"http:\/\/www.ietf.org\/rfc\/rfc4122.txt\">A Universally Unique IDentifier (UUID) URN Namespace<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>\u3002<\/p>\n<p>\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>\u6027\u80fd\u975e\u5e38\u9ad8\uff1a\u672c\u5730\u751f\u6210\uff0c\u6ca1\u6709\u7f51\u7edc\u6d88\u8017\u3002<\/li>\n<\/ul>\n<p>\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u4e0d\u6613\u4e8e\u5b58\u50a8\uff1aUUID\u592a\u957f\uff0c16\u5b57\u8282128\u4f4d\uff0c\u901a\u5e38\u4ee536\u957f\u5ea6\u7684\u5b57\u7b26\u4e32\u8868\u793a\uff0c\u5f88\u591a\u573a\u666f\u4e0d\u9002\u7528\u3002<\/li>\n<li>\u4fe1\u606f\u4e0d\u5b89\u5168\uff1a\u57fa\u4e8eMAC\u5730\u5740\u751f\u6210UUID\u7684\u7b97\u6cd5\u53ef\u80fd\u4f1a\u9020\u6210MAC\u5730\u5740\u6cc4\u9732\uff0c\u8fd9\u4e2a\u6f0f\u6d1e\u66fe\u88ab\u7528\u4e8e\u5bfb\u627e\u6885\u4e3d\u838e\u75c5\u6bd2\u7684\u5236\u4f5c\u8005\u4f4d\u7f6e\u3002<\/li>\n<li>ID\u4f5c\u4e3a\u4e3b\u952e\u65f6\u5728\u7279\u5b9a\u7684\u73af\u5883\u4f1a\u5b58\u5728\u4e00\u4e9b\u95ee\u9898\uff0c\u6bd4\u5982\u505aDB\u4e3b\u952e\u7684\u573a\u666f\u4e0b\uff0cUUID\u5c31\u975e\u5e38\u4e0d\u9002\u7528\uff1a\n<p>\u2460 MySQL\u5b98\u65b9\u6709\u660e\u786e\u7684\u5efa\u8bae\u4e3b\u952e\u8981\u5c3d\u91cf\u8d8a\u77ed\u8d8a\u597d[4]\uff0c36\u4e2a\u5b57\u7b26\u957f\u5ea6\u7684UUID\u4e0d\u7b26\u5408\u8981\u6c42\u3002<\/p>\n<blockquote class=\"with-icon\"><p><i class=\"fa fa-quote-left post-blockquote-icon\"><\/i><i class=\"fa fa-quote-left post-blockquote-icon\"><\/i>All indexes other than the clustered index are known as secondary indexes. In InnoDB, each record in a secondary index contains the primary key columns for the row, as well as the columns specified for the secondary index. InnoDB uses this primary key value to search for the row in the clustered index.*** If the primary key is long, the secondary indexes use more space, so it is advantageous to have a short primary key***.<\/p><\/blockquote>\n<\/li>\n<\/ul>\n<p>\u2461 \u5bf9MySQL\u7d22\u5f15\u4e0d\u5229\uff1a\u5982\u679c\u4f5c\u4e3a\u6570\u636e\u5e93\u4e3b\u952e\uff0c\u5728InnoDB\u5f15\u64ce\u4e0b\uff0cUUID\u7684\u65e0\u5e8f\u6027\u53ef\u80fd\u4f1a\u5f15\u8d77\u6570\u636e\u4f4d\u7f6e\u9891\u7e41\u53d8\u52a8\uff0c\u4e25\u91cd\u5f71\u54cd\u6027\u80fd\u3002<\/p>\n<h3 id=\"\u7c7bsnowflake\u65b9\u6848\">\u7c7bsnowflake\u65b9\u6848<\/h3>\n<p>\u8fd9\u79cd\u65b9\u6848\u5927\u81f4\u6765\u8bf4\u662f\u4e00\u79cd\u4ee5\u5212\u5206\u547d\u540d\u7a7a\u95f4\uff08UUID\u4e5f\u7b97\uff0c\u7531\u4e8e\u6bd4\u8f83\u5e38\u89c1\uff0c\u6240\u4ee5\u5355\u72ec\u5206\u6790\uff09\u6765\u751f\u6210ID\u7684\u4e00\u79cd\u7b97\u6cd5\uff0c\u8fd9\u79cd\u65b9\u6848\u628a64-bit\u5206\u522b\u5212\u5206\u6210\u591a\u6bb5\uff0c\u5206\u5f00\u6765\u6807\u793a\u673a\u5668\u3001\u65f6\u95f4\u7b49\uff0c\u6bd4\u5982\u5728snowflake\u4e2d\u768464-bit\u5206\u522b\u8868\u793a\u5982\u4e0b\u56fe\uff08\u56fe\u7247\u6765\u81ea\u7f51\u7edc\uff09\u6240\u793a\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/eee18df9.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>41-bit\u7684\u65f6\u95f4\u53ef\u4ee5\u8868\u793a\uff081L&lt;&lt;41\uff09\/(1000L*3600*24*365)=69\u5e74\u7684\u65f6\u95f4\uff0c10-bit\u673a\u5668\u53ef\u4ee5\u5206\u522b\u8868\u793a1024\u53f0\u673a\u5668\u3002\u5982\u679c\u6211\u4eec\u5bf9IDC\u5212\u5206\u6709\u9700\u6c42\uff0c\u8fd8\u53ef\u4ee5\u5c0610-bit\u52065-bit\u7ed9IDC\uff0c\u52065-bit\u7ed9\u5de5\u4f5c\u673a\u5668\u3002\u8fd9\u6837\u5c31\u53ef\u4ee5\u8868\u793a32\u4e2aIDC\uff0c\u6bcf\u4e2aIDC\u4e0b\u53ef\u4ee5\u670932\u53f0\u673a\u5668\uff0c\u53ef\u4ee5\u6839\u636e\u81ea\u8eab\u9700\u6c42\u5b9a\u4e49\u300212\u4e2a\u81ea\u589e\u5e8f\u5217\u53f7\u53ef\u4ee5\u8868\u793a2^12\u4e2aID\uff0c\u7406\u8bba\u4e0asnowflake\u65b9\u6848\u7684QPS\u7ea6\u4e3a409.6w\/s\uff0c\u8fd9\u79cd\u5206\u914d\u65b9\u5f0f\u53ef\u4ee5\u4fdd\u8bc1\u5728\u4efb\u4f55\u4e00\u4e2aIDC\u7684\u4efb\u4f55\u4e00\u53f0\u673a\u5668\u5728\u4efb\u610f\u6beb\u79d2\u5185\u751f\u6210\u7684ID\u90fd\u662f\u4e0d\u540c\u7684\u3002<\/p>\n<p>\u8fd9\u79cd\u65b9\u5f0f\u7684\u4f18\u7f3a\u70b9\u662f\uff1a<\/p>\n<p>\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>\u6beb\u79d2\u6570\u5728\u9ad8\u4f4d\uff0c\u81ea\u589e\u5e8f\u5217\u5728\u4f4e\u4f4d\uff0c\u6574\u4e2aID\u90fd\u662f\u8d8b\u52bf\u9012\u589e\u7684\u3002<\/li>\n<li>\u4e0d\u4f9d\u8d56\u6570\u636e\u5e93\u7b49\u7b2c\u4e09\u65b9\u7cfb\u7edf\uff0c\u4ee5\u670d\u52a1\u7684\u65b9\u5f0f\u90e8\u7f72\uff0c\u7a33\u5b9a\u6027\u66f4\u9ad8\uff0c\u751f\u6210ID\u7684\u6027\u80fd\u4e5f\u662f\u975e\u5e38\u9ad8\u7684\u3002<\/li>\n<li>\u53ef\u4ee5\u6839\u636e\u81ea\u8eab\u4e1a\u52a1\u7279\u6027\u5206\u914dbit\u4f4d\uff0c\u975e\u5e38\u7075\u6d3b\u3002<\/li>\n<\/ul>\n<p>\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u5f3a\u4f9d\u8d56\u673a\u5668\u65f6\u949f\uff0c\u5982\u679c\u673a\u5668\u4e0a\u65f6\u949f\u56de\u62e8\uff0c\u4f1a\u5bfc\u81f4\u53d1\u53f7\u91cd\u590d\u6216\u8005\u670d\u52a1\u4f1a\u5904\u4e8e\u4e0d\u53ef\u7528\u72b6\u6001\u3002<\/li>\n<\/ul>\n<h4 id=\"\u5e94\u7528\u4e3e\u4f8bmongdb-objectid\">\u5e94\u7528\u4e3e\u4f8bMongdb objectID<\/h4>\n<p><a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/method\/ObjectId\/#description\">MongoDB\u5b98\u65b9\u6587\u6863 ObjectID<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>\u53ef\u4ee5\u7b97\u4f5c\u662f\u548csnowflake\u7c7b\u4f3c\u65b9\u6cd5\uff0c\u901a\u8fc7\u201c\u65f6\u95f4+\u673a\u5668\u7801+pid+inc\u201d\u517112\u4e2a\u5b57\u8282\uff0c\u901a\u8fc74+3+2+3\u7684\u65b9\u5f0f\u6700\u7ec8\u6807\u8bc6\u6210\u4e00\u4e2a24\u957f\u5ea6\u7684\u5341\u516d\u8fdb\u5236\u5b57\u7b26\u3002<\/p>\n<h3 id=\"\u6570\u636e\u5e93\u751f\u6210\">\u6570\u636e\u5e93\u751f\u6210<\/h3>\n<p>\u4ee5MySQL\u4e3e\u4f8b\uff0c\u5229\u7528\u7ed9\u5b57\u6bb5\u8bbe\u7f6e<code>auto_increment_increment<\/code>\u548c<code>auto_increment_offset<\/code>\u6765\u4fdd\u8bc1ID\u81ea\u589e\uff0c\u6bcf\u6b21\u4e1a\u52a1\u4f7f\u7528\u4e0b\u5217SQL\u8bfb\u5199MySQL\u5f97\u5230ID\u53f7\u3002<\/p>\n<pre><code class=\"language-sql hljs\"><span class=\"hljs-keyword\">begin<\/span>;\r\n<span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> Tickets64 (stub) <span class=\"hljs-keyword\">VALUES<\/span> (<span class=\"hljs-string\">'a'<\/span>);\r\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">LAST_INSERT_ID<\/span>();\r\n<span class=\"hljs-keyword\">commit<\/span>;\r\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/8a4de8e8.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>\u8fd9\u79cd\u65b9\u6848\u7684\u4f18\u7f3a\u70b9\u5982\u4e0b\uff1a<\/p>\n<p>\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>\u975e\u5e38\u7b80\u5355\uff0c\u5229\u7528\u73b0\u6709\u6570\u636e\u5e93\u7cfb\u7edf\u7684\u529f\u80fd\u5b9e\u73b0\uff0c\u6210\u672c\u5c0f\uff0c\u6709DBA\u4e13\u4e1a\u7ef4\u62a4\u3002<\/li>\n<li>ID\u53f7\u5355\u8c03\u81ea\u589e\uff0c\u53ef\u4ee5\u5b9e\u73b0\u4e00\u4e9b\u5bf9ID\u6709\u7279\u6b8a\u8981\u6c42\u7684\u4e1a\u52a1\u3002<\/li>\n<\/ul>\n<p>\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u5f3a\u4f9d\u8d56DB\uff0c\u5f53DB\u5f02\u5e38\u65f6\u6574\u4e2a\u7cfb\u7edf\u4e0d\u53ef\u7528\uff0c\u5c5e\u4e8e\u81f4\u547d\u95ee\u9898\u3002\u914d\u7f6e\u4e3b\u4ece\u590d\u5236\u53ef\u4ee5\u5c3d\u53ef\u80fd\u7684\u589e\u52a0\u53ef\u7528\u6027\uff0c\u4f46\u662f\u6570\u636e\u4e00\u81f4\u6027\u5728\u7279\u6b8a\u60c5\u51b5\u4e0b\u96be\u4ee5\u4fdd\u8bc1\u3002\u4e3b\u4ece\u5207\u6362\u65f6\u7684\u4e0d\u4e00\u81f4\u53ef\u80fd\u4f1a\u5bfc\u81f4\u91cd\u590d\u53d1\u53f7\u3002<\/li>\n<li>ID\u53d1\u53f7\u6027\u80fd\u74f6\u9888\u9650\u5236\u5728\u5355\u53f0MySQL\u7684\u8bfb\u5199\u6027\u80fd\u3002<\/li>\n<\/ul>\n<p>\u5bf9\u4e8eMySQL\u6027\u80fd\u95ee\u9898\uff0c\u53ef\u7528\u5982\u4e0b\u65b9\u6848\u89e3\u51b3\uff1a\u5728\u5206\u5e03\u5f0f\u7cfb\u7edf\u4e2d\u6211\u4eec\u53ef\u4ee5\u591a\u90e8\u7f72\u51e0\u53f0\u673a\u5668\uff0c\u6bcf\u53f0\u673a\u5668\u8bbe\u7f6e\u4e0d\u540c\u7684\u521d\u59cb\u503c\uff0c\u4e14\u6b65\u957f\u548c\u673a\u5668\u6570\u76f8\u7b49\u3002\u6bd4\u5982\u6709\u4e24\u53f0\u673a\u5668\u3002\u8bbe\u7f6e\u6b65\u957fstep\u4e3a2\uff0cTicketServer1\u7684\u521d\u59cb\u503c\u4e3a1\uff081\uff0c3\uff0c5\uff0c7\uff0c9\uff0c11\u2026\uff09\u3001TicketServer2\u7684\u521d\u59cb\u503c\u4e3a2\uff082\uff0c4\uff0c6\uff0c8\uff0c10\u2026\uff09\u3002\u8fd9\u662fFlickr\u56e2\u961f\u57282010\u5e74\u64b0\u6587\u4ecb\u7ecd\u7684\u4e00\u79cd\u4e3b\u952e\u751f\u6210\u7b56\u7565\uff08<a href=\"http:\/\/code.flickr.net\/2010\/02\/08\/ticket-servers-distributed-unique-primary-keys-on-the-cheap\/\">Ticket Servers: Distributed Unique Primary Keys on the Cheap\u00a0<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>\uff09\u3002\u5982\u4e0b\u6240\u793a\uff0c\u4e3a\u4e86\u5b9e\u73b0\u4e0a\u8ff0\u65b9\u6848\u5206\u522b\u8bbe\u7f6e\u4e24\u53f0\u673a\u5668\u5bf9\u5e94\u7684\u53c2\u6570\uff0cTicketServer1\u4ece1\u5f00\u59cb\u53d1\u53f7\uff0cTicketServer2\u4ece2\u5f00\u59cb\u53d1\u53f7\uff0c\u4e24\u53f0\u673a\u5668\u6bcf\u6b21\u53d1\u53f7\u4e4b\u540e\u90fd\u9012\u589e2\u3002<\/p>\n<pre><code class=\"language-sql hljs\">TicketServer1:\r\nauto-increment-increment = 2\r\nauto-increment-offset = 1\r\n\r\nTicketServer2:\r\nauto-increment-increment = 2\r\nauto-increment-offset = 2\r\n<\/code><\/pre>\n<p>\u5047\u8bbe\u6211\u4eec\u8981\u90e8\u7f72N\u53f0\u673a\u5668\uff0c\u6b65\u957f\u9700\u8bbe\u7f6e\u4e3aN\uff0c\u6bcf\u53f0\u7684\u521d\u59cb\u503c\u4f9d\u6b21\u4e3a0,1,2\u2026N-1\u90a3\u4e48\u6574\u4e2a\u67b6\u6784\u5c31\u53d8\u6210\u4e86\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/6d2c9ec8.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>\u8fd9\u79cd\u67b6\u6784\u8c8c\u4f3c\u80fd\u591f\u6ee1\u8db3\u6027\u80fd\u7684\u9700\u6c42\uff0c\u4f46\u6709\u4ee5\u4e0b\u51e0\u4e2a\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u7cfb\u7edf\u6c34\u5e73\u6269\u5c55\u6bd4\u8f83\u56f0\u96be\uff0c\u6bd4\u5982\u5b9a\u4e49\u597d\u4e86\u6b65\u957f\u548c\u673a\u5668\u53f0\u6570\u4e4b\u540e\uff0c\u5982\u679c\u8981\u6dfb\u52a0\u673a\u5668\u8be5\u600e\u4e48\u505a\uff1f\u5047\u8bbe\u73b0\u5728\u53ea\u6709\u4e00\u53f0\u673a\u5668\u53d1\u53f7\u662f1,2,3,4,5\uff08\u6b65\u957f\u662f1\uff09\uff0c\u8fd9\u4e2a\u65f6\u5019\u9700\u8981\u6269\u5bb9\u673a\u5668\u4e00\u53f0\u3002\u53ef\u4ee5\u8fd9\u6837\u505a\uff1a\u628a\u7b2c\u4e8c\u53f0\u673a\u5668\u7684\u521d\u59cb\u503c\u8bbe\u7f6e\u5f97\u6bd4\u7b2c\u4e00\u53f0\u8d85\u8fc7\u5f88\u591a\uff0c\u6bd4\u598214\uff08\u5047\u8bbe\u5728\u6269\u5bb9\u65f6\u95f4\u4e4b\u5185\u7b2c\u4e00\u53f0\u4e0d\u53ef\u80fd\u53d1\u523014\uff09\uff0c\u540c\u65f6\u8bbe\u7f6e\u6b65\u957f\u4e3a2\uff0c\u90a3\u4e48\u8fd9\u53f0\u673a\u5668\u4e0b\u53d1\u7684\u53f7\u7801\u90fd\u662f14\u4ee5\u540e\u7684\u5076\u6570\u3002\u7136\u540e\u6458\u6389\u7b2c\u4e00\u53f0\uff0c\u628aID\u503c\u4fdd\u7559\u4e3a\u5947\u6570\uff0c\u6bd4\u59827\uff0c\u7136\u540e\u4fee\u6539\u7b2c\u4e00\u53f0\u7684\u6b65\u957f\u4e3a2\u3002\u8ba9\u5b83\u7b26\u5408\u6211\u4eec\u5b9a\u4e49\u7684\u53f7\u6bb5\u6807\u51c6\uff0c\u5bf9\u4e8e\u8fd9\u4e2a\u4f8b\u5b50\u6765\u8bf4\u5c31\u662f\u8ba9\u7b2c\u4e00\u53f0\u4ee5\u540e\u53ea\u80fd\u4ea7\u751f\u5947\u6570\u3002\u6269\u5bb9\u65b9\u6848\u770b\u8d77\u6765\u590d\u6742\u5417\uff1f\u8c8c\u4f3c\u8fd8\u597d\uff0c\u73b0\u5728\u60f3\u8c61\u4e00\u4e0b\u5982\u679c\u6211\u4eec\u7ebf\u4e0a\u6709100\u53f0\u673a\u5668\uff0c\u8fd9\u4e2a\u65f6\u5019\u8981\u6269\u5bb9\u8be5\u600e\u4e48\u505a\uff1f\u7b80\u76f4\u662f\u5669\u68a6\u3002\u6240\u4ee5\u7cfb\u7edf\u6c34\u5e73\u6269\u5c55\u65b9\u6848\u590d\u6742\u96be\u4ee5\u5b9e\u73b0\u3002<\/li>\n<li>ID\u6ca1\u6709\u4e86\u5355\u8c03\u9012\u589e\u7684\u7279\u6027\uff0c\u53ea\u80fd\u8d8b\u52bf\u9012\u589e\uff0c\u8fd9\u4e2a\u7f3a\u70b9\u5bf9\u4e8e\u4e00\u822c\u4e1a\u52a1\u9700\u6c42\u4e0d\u662f\u5f88\u91cd\u8981\uff0c\u53ef\u4ee5\u5bb9\u5fcd\u3002<\/li>\n<li>\u6570\u636e\u5e93\u538b\u529b\u8fd8\u662f\u5f88\u5927\uff0c\u6bcf\u6b21\u83b7\u53d6ID\u90fd\u5f97\u8bfb\u5199\u4e00\u6b21\u6570\u636e\u5e93\uff0c\u53ea\u80fd\u9760\u5806\u673a\u5668\u6765\u63d0\u9ad8\u6027\u80fd\u3002<\/li>\n<\/ul>\n<p>Leaf\u8fd9\u4e2a\u540d\u5b57\u662f\u6765\u81ea\u5fb7\u56fd\u54f2\u5b66\u5bb6\u3001\u6570\u5b66\u5bb6\u83b1\u5e03\u5c3c\u8328\u7684\u4e00\u53e5\u8bdd\uff1a &gt;There are no two identical leaves in the world &gt; \u201c\u4e16\u754c\u4e0a\u6ca1\u6709\u4e24\u7247\u76f8\u540c\u7684\u6811\u53f6\u201d<\/p>\n<p>\u7efc\u5408\u5bf9\u6bd4\u4e0a\u8ff0\u51e0\u79cd\u65b9\u6848\uff0c\u6bcf\u79cd\u65b9\u6848\u90fd\u4e0d\u5b8c\u5168\u7b26\u5408\u6211\u4eec\u7684\u8981\u6c42\u3002\u6240\u4ee5Leaf\u5206\u522b\u5728\u4e0a\u8ff0\u7b2c\u4e8c\u79cd\u548c\u7b2c\u4e09\u79cd\u65b9\u6848\u4e0a\u505a\u4e86\u76f8\u5e94\u7684\u4f18\u5316\uff0c\u5b9e\u73b0\u4e86Leaf-segment\u548cLeaf-snowflake\u65b9\u6848\u3002<\/p>\n<h3 id=\"leaf-segment\u6570\u636e\u5e93\u65b9\u6848\">Leaf-segment\u6570\u636e\u5e93\u65b9\u6848<\/h3>\n<p>\u7b2c\u4e00\u79cdLeaf-segment\u65b9\u6848\uff0c\u5728\u4f7f\u7528\u6570\u636e\u5e93\u7684\u65b9\u6848\u4e0a\uff0c\u505a\u4e86\u5982\u4e0b\u6539\u53d8\uff1a &#8211; \u539f\u65b9\u6848\u6bcf\u6b21\u83b7\u53d6ID\u90fd\u5f97\u8bfb\u5199\u4e00\u6b21\u6570\u636e\u5e93\uff0c\u9020\u6210\u6570\u636e\u5e93\u538b\u529b\u5927\u3002\u6539\u4e3a\u5229\u7528proxy server\u6279\u91cf\u83b7\u53d6\uff0c\u6bcf\u6b21\u83b7\u53d6\u4e00\u4e2asegment(step\u51b3\u5b9a\u5927\u5c0f)\u53f7\u6bb5\u7684\u503c\u3002\u7528\u5b8c\u4e4b\u540e\u518d\u53bb\u6570\u636e\u5e93\u83b7\u53d6\u65b0\u7684\u53f7\u6bb5\uff0c\u53ef\u4ee5\u5927\u5927\u7684\u51cf\u8f7b\u6570\u636e\u5e93\u7684\u538b\u529b\u3002 &#8211; \u5404\u4e2a\u4e1a\u52a1\u4e0d\u540c\u7684\u53d1\u53f7\u9700\u6c42\u7528biz_tag\u5b57\u6bb5\u6765\u533a\u5206\uff0c\u6bcf\u4e2abiz-tag\u7684ID\u83b7\u53d6\u76f8\u4e92\u9694\u79bb\uff0c\u4e92\u4e0d\u5f71\u54cd\u3002\u5982\u679c\u4ee5\u540e\u6709\u6027\u80fd\u9700\u6c42\u9700\u8981\u5bf9\u6570\u636e\u5e93\u6269\u5bb9\uff0c\u4e0d\u9700\u8981\u4e0a\u8ff0\u63cf\u8ff0\u7684\u590d\u6742\u7684\u6269\u5bb9\u64cd\u4f5c\uff0c\u53ea\u9700\u8981\u5bf9biz_tag\u5206\u5e93\u5206\u8868\u5c31\u884c\u3002<\/p>\n<p>\u6570\u636e\u5e93\u8868\u8bbe\u8ba1\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-sql hljs\">+<span class=\"hljs-comment\">-------------+--------------+------+-----+-------------------+-----------------------------+<\/span>\r\n| Field       | Type         | Null | Key | Default           | Extra                       |\r\n+<span class=\"hljs-comment\">-------------+--------------+------+-----+-------------------+-----------------------------+<\/span>\r\n| biz_tag     | varchar(128) | NO   | PRI |                   |                             |\r\n| max_id      | bigint(20)   | NO   |     | 1                 |                             |\r\n| step        | int(11)      | NO   |     | NULL              |                             |\r\n| desc        | varchar(256) | YES  |     | NULL              |                             |\r\n| update_time | timestamp    | NO   |     | CURRENT_TIMESTAMP | on <span class=\"hljs-keyword\">update<\/span> <span class=\"hljs-keyword\">CURRENT_TIMESTAMP<\/span> |\r\n+<span class=\"hljs-comment\">-------------+--------------+------+-----+-------------------+-----------------------------+<\/span>\r\n<\/code><\/pre>\n<p>\u91cd\u8981\u5b57\u6bb5\u8bf4\u660e\uff1abiz_tag\u7528\u6765\u533a\u5206\u4e1a\u52a1\uff0cmax_id\u8868\u793a\u8be5biz_tag\u76ee\u524d\u6240\u88ab\u5206\u914d\u7684ID\u53f7\u6bb5\u7684\u6700\u5927\u503c\uff0cstep\u8868\u793a\u6bcf\u6b21\u5206\u914d\u7684\u53f7\u6bb5\u957f\u5ea6\u3002\u539f\u6765\u83b7\u53d6ID\u6bcf\u6b21\u90fd\u9700\u8981\u5199\u6570\u636e\u5e93\uff0c\u73b0\u5728\u53ea\u9700\u8981\u628astep\u8bbe\u7f6e\u5f97\u8db3\u591f\u5927\uff0c\u6bd4\u59821000\u3002\u90a3\u4e48\u53ea\u6709\u5f531000\u4e2a\u53f7\u88ab\u6d88\u8017\u5b8c\u4e86\u4e4b\u540e\u624d\u4f1a\u53bb\u91cd\u65b0\u8bfb\u5199\u4e00\u6b21\u6570\u636e\u5e93\u3002\u8bfb\u5199\u6570\u636e\u5e93\u7684\u9891\u7387\u4ece1\u51cf\u5c0f\u5230\u4e861\/step\uff0c\u5927\u81f4\u67b6\u6784\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/5e4ff128.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>test_tag\u5728\u7b2c\u4e00\u53f0Leaf\u673a\u5668\u4e0a\u662f1~1000\u7684\u53f7\u6bb5\uff0c\u5f53\u8fd9\u4e2a\u53f7\u6bb5\u7528\u5b8c\u65f6\uff0c\u4f1a\u53bb\u52a0\u8f7d\u53e6\u4e00\u4e2a\u957f\u5ea6\u4e3astep=1000\u7684\u53f7\u6bb5\uff0c\u5047\u8bbe\u53e6\u5916\u4e24\u53f0\u53f7\u6bb5\u90fd\u6ca1\u6709\u66f4\u65b0\uff0c\u8fd9\u4e2a\u65f6\u5019\u7b2c\u4e00\u53f0\u673a\u5668\u65b0\u52a0\u8f7d\u7684\u53f7\u6bb5\u5c31\u5e94\u8be5\u662f3001~4000\u3002\u540c\u65f6\u6570\u636e\u5e93\u5bf9\u5e94\u7684biz_tag\u8fd9\u6761\u6570\u636e\u7684max_id\u4f1a\u4ece3000\u88ab\u66f4\u65b0\u62104000\uff0c\u66f4\u65b0\u53f7\u6bb5\u7684SQL\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-sql hljs\"><span class=\"hljs-keyword\">Begin<\/span>\r\n<span class=\"hljs-keyword\">UPDATE<\/span> <span class=\"hljs-keyword\">table<\/span> <span class=\"hljs-keyword\">SET<\/span> max_id=max_id+step <span class=\"hljs-keyword\">WHERE<\/span> biz_tag=xxx\r\n<span class=\"hljs-keyword\">SELECT<\/span> tag, max_id, step <span class=\"hljs-keyword\">FROM<\/span> <span class=\"hljs-keyword\">table<\/span> <span class=\"hljs-keyword\">WHERE<\/span> biz_tag=xxx\r\n<span class=\"hljs-keyword\">Commit<\/span>\r\n<\/code><\/pre>\n<p>\u8fd9\u79cd\u6a21\u5f0f\u6709\u4ee5\u4e0b\u4f18\u7f3a\u70b9\uff1a<\/p>\n<p>\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>Leaf\u670d\u52a1\u53ef\u4ee5\u5f88\u65b9\u4fbf\u7684\u7ebf\u6027\u6269\u5c55\uff0c\u6027\u80fd\u5b8c\u5168\u80fd\u591f\u652f\u6491\u5927\u591a\u6570\u4e1a\u52a1\u573a\u666f\u3002<\/li>\n<li>ID\u53f7\u7801\u662f\u8d8b\u52bf\u9012\u589e\u76848byte\u768464\u4f4d\u6570\u5b57\uff0c\u6ee1\u8db3\u4e0a\u8ff0\u6570\u636e\u5e93\u5b58\u50a8\u7684\u4e3b\u952e\u8981\u6c42\u3002<\/li>\n<li>\u5bb9\u707e\u6027\u9ad8\uff1aLeaf\u670d\u52a1\u5185\u90e8\u6709\u53f7\u6bb5\u7f13\u5b58\uff0c\u5373\u4f7fDB\u5b95\u673a\uff0c\u77ed\u65f6\u95f4\u5185Leaf\u4ecd\u80fd\u6b63\u5e38\u5bf9\u5916\u63d0\u4f9b\u670d\u52a1\u3002<\/li>\n<li>\u53ef\u4ee5\u81ea\u5b9a\u4e49max_id\u7684\u5927\u5c0f\uff0c\u975e\u5e38\u65b9\u4fbf\u4e1a\u52a1\u4ece\u539f\u6709\u7684ID\u65b9\u5f0f\u4e0a\u8fc1\u79fb\u8fc7\u6765\u3002<\/li>\n<\/ul>\n<p>\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>ID\u53f7\u7801\u4e0d\u591f\u968f\u673a\uff0c\u80fd\u591f\u6cc4\u9732\u53d1\u53f7\u6570\u91cf\u7684\u4fe1\u606f\uff0c\u4e0d\u592a\u5b89\u5168\u3002<\/li>\n<li>TP999\u6570\u636e\u6ce2\u52a8\u5927\uff0c\u5f53\u53f7\u6bb5\u4f7f\u7528\u5b8c\u4e4b\u540e\u8fd8\u662f\u4f1ahang\u5728\u66f4\u65b0\u6570\u636e\u5e93\u7684I\/O\u4e0a\uff0ctg999\u6570\u636e\u4f1a\u51fa\u73b0\u5076\u5c14\u7684\u5c16\u523a\u3002<\/li>\n<li>DB\u5b95\u673a\u4f1a\u9020\u6210\u6574\u4e2a\u7cfb\u7edf\u4e0d\u53ef\u7528\u3002<\/li>\n<\/ul>\n<h3 id=\"\u53ccbuffer\u4f18\u5316\">\u53ccbuffer\u4f18\u5316<\/h3>\n<p>\u5bf9\u4e8e\u7b2c\u4e8c\u4e2a\u7f3a\u70b9\uff0cLeaf-segment\u505a\u4e86\u4e00\u4e9b\u4f18\u5316\uff0c\u7b80\u5355\u7684\u8bf4\u5c31\u662f\uff1a<\/p>\n<p>Leaf \u53d6\u53f7\u6bb5\u7684\u65f6\u673a\u662f\u5728\u53f7\u6bb5\u6d88\u8017\u5b8c\u7684\u65f6\u5019\u8fdb\u884c\u7684\uff0c\u4e5f\u5c31\u610f\u5473\u7740\u53f7\u6bb5\u4e34\u754c\u70b9\u7684ID\u4e0b\u53d1\u65f6\u95f4\u53d6\u51b3\u4e8e\u4e0b\u4e00\u6b21\u4eceDB\u53d6\u56de\u53f7\u6bb5\u7684\u65f6\u95f4\uff0c\u5e76\u4e14\u5728\u8fd9\u671f\u95f4\u8fdb\u6765\u7684\u8bf7\u6c42\u4e5f\u4f1a\u56e0\u4e3aDB\u53f7\u6bb5\u6ca1\u6709\u53d6\u56de\u6765\uff0c\u5bfc\u81f4\u7ebf\u7a0b\u963b\u585e\u3002\u5982\u679c\u8bf7\u6c42DB\u7684\u7f51\u7edc\u548cDB\u7684\u6027\u80fd\u7a33\u5b9a\uff0c\u8fd9\u79cd\u60c5\u51b5\u5bf9\u7cfb\u7edf\u7684\u5f71\u54cd\u662f\u4e0d\u5927\u7684\uff0c\u4f46\u662f\u5047\u5982\u53d6DB\u7684\u65f6\u5019\u7f51\u7edc\u53d1\u751f\u6296\u52a8\uff0c\u6216\u8005DB\u53d1\u751f\u6162\u67e5\u8be2\u5c31\u4f1a\u5bfc\u81f4\u6574\u4e2a\u7cfb\u7edf\u7684\u54cd\u5e94\u65f6\u95f4\u53d8\u6162\u3002<\/p>\n<p>\u4e3a\u6b64\uff0c\u6211\u4eec\u5e0c\u671bDB\u53d6\u53f7\u6bb5\u7684\u8fc7\u7a0b\u80fd\u591f\u505a\u5230\u65e0\u963b\u585e\uff0c\u4e0d\u9700\u8981\u5728DB\u53d6\u53f7\u6bb5\u7684\u65f6\u5019\u963b\u585e\u8bf7\u6c42\u7ebf\u7a0b\uff0c\u5373\u5f53\u53f7\u6bb5\u6d88\u8d39\u5230\u67d0\u4e2a\u70b9\u65f6\u5c31\u5f02\u6b65\u7684\u628a\u4e0b\u4e00\u4e2a\u53f7\u6bb5\u52a0\u8f7d\u5230\u5185\u5b58\u4e2d\u3002\u800c\u4e0d\u9700\u8981\u7b49\u5230\u53f7\u6bb5\u7528\u5c3d\u7684\u65f6\u5019\u624d\u53bb\u66f4\u65b0\u53f7\u6bb5\u3002\u8fd9\u6837\u505a\u5c31\u53ef\u4ee5\u5f88\u5927\u7a0b\u5ea6\u4e0a\u7684\u964d\u4f4e\u7cfb\u7edf\u7684TP999\u6307\u6807\u3002\u8be6\u7ec6\u5b9e\u73b0\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/f2625fac.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>\u91c7\u7528\u53ccbuffer\u7684\u65b9\u5f0f\uff0cLeaf\u670d\u52a1\u5185\u90e8\u6709\u4e24\u4e2a\u53f7\u6bb5\u7f13\u5b58\u533asegment\u3002\u5f53\u524d\u53f7\u6bb5\u5df2\u4e0b\u53d110%\u65f6\uff0c\u5982\u679c\u4e0b\u4e00\u4e2a\u53f7\u6bb5\u672a\u66f4\u65b0\uff0c\u5219\u53e6\u542f\u4e00\u4e2a\u66f4\u65b0\u7ebf\u7a0b\u53bb\u66f4\u65b0\u4e0b\u4e00\u4e2a\u53f7\u6bb5\u3002\u5f53\u524d\u53f7\u6bb5\u5168\u90e8\u4e0b\u53d1\u5b8c\u540e\uff0c\u5982\u679c\u4e0b\u4e2a\u53f7\u6bb5\u51c6\u5907\u597d\u4e86\u5219\u5207\u6362\u5230\u4e0b\u4e2a\u53f7\u6bb5\u4e3a\u5f53\u524dsegment\u63a5\u7740\u4e0b\u53d1\uff0c\u5faa\u73af\u5f80\u590d\u3002<\/p>\n<ul>\n<li>\u6bcf\u4e2abiz-tag\u90fd\u6709\u6d88\u8d39\u901f\u5ea6\u76d1\u63a7\uff0c\u901a\u5e38\u63a8\u8350segment\u957f\u5ea6\u8bbe\u7f6e\u4e3a\u670d\u52a1\u9ad8\u5cf0\u671f\u53d1\u53f7QPS\u7684600\u500d\uff0810\u5206\u949f\uff09\uff0c\u8fd9\u6837\u5373\u4f7fDB\u5b95\u673a\uff0cLeaf\u4ecd\u80fd\u6301\u7eed\u53d1\u53f710-20\u5206\u949f\u4e0d\u53d7\u5f71\u54cd\u3002<\/li>\n<li>\u6bcf\u6b21\u8bf7\u6c42\u6765\u4e34\u65f6\u90fd\u4f1a\u5224\u65ad\u4e0b\u4e2a\u53f7\u6bb5\u7684\u72b6\u6001\uff0c\u4ece\u800c\u66f4\u65b0\u6b64\u53f7\u6bb5\uff0c\u6240\u4ee5\u5076\u5c14\u7684\u7f51\u7edc\u6296\u52a8\u4e0d\u4f1a\u5f71\u54cd\u4e0b\u4e2a\u53f7\u6bb5\u7684\u66f4\u65b0\u3002<\/li>\n<\/ul>\n<h3 id=\"leaf\u9ad8\u53ef\u7528\u5bb9\u707e\">Leaf\u9ad8\u53ef\u7528\u5bb9\u707e<\/h3>\n<p>\u5bf9\u4e8e\u7b2c\u4e09\u70b9\u201cDB\u53ef\u7528\u6027\u201d\u95ee\u9898\uff0c\u6211\u4eec\u76ee\u524d\u91c7\u7528\u4e00\u4e3b\u4e24\u4ece\u7684\u65b9\u5f0f\uff0c\u540c\u65f6\u5206\u673a\u623f\u90e8\u7f72\uff0cMaster\u548cSlave\u4e4b\u95f4\u91c7\u7528<strong>\u534a\u540c\u6b65\u65b9\u5f0f[5]<\/strong>\u540c\u6b65\u6570\u636e\u3002\u540c\u65f6\u4f7f\u7528\u516c\u53f8Atlas\u6570\u636e\u5e93\u4e2d\u95f4\u4ef6(\u5df2\u5f00\u6e90\uff0c\u6539\u540d\u4e3a<a href=\"http:\/\/tech.meituan.com\/dbproxy-introduction.html\">DBProxy<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>)\u505a\u4e3b\u4ece\u5207\u6362\u3002\u5f53\u7136\u8fd9\u79cd\u65b9\u6848\u5728\u4e00\u4e9b\u60c5\u51b5\u4f1a\u9000\u5316\u6210\u5f02\u6b65\u6a21\u5f0f\uff0c\u751a\u81f3\u5728<strong>\u975e\u5e38\u6781\u7aef<\/strong>\u60c5\u51b5\u4e0b\u4ecd\u7136\u4f1a\u9020\u6210\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u60c5\u51b5\uff0c\u4f46\u662f\u51fa\u73b0\u7684\u6982\u7387\u975e\u5e38\u5c0f\u3002\u5982\u679c\u4f60\u7684\u7cfb\u7edf\u8981\u4fdd\u8bc1100%\u7684\u6570\u636e\u5f3a\u4e00\u81f4\uff0c\u53ef\u4ee5\u9009\u62e9\u4f7f\u7528\u201c\u7c7bPaxos\u7b97\u6cd5\u201d\u5b9e\u73b0\u7684\u5f3a\u4e00\u81f4MySQL\u65b9\u6848\uff0c\u5982MySQL 5.7\u524d\u6bb5\u65f6\u95f4\u521a\u521aGA\u7684<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/group-replication.html\">MySQL Group Replication<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>\u3002\u4f46\u662f\u8fd0\u7ef4\u6210\u672c\u548c\u7cbe\u529b\u90fd\u4f1a\u76f8\u5e94\u7684\u589e\u52a0\uff0c\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u9009\u578b\u5373\u53ef\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/0de883dd.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>\u540c\u65f6Leaf\u670d\u52a1\u5206IDC\u90e8\u7f72\uff0c\u5185\u90e8\u7684\u670d\u52a1\u5316\u6846\u67b6\u662f\u201cMTthrift RPC\u201d\u3002\u670d\u52a1\u8c03\u7528\u7684\u65f6\u5019\uff0c\u6839\u636e\u8d1f\u8f7d\u5747\u8861\u7b97\u6cd5\u4f1a\u4f18\u5148\u8c03\u7528\u540c\u673a\u623f\u7684Leaf\u670d\u52a1\u3002\u5728\u8be5IDC\u5185Leaf\u670d\u52a1\u4e0d\u53ef\u7528\u7684\u65f6\u5019\u624d\u4f1a\u9009\u62e9\u5176\u4ed6\u673a\u623f\u7684Leaf\u670d\u52a1\u3002\u540c\u65f6\u670d\u52a1\u6cbb\u7406\u5e73\u53f0OCTO\u8fd8\u63d0\u4f9b\u4e86\u9488\u5bf9\u670d\u52a1\u7684\u8fc7\u8f7d\u4fdd\u62a4\u3001\u4e00\u952e\u622a\u6d41\u3001\u52a8\u6001\u6d41\u91cf\u5206\u914d\u7b49\u5bf9\u670d\u52a1\u7684\u4fdd\u62a4\u63aa\u65bd\u3002<\/p>\n<p>Leaf-segment\u65b9\u6848\u53ef\u4ee5\u751f\u6210\u8d8b\u52bf\u9012\u589e\u7684ID\uff0c\u540c\u65f6ID\u53f7\u662f\u53ef\u8ba1\u7b97\u7684\uff0c\u4e0d\u9002\u7528\u4e8e\u8ba2\u5355ID\u751f\u6210\u573a\u666f\uff0c\u6bd4\u5982\u7ade\u5bf9\u5728\u4e24\u5929\u4e2d\u534812\u70b9\u5206\u522b\u4e0b\u5355\uff0c\u901a\u8fc7\u8ba2\u5355id\u53f7\u76f8\u51cf\u5c31\u80fd\u5927\u81f4\u8ba1\u7b97\u51fa\u516c\u53f8\u4e00\u5929\u7684\u8ba2\u5355\u91cf\uff0c\u8fd9\u4e2a\u662f\u4e0d\u80fd\u5fcd\u53d7\u7684\u3002\u9762\u5bf9\u8fd9\u4e00\u95ee\u9898\uff0c\u6211\u4eec\u63d0\u4f9b\u4e86 Leaf-snowflake\u65b9\u6848\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/721ceeff.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>Leaf-snowflake\u65b9\u6848\u5b8c\u5168\u6cbf\u7528snowflake\u65b9\u6848\u7684bit\u4f4d\u8bbe\u8ba1\uff0c\u5373\u662f\u201c1+41+10+12\u201d\u7684\u65b9\u5f0f\u7ec4\u88c5ID\u53f7\u3002\u5bf9\u4e8eworkerID\u7684\u5206\u914d\uff0c\u5f53\u670d\u52a1\u96c6\u7fa4\u6570\u91cf\u8f83\u5c0f\u7684\u60c5\u51b5\u4e0b\uff0c\u5b8c\u5168\u53ef\u4ee5\u624b\u52a8\u914d\u7f6e\u3002Leaf\u670d\u52a1\u89c4\u6a21\u8f83\u5927\uff0c\u52a8\u624b\u914d\u7f6e\u6210\u672c\u592a\u9ad8\u3002\u6240\u4ee5\u4f7f\u7528Zookeeper\u6301\u4e45\u987a\u5e8f\u8282\u70b9\u7684\u7279\u6027\u81ea\u52a8\u5bf9snowflake\u8282\u70b9\u914d\u7f6ewokerID\u3002Leaf-snowflake\u662f\u6309\u7167\u4e0b\u9762\u51e0\u4e2a\u6b65\u9aa4\u542f\u52a8\u7684\uff1a<\/p>\n<ol>\n<li>\u542f\u52a8Leaf-snowflake\u670d\u52a1\uff0c\u8fde\u63a5Zookeeper\uff0c\u5728leaf_forever\u7236\u8282\u70b9\u4e0b\u68c0\u67e5\u81ea\u5df1\u662f\u5426\u5df2\u7ecf\u6ce8\u518c\u8fc7\uff08\u662f\u5426\u6709\u8be5\u987a\u5e8f\u5b50\u8282\u70b9\uff09\u3002<\/li>\n<li>\u5982\u679c\u6709\u6ce8\u518c\u8fc7\u76f4\u63a5\u53d6\u56de\u81ea\u5df1\u7684workerID\uff08zk\u987a\u5e8f\u8282\u70b9\u751f\u6210\u7684int\u7c7b\u578bID\u53f7\uff09\uff0c\u542f\u52a8\u670d\u52a1\u3002<\/li>\n<li>\u5982\u679c\u6ca1\u6709\u6ce8\u518c\u8fc7\uff0c\u5c31\u5728\u8be5\u7236\u8282\u70b9\u4e0b\u9762\u521b\u5efa\u4e00\u4e2a\u6301\u4e45\u987a\u5e8f\u8282\u70b9\uff0c\u521b\u5efa\u6210\u529f\u540e\u53d6\u56de\u987a\u5e8f\u53f7\u5f53\u505a\u81ea\u5df1\u7684workerID\u53f7\uff0c\u542f\u52a8\u670d\u52a1\u3002<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/a3f985a8.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<h3 id=\"\u5f31\u4f9d\u8d56zookeeper\">\u5f31\u4f9d\u8d56ZooKeeper<\/h3>\n<p>\u9664\u4e86\u6bcf\u6b21\u4f1a\u53bbZK\u62ff\u6570\u636e\u4ee5\u5916\uff0c\u4e5f\u4f1a\u5728\u672c\u673a\u6587\u4ef6\u7cfb\u7edf\u4e0a\u7f13\u5b58\u4e00\u4e2aworkerID\u6587\u4ef6\u3002\u5f53ZooKeeper\u51fa\u73b0\u95ee\u9898\uff0c\u6070\u597d\u673a\u5668\u51fa\u73b0\u95ee\u9898\u9700\u8981\u91cd\u542f\u65f6\uff0c\u80fd\u4fdd\u8bc1\u670d\u52a1\u80fd\u591f\u6b63\u5e38\u542f\u52a8\u3002\u8fd9\u6837\u505a\u5230\u4e86\u5bf9\u4e09\u65b9\u7ec4\u4ef6\u7684\u5f31\u4f9d\u8d56\u3002\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u63d0\u9ad8\u4e86SLA<\/p>\n<h3 id=\"\u89e3\u51b3\u65f6\u949f\u95ee\u9898\">\u89e3\u51b3\u65f6\u949f\u95ee\u9898<\/h3>\n<p>\u56e0\u4e3a\u8fd9\u79cd\u65b9\u6848\u4f9d\u8d56\u65f6\u95f4\uff0c\u5982\u679c\u673a\u5668\u7684\u65f6\u949f\u53d1\u751f\u4e86\u56de\u62e8\uff0c\u90a3\u4e48\u5c31\u4f1a\u6709\u53ef\u80fd\u751f\u6210\u91cd\u590d\u7684ID\u53f7\uff0c\u9700\u8981\u89e3\u51b3\u65f6\u949f\u56de\u9000\u7684\u95ee\u9898\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/awps-assets.meituan.net\/mit-x\/blog-images-bundle-2017\/1453b4e9.png\" alt=\"image\" \/><\/p>\n<div class=\"img-figure\">image<\/div>\n<p>\u53c2\u89c1\u4e0a\u56fe\u6574\u4e2a\u542f\u52a8\u6d41\u7a0b\u56fe\uff0c\u670d\u52a1\u542f\u52a8\u65f6\u9996\u5148\u68c0\u67e5\u81ea\u5df1\u662f\u5426\u5199\u8fc7ZooKeeper leaf_forever\u8282\u70b9\uff1a<\/p>\n<ol>\n<li>\u82e5\u5199\u8fc7\uff0c\u5219\u7528\u81ea\u8eab\u7cfb\u7edf\u65f6\u95f4\u4e0eleaf_forever\/${self}\u8282\u70b9\u8bb0\u5f55\u65f6\u95f4\u505a\u6bd4\u8f83\uff0c\u82e5\u5c0f\u4e8eleaf_forever\/${self}\u65f6\u95f4\u5219\u8ba4\u4e3a\u673a\u5668\u65f6\u95f4\u53d1\u751f\u4e86\u5927\u6b65\u957f\u56de\u62e8\uff0c\u670d\u52a1\u542f\u52a8\u5931\u8d25\u5e76\u62a5\u8b66\u3002<\/li>\n<li>\u82e5\u672a\u5199\u8fc7\uff0c\u8bc1\u660e\u662f\u65b0\u670d\u52a1\u8282\u70b9\uff0c\u76f4\u63a5\u521b\u5efa\u6301\u4e45\u8282\u70b9leaf_forever\/${self}\u5e76\u5199\u5165\u81ea\u8eab\u7cfb\u7edf\u65f6\u95f4\uff0c\u63a5\u4e0b\u6765\u7efc\u5408\u5bf9\u6bd4\u5176\u4f59Leaf\u8282\u70b9\u7684\u7cfb\u7edf\u65f6\u95f4\u6765\u5224\u65ad\u81ea\u8eab\u7cfb\u7edf\u65f6\u95f4\u662f\u5426\u51c6\u786e\uff0c\u5177\u4f53\u505a\u6cd5\u662f\u53d6leaf_temporary\u4e0b\u7684\u6240\u6709\u4e34\u65f6\u8282\u70b9(\u6240\u6709\u8fd0\u884c\u4e2d\u7684Leaf-snowflake\u8282\u70b9)\u7684\u670d\u52a1IP\uff1aPort\uff0c\u7136\u540e\u901a\u8fc7RPC\u8bf7\u6c42\u5f97\u5230\u6240\u6709\u8282\u70b9\u7684\u7cfb\u7edf\u65f6\u95f4\uff0c\u8ba1\u7b97sum(time)\/nodeSize\u3002<\/li>\n<li>\u82e5abs( \u7cfb\u7edf\u65f6\u95f4-sum(time)\/nodeSize ) &lt; \u9608\u503c\uff0c\u8ba4\u4e3a\u5f53\u524d\u7cfb\u7edf\u65f6\u95f4\u51c6\u786e\uff0c\u6b63\u5e38\u542f\u52a8\u670d\u52a1\uff0c\u540c\u65f6\u5199\u4e34\u65f6\u8282\u70b9leaf_temporary\/${self} \u7ef4\u6301\u79df\u7ea6\u3002<\/li>\n<li>\u5426\u5219\u8ba4\u4e3a\u672c\u673a\u7cfb\u7edf\u65f6\u95f4\u53d1\u751f\u5927\u6b65\u957f\u504f\u79fb\uff0c\u542f\u52a8\u5931\u8d25\u5e76\u62a5\u8b66\u3002<\/li>\n<li>\u6bcf\u9694\u4e00\u6bb5\u65f6\u95f4(3s)\u4e0a\u62a5\u81ea\u8eab\u7cfb\u7edf\u65f6\u95f4\u5199\u5165leaf_forever\/${self}\u3002<\/li>\n<\/ol>\n<p>\u7531\u4e8e\u5f3a\u4f9d\u8d56\u65f6\u949f\uff0c\u5bf9\u65f6\u95f4\u7684\u8981\u6c42\u6bd4\u8f83\u654f\u611f\uff0c\u5728\u673a\u5668\u5de5\u4f5c\u65f6NTP\u540c\u6b65\u4e5f\u4f1a\u9020\u6210\u79d2\u7ea7\u522b\u7684\u56de\u9000\uff0c\u5efa\u8bae\u53ef\u4ee5\u76f4\u63a5\u5173\u95edNTP\u540c\u6b65\u3002\u8981\u4e48\u5728\u65f6\u949f\u56de\u62e8\u7684\u65f6\u5019\u76f4\u63a5\u4e0d\u63d0\u4f9b\u670d\u52a1\u76f4\u63a5\u8fd4\u56deERROR_CODE\uff0c\u7b49\u65f6\u949f\u8ffd\u4e0a\u5373\u53ef\u3002<strong>\u6216\u8005\u505a\u4e00\u5c42\u91cd\u8bd5\uff0c\u7136\u540e\u4e0a\u62a5\u62a5\u8b66\u7cfb\u7edf\uff0c\u66f4\u6216\u8005\u662f\u53d1\u73b0\u6709\u65f6\u949f\u56de\u62e8\u4e4b\u540e\u81ea\u52a8\u6458\u9664\u672c\u8eab\u8282\u70b9\u5e76\u62a5\u8b66<\/strong>\uff0c\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-java hljs\"> <span class=\"hljs-comment\">\/\/\u53d1\u751f\u4e86\u56de\u62e8\uff0c\u6b64\u523b\u65f6\u95f4\u5c0f\u4e8e\u4e0a\u6b21\u53d1\u53f7\u65f6\u95f4<\/span>\r\n <span class=\"hljs-keyword\">if<\/span> (timestamp &lt; lastTimestamp) {\r\n  \t\t\t  \r\n            <span class=\"hljs-keyword\">long<\/span> offset = lastTimestamp - timestamp;\r\n            <span class=\"hljs-keyword\">if<\/span> (offset &lt;= <span class=\"hljs-number\">5<\/span>) {\r\n                <span class=\"hljs-keyword\">try<\/span> {\r\n                \t<span class=\"hljs-comment\">\/\/\u65f6\u95f4\u504f\u5dee\u5927\u5c0f\u5c0f\u4e8e5ms\uff0c\u5219\u7b49\u5f85\u4e24\u500d\u65f6\u95f4<\/span>\r\n                    wait(offset &lt;&lt; <span class=\"hljs-number\">1<\/span>);<span class=\"hljs-comment\">\/\/wait<\/span>\r\n                    timestamp = timeGen();\r\n                    <span class=\"hljs-keyword\">if<\/span> (timestamp &lt; lastTimestamp) {\r\n                       <span class=\"hljs-comment\">\/\/\u8fd8\u662f\u5c0f\u4e8e\uff0c\u629b\u5f02\u5e38\u5e76\u4e0a\u62a5<\/span>\r\n                        throwClockBackwardsEx(timestamp);\r\n                      }    \r\n                } <span class=\"hljs-keyword\">catch<\/span> (InterruptedException e) {  \r\n                   <span class=\"hljs-keyword\">throw<\/span>  e;\r\n                }\r\n            } <span class=\"hljs-keyword\">else<\/span> {\r\n                <span class=\"hljs-comment\">\/\/throw<\/span>\r\n                throwClockBackwardsEx(timestamp);\r\n            }\r\n        }\r\n <span class=\"hljs-comment\">\/\/\u5206\u914dID       <\/span>\r\n        \r\n<\/code><\/pre>\n<p><strong>\u4ece\u4e0a\u7ebf\u60c5\u51b5\u6765\u770b\uff0c\u57282017\u5e74\u95f0\u79d2\u51fa\u73b0\u90a3\u4e00\u6b21\u51fa\u73b0\u8fc7\u90e8\u5206\u673a\u5668\u56de\u62e8\uff0c\u7531\u4e8eLeaf-snowflake\u7684\u7b56\u7565\u4fdd\u8bc1\uff0c\u6210\u529f\u907f\u514d\u4e86\u5bf9\u4e1a\u52a1\u9020\u6210\u7684\u5f71\u54cd\u3002<\/strong><\/p>\n<p>Leaf\u5728\u7f8e\u56e2\u70b9\u8bc4\u516c\u53f8\u5185\u90e8\u670d\u52a1\u5305\u542b\u91d1\u878d\u3001\u652f\u4ed8\u4ea4\u6613\u3001\u9910\u996e\u3001\u5916\u5356\u3001\u9152\u5e97\u65c5\u6e38\u3001\u732b\u773c\u7535\u5f71\u7b49\u4f17\u591a\u4e1a\u52a1\u7ebf\u3002\u76ee\u524dLeaf\u7684\u6027\u80fd\u57284C8G\u7684\u673a\u5668\u4e0aQPS\u80fd\u538b\u6d4b\u5230\u8fd15w\/s\uff0cTP999 1ms\uff0c\u5df2\u7ecf\u80fd\u591f\u6ee1\u8db3\u5927\u90e8\u5206\u7684\u4e1a\u52a1\u7684\u9700\u6c42\u3002\u6bcf\u5929\u63d0\u4f9b\u4ebf\u6570\u91cf\u7ea7\u7684\u8c03\u7528\u91cf\uff0c\u4f5c\u4e3a\u516c\u53f8\u5185\u90e8\u516c\u5171\u7684\u57fa\u7840\u6280\u672f\u8bbe\u65bd\uff0c\u5fc5\u987b\u4fdd\u8bc1\u9ad8SLA\u548c\u9ad8\u6027\u80fd\u7684\u670d\u52a1\uff0c\u6211\u4eec\u76ee\u524d\u8fd8\u4ec5\u4ec5\u8fbe\u5230\u4e86\u53ca\u683c\u7ebf\uff0c\u8fd8\u6709\u5f88\u591a\u63d0\u9ad8\u7684\u7a7a\u95f4\u3002<\/p>\n<p>\u7167\u4e1c\uff0c\u7f8e\u56e2\u70b9\u8bc4\u57fa\u7840\u67b6\u6784\u56e2\u961f\u6210\u5458\uff0c\u4e3b\u8981\u53c2\u4e0e<a href=\"http:\/\/tech.meituan.com\/mt-mtrace.html\">\u7f8e\u56e2\u5927\u578b\u5206\u5e03\u5f0f\u94fe\u8def\u8ddf\u8e2a\u7cfb\u7edfMtrace<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>\u548c\u7f8e\u56e2\u70b9\u8bc4\u5206\u5e03\u5f0fID\u751f\u6210\u7cfb\u7edfLeaf\u7684\u5f00\u53d1\u5de5\u4f5c\u3002\u66fe\u5c31\u804c\u4e8e\u963f\u91cc\u5df4\u5df4\uff0c2016\u5e747\u6708\u52a0\u5165\u7f8e\u56e2\u3002<\/p>\n<p>\u6700\u540e\u505a\u4e00\u4e2a\u62db\u8058\u5e7f\u544a\uff1a\u5982\u679c\u4f60\u5bf9\u5927\u89c4\u6a21\u5206\u5e03\u5f0f\u73af\u5883\u4e0b\u7684\u670d\u52a1\u6cbb\u7406\u3001\u5206\u5e03\u5f0f\u4f1a\u8bdd\u94fe\u8ffd\u8e2a\u7b49\u7cfb\u7edf\u611f\u5174\u8da3\uff0c\u8bda\u631a\u6b22\u8fce\u6295\u9012\u7b80\u5386\u81f3\uff1azhangjinlu#meituan.com\u3002<\/p>\n<ol>\n<li>\u65bd\u74e6\u8328. \u9ad8\u6027\u80fdMySQL[M]. \u7535\u5b50\u5de5\u4e1a\u51fa\u7248\u793e, 2010:162-171.<\/li>\n<li><a href=\"https:\/\/zh.wikipedia.org\/wiki\/%E9%80%9A%E7%94%A8%E5%94%AF%E4%B8%80%E8%AF%86%E5%88%AB%E7%A0%81\">\u7ef4\u57fa\u767e\u79d1\uff1aUUID<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>.<\/li>\n<li><a href=\"https:\/\/github.com\/twitter\/snowflake\">snowflake<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>.<\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/innodb-index-types.html\">MySQL: Clustered and Secondary Indexes<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>.<\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/replication-semisync.html\">\u534a\u540c\u6b65\u590d\u5236 Semisynchronous Replication<i class=\"fa fa-link\" aria-hidden=\"true\"><\/i><\/a>.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<div class=\"meta-box post-bottom-meta-box hidden-print\"><span class=\"tag-links\"><i class=\"fa fa-tags\" aria-hidden=\"true\"><\/i><a href=\"https:\/\/tech.meituan.com\/tags\/%E5%90%8E%E5%8F%B0.html\" rel=\"tag\">\u540e\u53f0<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E5%9F%BA%E7%A1%80%E7%A0%94%E5%8F%91%E5%B9%B3%E5%8F%B0.html\" rel=\"tag\">\u57fa\u7840\u7814\u53d1\u5e73\u53f0<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E5%88%86%E5%B8%83%E5%BC%8F.html\" rel=\"tag\">\u5206\u5e03\u5f0f<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E5%94%AF%E4%B8%80id.html\" rel=\"tag\">\u552f\u4e00ID<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E9%AB%98%E5%8F%AF%E7%94%A8.html\" rel=\"tag\">\u9ad8\u53ef\u7528<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E9%AB%98%E6%80%A7%E8%83%BD.html\" rel=\"tag\">\u9ad8\u6027\u80fd<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E6%8A%80%E6%9C%AF%E5%B7%A5%E7%A8%8B.html\" rel=\"tag\">\u6280\u672f\u5de5\u7a0b<\/a>,\u00a0<a href=\"https:\/\/tech.meituan.com\/tags\/%E5%9F%BA%E7%A1%80%E6%9E%B6%E6%9E%84.html\" rel=\"tag\">\u57fa\u7840\u67b6\u6784<\/a><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u539f\u6587\u5730\u5740 &nbsp; 2017\u5e7404\u6708<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[118],"class_list":["post-4006","post","type-post","status-publish","format-standard","hentry","tag-02-"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/4006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=4006"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/4006\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=4006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=4006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=4006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}