{"id":10008340,"date":"2023-09-26T23:57:41","date_gmt":"2023-09-26T15:57:41","guid":{"rendered":"https:\/\/blog.itmax.cn\/?p=10008340"},"modified":"2023-09-26T23:57:41","modified_gmt":"2023-09-26T15:57:41","slug":"vitess%e5%85%a8%e5%b1%80%e5%94%af%e4%b8%80id%e7%94%9f%e6%88%90%e7%9a%84%e5%ae%9e%e7%8e%b0%e6%96%b9%e6%a1%88-%e4%ba%ac%e4%b8%9c%e4%ba%91%e6%8a%80%e6%9c%af%e5%9b%a2%e9%98%9f","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10008340","title":{"rendered":"Vitess\u5168\u5c40\u552f\u4e00ID\u751f\u6210\u7684\u5b9e\u73b0\u65b9\u6848 | \u4eac\u4e1c\u4e91\u6280\u672f\u56e2\u961f"},"content":{"rendered":"<p>\u4e3a\u4e86\u6807\u8bc6\u4e00\u6bb5\u6570\u636e\uff0c\u901a\u5e38\u6211\u4eec\u4f1a\u4e3a\u5176\u6307\u5b9a\u4e00\u4e2a\u552f\u4e00id\uff0c\u6bd4\u5982\u5229\u7528MySQL\u6570\u636e\u5e93\u4e2d\u7684\u81ea\u589e\u4e3b\u952e\u3002 \u4f46\u662f\u5f53\u6570\u636e\u91cf\u975e\u5e38\u5927\u65f6\uff0c\u4ec5\u9760\u6570\u636e\u5e93\u7684\u81ea\u589e\u4e3b\u952e\u662f\u8fdc\u8fdc\u4e0d\u591f\u7684\uff0c\u5e76\u4e14\u5bf9\u4e8e\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u53ea\u4f9d\u8d56MySQL\u7684\u81ea\u589eid\u65e0\u6cd5\u6ee1\u8db3\u5168\u5c40\u552f\u4e00\u7684\u9700\u6c42\u3002\u56e0\u6b64\uff0c\u4ea7\u751f\u4e86\u591a\u79cd\u89e3\u51b3\u65b9\u6848\uff0c\u5982UUID\uff0cSnowFlake\u7b49\u3002\u4e0b\u6587\u5c06\u4ecb\u7ecdVitess\u662f\u5982\u4f55\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u3002<\/p>\n<h2>Vitess\u5168\u5c40\u552f\u4e00id\u751f\u6210<\/h2>\n<p>\u5728Vitess\u5b9e\u73b0\u65b9\u6848\u4e2d\uff0c\u6bcf\u4e2a\u8bbe\u7f6e\u4e86\u5168\u5c40\u552f\u4e00\u5217\u7684\u8868\uff0c\u90fd\u4f1a\u5bf9\u5e94\u4e00\u5f20sequence\u5e8f\u5217\u8868\u3002\u4f8b\u5982\u5bf9\u4e8e\u8868user\uff0c\u4f1a\u5bf9\u5e94\u4e00\u5f20\u540d\u4e3auser_seq\u7684\u5e8f\u5217\u8868\uff0c\u539f\u8868\u4e0e\u5e8f\u5217\u8868\u7684\u5173\u8054\u5173\u7cfb\u4f1a\u8bb0\u5f55\u5728\u5143\u6570\u636e\u4e2d\u3002user\u8868\u4ee5\u53causer_seq\u8fd9\u4e24\u5f20\u8868\u5143\u6570\u636e\u4fe1\u606f\u5206\u522b\u5982\u4e0b\uff1a<\/p>\n<p>user\u8868\u5143\u6570\u636e\uff1a\u5206\u7247\u952e\u4e3aname\u5217\uff0c\u5206\u7247\u7b97\u6cd5\u4e3ahash\uff1b\u5168\u5c40\u552f\u4e00\u5217\u4e3aid\u5217\uff0c\u4f9d\u8d56user_seq\u8868\u751f\u6210\u5177\u4f53\u7684\u503c\u3002<\/p>\n<pre><code>{\n    &quot;tables&quot;: {\n        &quot;user&quot;: {\n            &quot;column_vindexes&quot;: [\n                {\n                    &quot;column&quot;: &quot;name&quot;,\n                    &quot;name&quot;: &quot;hash&quot;\n                }\n            ],\n            &quot;auto_increment&quot;: {\n                &quot;column&quot;: &quot;id&quot;,\n                &quot;sequence&quot;: &quot;user_seq&quot;\n            }\n        }\n    }\n}<\/code><\/pre>\n<p>user_seq\u8868\u5143\u6570\u636e\uff1a\u8868\u7c7b\u578b\u6807\u8bc6\u4e3asequence\u3002<\/p>\n<pre><code>{\n  &quot;tables&quot;: {\n    &quot;user_seq&quot;: {\n      &quot;type&quot;: &quot;sequence&quot;\n    }\n  }\n}<\/code><\/pre>\n<p>\u6240\u6709sequence\u8868\u8868\u7ed3\u6784\u76f8\u540c\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<pre><code>CREATE TABLE user_seq (\n    id int,\n    next_id bigint,\n    cache bigint,\n    PRIMARY KEY (id)\n) COMMENT 'vitess_sequence';<\/code><\/pre>\n<p>\u4e14\u5176\u4e2d\u53ea\u6709\u4e00\u6761id\u4e3a0\u7684\u6570\u636e\uff1a<\/p>\n<pre><code>mysql&gt; select * from user_seq;\n+----+---------+-------+\n| id | next_id | cache |\n+----+---------+-------+\n|  0 |    1000 |   100 |\n+----+---------+-------+<\/code><\/pre>\n<p><strong>sequence\u8868\u53ef\u4ee5\u8ba4\u4e3a\u662f\u4e00\u4e2a\u5206\u53f7\u5668\uff0ccache\u5b57\u6bb5\u8868\u793a\u6bcf\u6b21\u53d1\u653e\u53f7\u6bb5\u7684\u4e2a\u6570\uff0cnext_id\u5217\u8868\u793a\u6bcf\u6b21\u53d1\u653e\u53f7\u6bb5\u7684\u8d77\u59cb\u503c<\/strong><strong>\u3002<\/strong>Vitess\u6bcf\u4e2a\u5206\u7247\u5728\u521d\u59cb\u5316\u65f6\u4f1a\u4ecesequence\u6839\u636enext_id\u3001cache\u83b7\u53d6\u53f7\u6bb5\u4fdd\u5b58\u5728VtTablet\uff08MySQL\u5b9e\u4f8b\u524d\u7684\u4ee3\u7406\u670d\u52a1\uff09\u7684\u5185\u5b58\u4e2d\uff0c\u5f53\u5185\u5b58\u4e2d\u53f7\u6bb5\u8017\u5c3d\u65f6\uff0c\u518d\u6b21\u4ecesequence\u8868\u4e2d\u83b7\u53d6\u65b0\u53f7\u6bb5\u3002<\/p>\n<p><strong>\u6211\u4eec\u6df1\u5165\u4ee3\u7801\u770b\u4e00\u4e0b\u5177\u4f53\u7684\u5b9e\u73b0\u903b\u8f91\uff1a<\/strong><\/p>\n<pre><code>\/\/ \u83b7\u53d6sequence\u7684\u65b9\u6cd5\nfunc (qre *QueryExecutor) execNextval() (*sqltypes.Result, error) {\n    \/\/ \u4eceplan\u4e2d\u83b7\u53d6inc\uff08\u4e3a\u8981\u83b7\u53d6\u7684id\u6570\u91cf\uff09\u4ee5\u53catableName\n    inc, err := resolveNumber(qre.plan.NextCount, qre.bindVars)\n    tableName := qre.plan.TableName()\n    t := qre.plan.Table\n    t.SequenceInfo.Lock()\n    defer t.SequenceInfo.Unlock()\n    if t.SequenceInfo.NextVal == 0 || t.SequenceInfo.NextVal+inc &gt; t.SequenceInfo.LastVal {\n        \/\/ \u5728\u4e8b\u52a1\u4e2d\u8fd0\u884c\n        _, err := qre.execAsTransaction(func(conn *StatefulConnection) (*sqltypes.Result, error) {\n            \/\/ \u4f7f\u7528select for update\u9501\u4f4f\u884c\u6570\u636e\u4ee5\u514d\u5728\u8ba1\u7b97\u5e76\u66f4\u65b0\u65b0\u503c\u671f\u95f4\u88ab\u5176\u4ed6\u7ebf\u7a0b\u4fee\u6539\n            query := fmt.Sprintf(&quot;select next_id, cache from %s where id = 0 for update&quot;, sqlparser.String(tableName))\n            qr, err := qre.execSQL(conn, query, false)\n            nextID, err := evalengine.ToInt64(qr.Rows[0][0])\n\n            if t.SequenceInfo.LastVal != nextID {\n                \/\/ \u5982\u679c\u4ece_seq\u8868\u8bfb\u53d6\u5f97\u5230\u7684id\u503c\u5c0f\u4e8etablet\u7f13\u5b58\u4e2did\uff0c\u5219\u5c06\u7f13\u5b58\u4e2d\u7684\u503c\u66f4\u65b0\u5230_seq\u8868\u4e2d\n                if nextID &lt; t.SequenceInfo.LastVal {\n                    log.Warningf(&quot;Sequence next ID value %v is below the currently cached max %v, updating it to max&quot;, nextID, t.SequenceInfo.LastVal)\n                    nextID = t.SequenceInfo.LastVal\n                }\n                t.SequenceInfo.NextVal = nextID\n                t.SequenceInfo.LastVal = nextID\n            }\n            cache, err := evalengine.ToInt64(qr.Rows[0][1])\n\n            \/\/ \u6309\u7167cache\u7684\u500d\u6570\u83b7\u53d6\u5230\u5927\u4e8einc\u91cf\u7684\u7f13\u5b58\uff0c\u8ba1\u7b97\u51fa\u65b0newLast\n            newLast := nextID + cache\n            for newLast &lt; t.SequenceInfo.NextVal+inc {\n                newLast += cache\n            }\n            \/\/ \u5c06\u65b0\u7684\u8fb9\u754c\u503c\u66f4\u65b0\u5230_seq\u8868\u4e2d\n            query = fmt.Sprintf(&quot;update %s set next_id = %d where id = 0&quot;, sqlparser.String(tableName), newLast)\n            _, err = qre.execSQL(conn, query, false)\n            t.SequenceInfo.LastVal = newLast\n        })\n    }\n    \/\/ \u8fd4\u56de\u83b7\u53d6\u7684sequence\u503c \u66f4\u65b0SequenceInfo\n    ret := t.SequenceInfo.NextVal\n    t.SequenceInfo.NextVal += inc\n    return ret\n}<\/code><\/pre>\n<p>\u4ece\u6e90\u7801\u4e2d\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n<ol>\n<li>Vitess\u4f7f\u7528\u4e86\u4e8b\u52a1\u5185\u9501\u884c\uff08<code>select for update<\/code>\uff09\u7684\u65b9\u5f0f\u4fdd\u8bc1\u4e86\u591a\u7ebf\u7a0b\u4e0b\u67e5\u8be2\u5e76\u66f4\u65b0\u5e8f\u5217\u8868\u4e0d\u4f1a\u4e92\u76f8\u5e72\u6270\u3002<\/li>\n<li>\u5982\u679cVtTablet\u4e2d\u81ea\u589e\u5e8f\u5217\u503c\u7f13\u5b58\u4e0d\u8db3\u6216\u8005\u53f7\u6bb5\u8017\u5c3d\u540e\uff0c\u4ecesequence\u8868\u91cd\u65b0\u83b7\u53d6\u503c\uff0c\u5e76\u66f4\u65b0\u5e8f\u5217\u8868\u4e2dnext_id\u5b57\u6bb5\u3002<\/li>\n<li>\u6839\u636e<code>inc<\/code>\u7684\u5927\u5c0f\uff0c\u5373\u6240\u9700ID\u7684\u6570\u91cf\uff0cVtTablet\u4f1a\u4ee5<code>cache<\/code>\u4e3a\u6700\u5c0f\u5757\uff0c\u4ece\u5e8f\u5217\u8868\u4e2d\u83b7\u53d6n*cache\u4e2a\u6570\u91cf\u7684id\u7f13\u5b58\u5728\u5185\u5b58\u4e2d\u3002<\/li>\n<\/ol>\n<p><strong>\u8865\u5145\u8bf4\u660e\uff1a<\/strong><\/p>\n<p>1. sequence\u8868\u4e3a\u975e\u62c6\u5206\u7684\u8868\u3002<\/p>\n<p>2. \u5168\u5c40\u552f\u4e00id\u751f\u6210\u65e0\u6cd5\u4fdd\u8bc1\u8fde\u7eed\u6027\u3002<\/p>\n<h2>VtDriver\u5b9e\u73b0\u65b9\u5f0f<\/h2>\n<p>\u5728Vitess\u7684SDK\u5ba2\u6237\u7aef\u65b9\u6848VtDriver\u4e2d\uff0csequence\u7684\u751f\u6210\u903b\u8f91\u88ab\u5c01\u88c5\u5728\u4e86MySQL\u9a71\u52a8\u5305\u672c\u8eab\u5f53\u4e2d\uff0c\u4e0eVitess\u7684\u65b9\u6848\u7c7b\u4f3c\uff0c\u5bf9\u4e8e\u8bbe\u7f6e\u4e86\u5168\u5c40\u81ea\u589e\u7684\u8868\uff0c\u5176sequence\u7684\u751f\u6210\u540c\u6837\u4f9d\u8d56\u4e8e\u5bf9\u5e94\u7684\u5e8f\u5217\u8868\uff0c\u5e8f\u5217\u8868\u7684\u7ed3\u6784\u4e0eVitess\u7684\u5e8f\u5217\u8868\u76f8\u540c\uff08\u53c2\u4e0a\uff09\uff0c\u4f46\u662f\u8bfb\u53d6\u5e76\u66f4\u65b0\u5b57\u6bb5next_id\u7684\u65b9\u5f0f\u4f7f\u7528\u4e86CAS\u7684\u65b9\u6848\uff1a<\/p>\n<pre><code>public long[] querySequenceValue(Vcursor vCursor, ResolvedShard resolvedShard, String sequenceTableName) throws SQLException, InterruptedException {\n    \/\/ cas \u91cd\u8bd5\u6b21\u6570\u9650\u5236\n    int retryTimes = DEFAULT_RETRY_TIMES;\n    while (retryTimes &gt; 0) {\n        \/\/ \u67e5\u8be2_seq\u8868\u4e2d\u7684sequence\u8bbe\u7f6e\uff0c\u5176\u4e2dcache\u4e3a\u672c\u5730\u7f13\u5b58\u7684\u5927\u5c0f\n        String querySql = &quot;select next_id, cache from &quot; + sequenceTableName + &quot; where id = 0&quot;;\n        VtResultSet vtResultSet = (VtResultSet) vCursor.executeStandalone(querySql, new HashMap&lt;&gt;(), resolvedShard, false);\n        long[] sequenceInfo = getVtResultValue(vtResultSet);\n        long next = sequenceInfo[0];\n        long cache = sequenceInfo[1];\n\n        \/\/ \u5c06\u8ba1\u7b97\u51fa\u7684next_id\u7684\u503c\u5c1d\u8bd5\u66f4\u65b0\u5230_seq\u8868\u4e2d\uff0c\u5982\u679c\u5931\u8d25\u5219\u91cd\u65b0\u8bfb\u53d6\u5e76\u66f4\u65b0\uff0c\u76f4\u5230\u6210\u529f\u4e3a\u6b62\n        String updateSql = &quot;update &quot; + sequenceTableName + &quot; set next_id = &quot; + (next + cache) + &quot; where next_id =&quot; + sequenceInfo[0];\n        VtRowList vtRowList = vCursor.executeStandalone(updateSql, new HashMap&lt;&gt;(), resolvedShard, false);\n        if (vtRowList.getRowsAffected() == 1) {\n            sequenceInfo[0] = next;\n            return sequenceInfo;\n        }\n        retryTimes--;\n        Thread.sleep(ThreadLocalRandom.current().nextInt(1, 6));\n    }\n    throw new SQLException(&quot;Update sequence cache failed within retryTimes: &quot; + DEFAULT_RETRY_TIMES);\n}<\/code><\/pre>\n<p>\u5728\u6e90\u7801\u4e2d\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n<ol>\n<li>\u5728\u6574\u4e2a\u67e5\u8be2\u5e76\u66f4\u65b0\u5e8f\u5217\u8868\u7684\u8fc7\u7a0b\u4e2d\uff0c\u6ca1\u6709\u51fa\u73b0Vitess\u5b9e\u73b0\u4e2d\u7684\u5f00\u542f\u4e8b\u52a1\u4ee5\u53ca\u4ea7\u751f\u9501\u8868\u7684\u60c5\u51b5\uff0c\u800c\u662f\u4f7f\u7528\u4e86CAS\u66f4\u65b0\u7684\u65b9\u5f0f\u3002<\/li>\n<li>\u5229\u7528<code>update user_seq set next_id=\uff1f where next_id=\uff1f<\/code>\u6267\u884c\u7684\u8fd4\u56de\u503c\u5224\u65ad\u662f\u5426\u8bed\u53e5\u662f\u5426\u66f4\u65b0\u6210\u529f\uff0c\u5982\u679c\u5931\u8d25\u5219\u91cd\u65b0\u67e5\u8be2<code>next_id<\/code>\u7684\u503c\uff0c\u8ba1\u7b97\u65b0\u503c\u518d\u5c1d\u8bd5\u66f4\u65b0\uff0c \u5982\u679c\u51fa\u73b0\u5e76\u53d1\u4e89\u62a2\u7684\u60c5\u51b5\uff0cVtdriver\u4e2d\u5141\u8bb8\u6700\u591a\u7684\u91cd\u8bd5\u6b21\u6570<code>DEFAULT_RETRY_TIMES<\/code>\u4e3a100\u6b21\u3002<\/li>\n<\/ol>\n<p>VtDriver\u4e2d\u4f7f\u7528sequence\u7684\u65b9\u5f0f\u4e0eMySQL\u81ea\u589e\u952e\u7c7b\u4f3c\uff0c\u5982\u679c\u8bbe\u7f6e\u4e86sequence\u7684\u8868\u5728\u63d2\u5165\u6570\u636e\u7684\u8fc7\u7a0b\u4e2d\uff0c\u81ea\u589e\u5217\u6ca1\u6709\u7ed9\u5b9a\u5177\u4f53\u7684\u503c\uff0c\u4f1a\u76f4\u63a5\u4ece\u672c\u5730\u7f13\u5b58\u4e2d\u83b7\u53d6\u81ea\u589eID\uff0c<strong>\u5982\u679c\u65e0\u7f13\u5b58\u6216\u8005\u7f13\u5b58\u4e0d\u8db3\u65f6\uff0c\u624d\u4f1a\u8def\u7531\u5230\u5e8f\u5217\u8868\u6240\u5728MySQL\u670d\u52a1\u83b7\u53d6sequence\u503c<\/strong>\u3002<\/p>\n<h3>\u4e8b\u52a1+\u9501\u8868 or CAS \uff1f<\/h3>\n<p>\u5728Vitess\u5b9e\u73b0sequence\u7684\u6e90\u7801\u5f53\u4e2d\uff0c\u5176\u66f4\u65b0\u5e8f\u5217\u8868\u7684\u8fc7\u7a0b\u4e3a\uff1a\u5f00\u542f\u4e8b\u52a1\u65f6\u6267\u884cselect for update\uff0c\u4f7f\u7528\u8868\u9501\uff0c\u4fdd\u8bc1\u591a\u7ebf\u7a0b\u5b89\u5168\u3002\u5728\u73b0\u5b9e\u5f80\u5f80\u5145\u6ee1\u4e86\u4e0d\u786e\u5b9a\u6027\uff0c\u6211\u4eec\u53ef\u4ee5\u60f3\u8c61\u4e00\u4e0b\uff1a\u5982\u679c\u5e94\u7528\u9501\u4e86\u6570\u636e\u5e93\u4e2d\u7684\u8868\u540e\uff0c\u7531\u4e8e\u81ea\u8eab\u7684\u6027\u80fd\u539f\u56e0\u7b49\u800c\u8fdf\u8fdf\u6ca1\u6709\u6267\u884ccommit\u64cd\u4f5c\uff0c\u6216\u8005\u5e94\u7528\u8282\u70b9\u51fa\u73b0\u4e86\u5b95\u673a\u7684\u60c5\u51b5\uff0c\u6b64\u65f6\uff1a<\/p>\n<p><strong>\u5e94\u7528\u5b95\u673a\u540e\uff0c\u5176\u6301\u6709\u7684\u9501\u4e0d\u4f1a\u88ab\u91ca\u653e\uff01\u540e\u7eed\u4efb\u4f55\u5176\u4ed6\u8fde\u63a5\u5bf9\u4e8e\u8be5\u8868\u7684\u4efb\u4f55SQL\u90fd\u4f1a\u88ab\u6301\u7eed\u963b\u585e\uff01<\/strong><\/p>\n<p>\u200bVtDriver\u4f5c\u4e3aVitess\u7684\u5ba2\u6237\u7aef\u65b9\u6848\uff0c\u5982\u679c\u5176sequence\u5b9e\u73b0\u91c7\u7528\u4e8b\u52a1\u9501\u7684\u65b9\u5f0f\uff0c\u7531\u4e8e\u5404\u4e2a\u5e94\u7528\u7aef\u90fd\u4f1a\u4e0eMySQL\u670d\u52a1\u76f4\u8fde\uff0c\u5373\u5404\u4e2a\u5e94\u7528\u83b7\u53d6sequence\u7684\u8fc7\u7a0b\u90fd\u4f1a\u4ea7\u751f\u9501\u8868\u7684\u884c\u4e3a\u3002\u6b64\u65f6\uff0c\u4e00\u65e6\u5e94\u7528\u7aef\u7531\u4e8e\u67d0\u4e9b\u539f\u56e0\u51fa\u73b0\u9501\u8868\u65f6\u957f\u589e\u5927\uff0c\u751a\u81f3\u4e8e\u5e94\u7528\u5b95\u673a\u7684\u60c5\u51b5\uff0c\u5219\u6240\u6709\u5e94\u7528\u90fd\u4f1a\u7531\u4e8e\u5176\u9501\u8868\u800c\u4ea7\u751f\u975e\u5e38\u660e\u663e\u7684\u6027\u80fd\u4e0b\u964d\u751a\u81f3\u6b7b\u9501\u3002\u91c7\u7528cas\u7684\u65b9\u5f0f\u4f7f\u5f97\u6574\u4e2a\u8fc7\u7a0b\u4e0d\u9700\u8981\u663e\u5f0f\u7684\u5f00\u542f\u4e8b\u52a1\uff0c\u4e0d\u9700\u8981\u9501\u884c\uff0c\u81ea\u7136\u4e5f\u4e0d\u5b58\u5728\u6f5c\u5728\u7684\u6b7b\u9501\u98ce\u9669\u3002\u5f53\u7136\uff0cCAS\u5728\u5e76\u53d1\u9ad8\u4e8e\u4e00\u5b9a\u7a0b\u5ea6\u65f6\u4f1a\u51fa\u73b0\u5404\u4e2a\u7ebf\u7a0b\u4e92\u76f8\u4e89\u62a2\u8d44\u6e90\uff0c\u6b64\u65f6\u4f1a\u6709\u66f4\u65b0\u5931\u8d25\u4e0d\u65ad\u91cd\u8bd5\u7684\u60c5\u51b5\u53d1\u751f\uff0c\u7ed9CPU\u5e26\u6765\u4e00\u5b9a\u7684\u538b\u529b\uff0c\u800c\u8fd9\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u66f4\u5927\u7684cache\u503c\uff0c\u589e\u52a0\u672c\u5730\u7f13\u5b58\u6570\u91cf\u7684\u65b9\u5f0f\u6765\u8c03\u8282\u3002<\/p>\n<blockquote>\n<p>\u4f5c\u8005\uff1a\u4eac\u4e1c\u96f6\u552e \u91d1\u8d8a<\/p>\n<p>\u6765\u6e90\uff1a\u4eac\u4e1c\u4e91\u5f00\u53d1\u8005\u793e\u533a \u8f6c\u8f7d\u8bf7\u6ce8\u660e\u6765\u6e90<\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000044261828\">https:\/\/segmentfault.com\/a\/1190000044261828<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e3a\u4e86\u6807\u8bc6\u4e00\u6bb5\u6570\u636e\uff0c\u901a\u5e38\u6211\u4eec\u4f1a\u4e3a\u5176\u6307\u5b9a\u4e00\u4e2a\u552f\u4e00id\uff0c\u6bd4\u5982\u5229\u7528MySQL\u6570\u636e\u5e93\u4e2d\u7684\u81ea\u589e\u4e3b\u952e\u3002 \u4f46\u662f\u5f53\u6570\u636e\u91cf\u975e\u5e38\u5927\u65f6 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10008340","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10008340"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008340\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10008340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10008340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10008340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}