{"id":96848,"date":"2020-04-26T20:26:50","date_gmt":"2020-04-26T12:26:50","guid":{"rendered":"http:\/\/4563.org\/?p=96848"},"modified":"2020-04-26T20:26:50","modified_gmt":"2020-04-26T12:26:50","slug":"%e5%85%b3%e4%ba%8e%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e7%9a%84-deployment-%e4%b8%8e-database-changes-%e8%af%b8%e4%bd%8d%e5%9c%a8%e5%ae%9e%e9%99%85%e4%b8%ad%e6%98%af%e5%a6%82%e4%bd%95%e5%a4%84","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=96848","title":{"rendered":"\u5173\u4e8e\u5e94\u7528\u7a0b\u5e8f\u7684 Deployment \u4e0e Database Changes, \u8bf8\u4f4d\u5728\u5b9e\u9645\u4e2d\u662f\u5982\u4f55\u5904\u7406\u7684?"},"content":{"rendered":"
\n
\n
\n

\u5173\u4e8e\u5e94\u7528\u7a0b\u5e8f\u7684 Deployment \u4e0e Database Changes, \u8bf8\u4f4d\u5728\u5b9e\u9645\u4e2d\u662f\u5982\u4f55\u5904\u7406\u7684? <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/i> 56<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\u6211\u5f53\u524d\u7684\u4e00\u4e2a Project \u4e2d\u56ca\u62ec\u5927\u6982\u4e00\u767e\u6709\u4f59 apps, 70-80%\u4e3a Java\/kotlin apps,\u6240\u6709\u8fd9\u4e9b\u662f\u501f\u7531 flyway \u6765\u7ba1\u7406\u6bcf\u6b21 release \u7684 database changes. \u6240\u6709 applications \u53ef\u80fd\u4e0e\u4e0d\u540c\u7684 database \u8fde\u63a5, \u5728 app \u542f\u52a8\u7684\u65f6\u5019\u68c0\u67e5\u5e76\u6267\u884c flyway \u811a\u672c.<\/p>\n

\u901a\u5e38\u60c5\u666f\u4e0b, \u6b64\u65b9\u6848\u5c1a\u53ef\u884c, \u4e14\u6240\u6709\u540c\u4e8b\u4e5f\u5df2\u719f\u77e5 flyway \u7684\u4f18\u7f3a\u70b9, \u8fd9\u4e2a\u65b9\u6848\u4e5f\u6210\u4e3a\u4e86 Project \u91cc\u7684\u4e00\u4e2a”\u4f20\u7edf”.<\/p>\n

\u7136\u800c, \u6709\u4e00\u4e9b\u60c5\u51b5, \u91c7\u53d6\u8fd9\u4e2a\u65b9\u5f0f\u5c31\u663e\u5f97\u6bd4\u8f83\u68d8\u624b. \u6bd4\u5982, \u5728 database \u7684\u4fee\u6539\u4e2d, \u6709\u4e00\u4e9b\u8bed\u53e5\u9700\u8981 1-2 \u5c0f\u65f6\u7684\u65f6\u95f4\u6267\u884c. \u4f8b\u5982, \u91cd\u5efa index \u6216\u8005\u65b0\u5efa\u4e00\u4e9b\u65e0 default \u7684 col. \u5982\u679c\u4ecd\u7136\u4f9d\u4ed7 flyway \u6765\u5904\u7406\u8fd9\u4e9b\u8bed\u53e5, \u90a3\u4e48 deployment \u4ee5\u540e, app \u7684\u542f\u52a8\u65f6\u95f4\u5c06\u4f1a 1-2 \u5c0f\u65f6\u4e4b\u4e45. \u8fd9\u662f\u4e0d\u80fd\u63a5\u53d7\u7684\u4e00\u4e2a\u60c5\u51b5. \u6240\u4ee5\u73b0\u5728\u5bf9\u8fd9\u79cd\u60c5\u51b5\u53ea\u6709\u5728\u5f00\u53d1\u7684\u65f6\u5019, \u53d1\u73b0\u6709\u8fd9\u79cd\u53ef\u80fd\u7684\u8bed\u53e5, \u4e0d\u653e\u5728 flyway \u811a\u672c\u4e2d, \u800c\u662f\u5355\u72ec\u51fa\u6765, \u653e\u5728\u4e00\u4e2a\u5730\u65b9, \u7136\u540e\u5f04\u4e00\u4e2a ticket (we are using JIRA heavily), \u5728\u9700\u8981 release \u7684\u65f6\u5019\u4eba\u5de5\u6765\u6267\u884c\u8fd9\u4e9b\u8bed\u53e5, \u4e4b\u540e\u518d\u8fdb\u884c app \u7684 deployment.<\/p>\n

\u8fd8\u6709\u4e00\u4e2a\u95ee\u9898\u5c31\u662f, database changes \u5305\u542b rename, del column \u8fd9\u79cd, \u5c31\u4f1a\u66f4\u52a0\u9ebb\u70e6. \u76ee\u524d\u6211\u4eec\u662f\u5c3d\u91cf\u907f\u514d\u8fd9\u79cd\u64cd\u4f5c, \u5982\u679c\u786e\u5b9e\u9700\u8981, \u5c31\u53ea add new, \u7136\u540e\u7b49\u4e0b\u4e00\u6b21 deployment \u4e4b\u65e5, \u518d\u8fdb\u884c delete \u64cd\u4f5c. \u56e0\u4e3a\u6211\u4eec\u91c7\u7528 rolling deployment, \u5f53\u524d\u7684 deployment \u5982\u679c\u5931\u8d25,\u6bd4\u5982\u6709\u9519\u8bef\u6216\u8005\u8d85\u65f6, \u4e0d\u4f1a\u5f71\u54cd\u73b0\u5728\u6b63\u5728\u8fd0\u884c\u7684 pods (\u6211\u4eec\u4f7f\u7528 openshift) . \u4f46\u662f\u5982\u679c\u6709 database \u7ed3\u6784\u7684\u5220\u9664\u64cd\u4f5c, \u5f53\u524d\u8fd0\u884c\u7684 pod \u5c31\u4f1a\u4e0d\u6b63\u5e38.\u8fd9\u4e2a\u4e5f\u662f\u4e0d\u80fd\u63a5\u53d7\u7684. \u6211\u4eec\u8981\u5c3d\u91cf\u5b9e\u73b0\u7528\u6237\u89d2\u5ea6\u4e0d\u5bdf\u89c9\u7684 release.<\/p>\n

\u6211\u89c9\u5f97\u5f53\u524d\u91c7\u53d6\u7684\u5404\u79cd\u63aa\u65bd\u90fd\u4e0d\u662f\u81ea\u52a8\u5316\u7684, \u5f88\u591a\u4eba\u5de5\u53c2\u4e0e\u56e0\u7d20. \u5e94\u8be5\u4e0d\u662f\u6700\u4f18\u7684. \u6211\u80fd\u60f3\u5230\u7684\u7a0d\u5fae(\u53ef\u80fd)\u597d\u4e00\u4e9b\u7684\u65b9\u6848\u662f 2 \u4e2a\u6570\u636e\u5e93\u7684\u70ed\u5207\u6362, deployment \u5728 A, running pod \u5728 B, \u7136\u540e\u6570\u636e\u518d\u540c\u6b65. \u53ef\u662f\u8fd9\u4e2a\u5bf9\u4e8e\u6211\u4eec\u73b0\u5728\u662f\u4e0d\u53ef\u884c\u7684, \u56e0\u4e3a\u6570\u636e\u91cf\u786e\u5b9e\u5927, \u6ca1\u529e\u6cd5\u53cc\u4efd\u70ed\u5207\u6362.<\/p>\n

\u4e0d\u77e5\u9053\u5404\u4f4d\u6709\u6ca1\u6709\u7c7b\u4f3c\u7684\u95ee\u9898, \u662f\u5982\u4f55\u5904\u7406\u7684. \u7279\u522b\u662f\u6709 database \u7ed3\u6784\u5220\u9664\u64cd\u4f5c\u548c\u8f83\u4e3a\u8017\u65f6\u7684\u6570\u636e\u5e93\u8bed\u53e5\u7684\u60c5\u51b5.<\/p>\n

\u5148\u884c\u611f\u8c22. <\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (16<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : tomczhen <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8ba9\u6211\u60f3\u8d77\u4e4b\u524d\u7684\u6c42\u804c\u7684\u65f6\u5019\uff0c\u5bf9\u65b9\u5e94\u8be5\u662f\u5f00\u53d1\u8d1f\u8d23\u4eba\u3002\u4ed6\u4f3c\u4e4e\u89c9\u5f97 online DDL \u6709\u7b80\u5355\u7684\u901a\u7528\u65b9\u6848\u89e3\u51b3\u6240\u6709\u95ee\u9898\u3002\u6211\u53ea\u80fd\u8bf4\u7528 schemaless \u6570\u636e\u5e93\u4f1a\u597d\u53d7\u4e00\u4e9b\u3002<\/p>\n

    \u4f60\u7684\u611f\u89c9\u65b9\u5411\u662f\u5bf9\u7684\uff0c\u4e0d\u8fc7\u5b9e\u8df5\u561b\uff0c\u6211\u53ea\u770b\u8fc7\u51e0\u4e2a\u5927\u5382\u7684\u6280\u672f\u65b9\u6848\u5206\u4eab\u5c31\u89c9\u5f97\u771f\u7684\u592a\u591a\u5751\u4e86\u3002\u8bf4\u5230\u5e95\uff0c\u5982\u679c online DDL \u7684\u4ee3\u4ef7\u8d85\u8fc7\u505c\u673a\u7684\u4ee3\u4ef7\uff0c\u8fd8\u662f\u505c\u673a\u5427\u3002\u3002\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : monsterxx03 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5927\u540c\u5c0f\u5f02\uff0c\u6211\u4eec db migration \u7684\u5de5\u5177\u662f\u81ea\u5df1\u5199\u7684\uff0c\u4f46\u4e5f\u6ca1\u4ec0\u4e48\u7279\u522b\u7684\uff0c\u4e5f\u662f\u751f\u6210\u4e0b sql \u7136\u540e\u6267\u884c\u3002<\/p>\n

    \u5b9e\u9645\u4e0a\u7ebf\u7684\u65f6\u5019\uff0c\u5982\u679c\u6709 schema change, \u4f1a\u5206\u4e24\u6b21 deploy\uff0c\u7b2c\u4e00\u6b21\u90e8\u7f72\u5230\u5355\u72ec\u7684 server(\u65e5\u5e38\u4e3b\u8981\u662f\u8dd1 cron,\u548c\u4e00\u4e9b\u624b\u5de5\u811a\u672c\u7684\uff0c\u4e0d\u627f\u62c5\u7528\u6237\u6d41\u91cf)\uff0c\u5728\u4e0a\u9762\u624b\u5de5\u8fd0\u884c\uff0c\u7528\u7684 mysql(<8.0)\u539f\u751f\u7684 online ddl,\u4f46\u8fd9\u4e2a\u4e5f\u9700\u8981\u5728\u6d41\u91cf\u4f4e\u8c37\u65f6\u5019\u6267\u884c\uff0cio \u5f00\u9500\u5f88\u5927\u3002\u540c\u65f6\u8981\u6c42 schema change \u505a\u5230\u517c\u5bb9\uff0c\u7b2c\u4e8c\u6b21\u90e8\u7f72\u518d\u628a\u7528\u5230\u65b0 schema \u7ed3\u6784\u7684\u4ee3\u7801 rollout \u5230\u6240\u6709 server\u3002\u6574\u4e2a\u8fc7\u7a0b\u6ca1\u6709 down time,\u4f46\u6bd4\u8f83\u7e41\u7410\u3002<\/p>\n

    pt schema change \u548c github \u5f00\u6e90\u7684\u90a3\u4e2a\u5de5\u5177\u539f\u7406\u4e5f\u5927\u540c\u5c0f\u5f02\uff0c\u597d\u5904\u662f\u53ef\u4ee5\u770b\u5230\u8fdb\u5ea6\u548c\u63a7\u5236\u901f\u5ea6\uff0c\u4f46\u548c\u73b0\u6709\u6d41\u7a0b\u96c6\u6210\u66f4\u9ebb\u70e6\u70b9\uff0c\u6ca1\u6709\u5728\u7528\u3002<\/p>\n

    \u5b8c\u5168\u81ea\u52a8\u5316\u4e5f\u4e0d\u662f\u4e0d\u53ef\u80fd\uff0c\u4f46\u4e5f\u8981\u548c\u7ebf\u4e0a\u6d41\u91cf\u505a trade off\uff0c\u5bf9\u4e1a\u52a1\u89c4\u6a21\u6765\u8bf4\uff0c\u5f97\u4e0d\u507f\u5931\u3002\u4e1a\u52a1\u8981\u5b8c\u5168\u8bbe\u8ba1\u6210 schemaless \u4e5f\u4e0d\u592a\u73b0\u5b9e\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @monsterxx03 \u6211\u4eec\u7684\u9879\u76ee\u91cc, \u5927\u6982\u6709 3,40 \u4e2a apps \u662f\u5ba2\u6237\u76f4\u63a5\u7528\u7684, \u4e5f\u5c31\u662f\u8bf4\u5bf9\u4eba\u7684, \u5269\u4e0b\u5927\u90e8\u5206\u90fd\u4e0d\u662f\u5bf9\u4eba\u7684. \u800c\u4e14\u51e0\u4e4e\u6ca1\u6709\u6d41\u91cf\u4f4e\u8c37\u7684\u65f6\u5019, \u5404\u4e2a\u65f6\u533a\u90fd\u4f1a\u6709\u6765\u5f80\u6570\u636e, \u5176\u4e2d\u4e00\u4e9b\u541e\u5410\u91cf\u8fd8\u633a\u5927. \u6bcf\u6b21\u4ea7\u751f\u672a\u9884\u8ba1\u7684 out-age \u6216\u8005 downtime \u90fd\u7b97\u662f\u5927\u4e8b\u6545, \u56e0\u4e3a\u5404\u4e2a apps \u4e4b\u95f4\u90fd\u6709\u901a\u4fe1.
    \u867d\u7136\u73b0\u5728\u624b\u5de5\u5e72\u9884\u4e5f\u53ef\u4ee5\u51d1\u5408, \u4f46\u662f\u9690\u60a3\u633a\u591a. \u6574\u4e2a\u9879\u76ee\u4e00\u5171 100 \u591a\u4e2a\u5f00\u53d1\u4eba\u5458, \u5e76\u4e0d\u662f\u6240\u6709\u90fd\u5bf9 database \u7684\u53d8\u52a8\u540e\u679c\u5f88\u4e86\u89e3, \u4e5f\u8bb8\u5728\u81ea\u5df1\u5f00\u53d1\u73af\u5883, \u51e0\u6beb\u79d2\u5c31\u8fc7\u53bb\u7684\u51e0\u53e5\u8bed\u53e5, \u5230\u4e86 production stage \u4f1a\u4ea7\u751f\u610f\u5916\u7684\u6548\u679c. \u6211\u4eec\u53ea\u6709\u51e0\u4e2a database experts, \u5982\u679c\u4f11\u5047, \u6216\u8005\u75c5\u5047\u7b49, \u4e5f\u662f\u95ee\u9898, \u800c\u4e14\u76f4\u63a5\u624b\u5de5\u64cd\u4f5c database \u603b\u89c9\u5f97\u662f\u6709\u4e9b\u4e0d\u4fdd\u9669. \u5e38\u6709 squads \u53cd\u5e94\u6b64\u7c7b\u95ee\u9898. db changes \u548c deployment \u8fd9\u4e2a\u95ee\u9898\u4e00\u76f4\u4e5f\u6ca1\u6709\u6bd4\u8f83\u597d\u7684\u89e3\u51b3\u65b9\u6cd5. \u6240\u4ee5\u6765\u95ee\u95ee. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6ca1\u7528\u8fc7 flyway\u3002\u6570\u636e\u5e93\u53d8\u66f4\u5e94\u8be5\u548c app \u662f\u65e0\u5173\u7684\uff0c\u6bcf\u6b21 release \u5148\u505a\u6570\u636e\u5e93\u53d8\u66f4\uff0c\u518d release app\u3002\u6570\u636e\u5e93\u53d8\u66f4\u7684 sql \u5fc5\u987b\u8981\u4ea4\u7ed9\u4e13\u4e1a\u4eba\u58eb\u5ba1\u6838\u6267\u884c\uff0c\u81f3\u5c11\u505a\u5230\u53d8\u66f4\u5bf9\u73b0\u5728\u8fd0\u884c\u7684 app \u6ca1\u5f71\u54cd\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd “\u6570\u636e\u5e93\u53d8\u66f4\u5e94\u8be5\u548c app \u662f\u65e0\u5173\u7684” it depends… \u5982\u679c\u4f60\u770b\u4e86\u6211\u95ee\u9898\u7684\u5185\u5bb9, \u5c31\u4e0d\u96be\u8bbe\u60f3, \u5982\u82e5\u6211 delete \u4e00\u4e2a column, \u90a3\u4e48\u5f53\u524d\u8fd0\u884c\u7684 app \u5c31\u81ea\u7136\u4f1a\u6709\u5f71\u54cd. \u6240\u4ee5\u4f60\u8bf4\u7684”\u6bcf\u6b21 release \u5148\u505a\u6570\u636e\u5e93\u53d8\u66f4\uff0c\u518d release app” \u5c31\u4e0d\u6210\u7acb. \u8fd9\u4e5f\u662f\u6211\u4eec\u73b0\u5728\u5c3d\u53ef\u80fd\u907f\u514d(\u539f\u5219\u4e0a\u7981\u6b62)\u505a\u7ed3\u6784\u5220\u9664 \/renaming \u7684\u53d8\u66f4. \u4f46\u8fd9\u4e0d\u662f\u95ee\u9898\u7684 solution. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @KentY #5 \u8fd9\u5c31\u662f solution \u6211\u4eec\u5c31\u662f\u8fd9\u4e48\u505a\u7684\uff0c\u4f60\u8ba4\u4e3a\u4e0d\u662f\u53ef\u4ee5\u7ee7\u7eed\u627e\u627e\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : momocraft <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u611f\u8c22\u5206\u4eab\u3002\u6211\u4eec\u4e5f\u7528 flyway (\u548c scala \u4e00\u8d77)\u3002index \u548c schema change \u7684\u505a\u6cd5\u548c\u4f60\u8bf4\u7684\u7c7b\u4f3c\u3002<\/p>\n

    \u4e5f\u8bb8 \u6709 fs\/volume snapshot \u914d\u5408\u53ef\u4ee5\u505a\u5230\u4f60\u8bf4\u7684\u90a3\u79cd\u70ed\u5207\u6362 (\u6211\u6ca1\u6709\u8bd5\u8fc7) ?<\/p>\n

    \u53ef\u80fd schema \u73b0\u5728\u662f\u6570\u636e\u5e93\u4e2d\u6bd4\u8f83\u4e0d\u5206\u5e03\u5f0f\u53cb\u597d\u7684\u90e8\u5206\u4e86 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd \u5bf9\u4e0d\u8d77, \u53ef\u80fd\u6211\u5728\u4ee5\u4e0a\u4e4b\u56de\u590d\u4e2d\u6ca1\u8bf4\u660e\u767d, \u8ba9\u4f60\u8bef\u89e3\u4e86. \u6211\u60f3\u8868\u8fbe\u7684\u662f\u6211\u4eec\u73b0\u5728\u6240\u505a\u7684\u5bf9\u4e8e\u6211\u4eec\u9762\u4e34\u7684\u95ee\u9898\u6765\u8bf4, \u4e0d\u662f solution. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @KentY #8 \u6709\u70b9\u4e0d\u660e\u767d\u4f60\u8981\u7684 solution \u662f\u5565\uff1f\u5c31\u662f\u4e00\u5b9a\u8981\u6ee1\u8db3\u53ef\u4ee5\u5728\u542f\u52a8 app \u7684\u65f6\u5019\u6267\u884c\u6570\u636e\u5e93\u53d8\u66f4\u4e48\uff1f\u4f60\u8bf4\u7684\u5207\u6362\u6570\u636e\u5e93\u4e5f\u4f1a\u6709\u4e22\u5931\u6570\u636e\u7684\u53ef\u80fd\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @momocraft \u611f\u8c22\u4f60\u7684\u7ecf\u9a8c\u5206\u4eab. \u6211\u4eec\u4e5f\u6709\u4e0d\u591a\u7684 scala \u5e94\u7528. \u5927\u6982 3-5 \u4e2a. \u8fd8\u6709\u4e00\u90e8\u5206 python \u7684\u6570\u636e\u5206\u6790 apps.
    \u6211\u4eec\u7684\u5927\u4f53\u6570\u636e\u5e93\u5b58\u50a8\u7ed3\u6784\u662f, \u4e3b\u8981\u6570\u636e\u5e93\u662f\u5fae\u8f6f\u516c\u53f8\u7684 azure, \u7136\u540e\u90e8\u5206 apps \u90fd etl \u5230\u81ea\u5df1\u7684 postgres, \u6211\u8bf4\u7684\u95ee\u9898\u5bf9\u4e8e\u8fd9\u4e9b\u8bbf\u95ee postgres \u7684\u5e94\u7528\u6765\u8bf4\u5e76\u4e0d\u56f0\u96be, \u6211\u5199\u4e86\u76f8\u5173\u7684\u811a\u672c, \u57fa\u4e8e postgres \u7684\u5e94\u7528\u76ee\u524d\u53ef\u4ee5 deploy \u5230\u8ddf running pods \u4e0d\u540c\u7684 database schema. \u56e0\u4e3a etl \u7684\u6570\u636e\u53ef\u4ee5\u968f\u65f6\u91cd\u65b0\u5237\u4e00\u904d, \u53ea\u662f\u65f6\u95f4\u95ee\u9898, \u7136\u540e\u518d\u5728 openshift \u4e2d\u5207\u6362 pod,or configuration \u5373\u53ef<\/p>\n

    \u4f46\u662f\u5982\u679c\u662f\u4e0e\u6839\u6e90 azure \u6570\u636e\u5e93\u6253\u4ea4\u9053\u7684\u5e94\u7528\u7a0b\u5e8f, \u5c31\u9762\u4e34\u6211\u4e0a\u9762\u7684\u6311\u6218\u4e86.<\/p>\n

    \u9898\u5916\u8bdd, \u6211\u4eec\u5927\u90e8\u5206 database experts \u90fd\u662f\u5177\u5907\u5f88\u5f3a\u7684 oracle \u80cc\u666f\u7684, \u5728\u5b9e\u9645\u4f7f\u7528\u4e2d, \u4ed6\u4eec\u5e38\u5e38\u5bf9\u4e8e azure \u55e4\u4e4b\u4ee5\u9f3b. \ud83d\ude00 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd \u8fd9\u4e2a\u95ee\u9898\u7684\u63cf\u8ff0\u6211\u89c9\u5f97\u8fd8\u662f\u8bf4\u6e05\u4e86… \u770b\u6765\u6211\u7684\u8868\u8fbe\u80fd\u529b\u8fd8\u662f\u4e0d\u5c3d\u5982\u4eba\u610f.
    \u7b80\u5355\u518d\u8bf4\u4e00\u4e0b, \u5e0c\u671b\u80fd\u8868\u8ff0\u66f4\u660e\u767d.
    \u6211\u4eec\u7684 app \u542f\u52a8\u662f\u6709 timeout \u7684\u901a\u5e38\u662f 2-5min.\u8d85\u51fa\u4e86\u7684\u8bdd, \u4f1a\u6709 alert, \u8fd9\u4e9b\u7ba1\u7406\u4e0d\u7531\u5f00\u53d1\u56e2\u961f\u8d1f\u8d23, \u751a\u81f3\u662f\u53e6\u4e00\u4e2a\u516c\u53f8\u6765\u76d1\u63a7, \u6bcf\u6b21\u8fd9\u79cd\u90fd\u662f\u8981\u4ed8\u8d39. \u56e0\u4e3a\u4fdd\u9669\u5b89\u5168\u7f18\u6545,\u6211\u4eec\u4e0d\u80fd\u628a timeout \u8bbe\u7f6e\u6210\u6bd4\u5982 2 \u5c0f\u65f6, 3 \u5c0f\u65f6, \u8fd9\u6837\u6709\u65f6\u5019\u4f1a\u9690\u85cf\u771f\u6b63\u7684\u95ee\u9898. \u6240\u4ee5\u6570\u636e\u5e93\u53d8\u66f4\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\u5982\u679c\u8f83\u957f, \u6211\u4eec\u4f1a\u6709\u95ee\u9898.\u8fd9\u662f\u95ee\u9898 1.<\/p>\n

    \u95ee\u9898 2, \u5982\u679c\u6709 table \u7ed3\u6784 rename, delete, \u6309\u4f60\u5206\u4eab\u7684, database changes \u8ddf deployment \u5206\u79bb\u5bf9\u4e8e\u6211\u4eec\u5c31\u4e0d\u4e00\u5b9a\u9002\u5408. \u56e0\u4e3a\u5148\u884c\u624b\u5de5\u6267\u884c\u4e86 db changes, \u8fd9\u4e2a\u65f6\u5019, \u8fd8\u5728\u8fd0\u884c\u7684 apps \u5c31\u4f1a\u51fa\u95ee\u9898, rolling deployment \u5c31\u88ab\u6253\u7834\u4e86. \u5c31\u6709\u4e86 outage..<\/p>\n

    \u5bf9\u4e8e\u95ee\u9898 2, \u4e0d\u4e00\u5b9a\u975e\u8981\u5728 app \u542f\u52a8\u65f6\u505a database change, \u4efb\u4f55\u65f6\u5019\u90fd\u53ef\u4ee5. \u4f46\u662f\u8981\u6c42\u5f53\u524d\u8fd0\u884c\u5728\u540c\u4e00 database \u7684\u6240\u6709 apps \u5230\u65b0\u7684\u7248\u672c deployment \u7ed3\u675f\u5e76\u5207\u6362\u4e4b\u524d\u7ee7\u7eed\u6b63\u5e38\u8fd0\u884c, \u56e0\u4e3a\u65b0\u7248\u672c\u4e0d\u8bba\u662f deployment \u8fd8\u662f starting up \u4e00\u65e6\u6709\u95ee\u9898, \u4e0d\u80fd\u5f71\u54cd\u5f53\u524d\u4ea7\u54c1\u63d0\u4f9b\u670d\u52a1. \u5927\u6982\u8fd9\u4e2a\u95ee\u9898\u7684\u56f0\u96be\u4e5f\u662f\u5728\u8fd9\u91cc. <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd \u8865\u5145\u4e00\u4e0b, \u5f53\u524d\u6211\u4eec\u91c7\u53d6\u7684\u63aa\u65bd\u524d\u9762\u5df2\u7ecf\u8bf4\u4e86, \u53ef\u4ee5\u52c9\u5f3a\u5e94\u4ed8, \u4f46\u662f\u4eba\u4e3a\u624b\u5de5\u5e72\u9884\u56e0\u7d20\u6bd4\u8f83\u591a, \u800c\u4e14\u9700\u8981\u7279\u5b9a\u4eba\u76f4\u63a5\u5728\u6570\u636e\u5e93\u4e0a\u8fdb\u884c\u64cd\u4f5c. \u8fd9\u4e9b\u4e25\u683c\u8bb2\u4e0d\u7b26\u5408\u5b89\u5168\u89c4\u8303, \u56e0\u4e3a\u5f00\u53d1\u56e2\u961f\u4e0d\u80fd\u76f4\u63a5\u64cd\u7eb5 production stage \u7684\u6570\u636e. \u53e6\u5916\u4e00\u4e2a\u4eba\u5de5\u5e72\u9884\u4e5f\u4f1a\u6709\u51fa\u9519\u7684\u6f5c\u5728\u53ef\u80fd, \u4ee5\u53ca\u5177\u4f53\u4eba\u5458\u7684\u4f9d\u8d56\u6027.
    \u6240\u4ee5\u6211\u8bf4\u73b0\u5728\u7684\u505a\u6cd5\u867d\u7136\u80fd\u5c06\u5c31, \u4f46\u6211\u611f\u89c9\u4e0d\u662f solution. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : UnknownR <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4eec\u8fd9\u662f\u590d\u5236\u4e86\u5b8c\u6574\u7684\u6d4b\u8bd5\u73af\u5883\uff0c\u5148\u5728 test \u8dd1\uff0c\u6ca1\u95ee\u9898\u4e86\u4e0a prod\uff0c\u518d\u6709\u95ee\u9898\u5c31 rollback\uff0c\u786e\u4fdd\u6ca1\u6709\u660e\u9762\u4e0a\u7684\u95ee\u9898\u3002\u9690\u85cf\u95ee\u9898\u9760\u7838\u94b1\uff0cdatabase 1 \u4e3b 3 \u5907\u52a0 3 \u4e2a\u6570\u636e\u4e2d\u5fc3\uff0c\u6709\u95ee\u9898\u4e86\u5c31\u5207\u3002\u5f00\u53d1\u548c\u90e8\u7f72\u6743\u9650\u5206\u79bb\uff0c\u52a0 2 \u4e2a\u56e2\u961f\uff0c\u5f00\u53d1\u672c\u5730\u6d4b\u5b8c\u518d\u63a8\u7ed9\u90e8\u7f72\uff0c\u90e8\u7f72\u7684\u518d\u4e0a test\uff0c\u90fd\u6ca1\u95ee\u9898\u4e86\u518d\u4e0a prod \u7684\u4e3b dc\uff0c\u8dd1\u4e0b\u6765\u6ca1\u95ee\u9898\u5c31\u6700\u540e\u90e8\u7f72\u5907\u4efd\u7684 dc\uff0c\u5982\u679c\u4e3b dc \u51fa\u95ee\u9898\u4e86\uff0c\u5907\u4efd dc \u8fd8\u6ca1\u505a change\uff0c\u5207\u8fc7\u53bb\u8fd8\u80fd\u7ee7\u7eed\u8dd1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @KentY \u6211\u770b\u4e86\u4e00\u4e0b\u597d\u50cf\u6211\u8bf4\u7684\u65b9\u6cd5\u4f60\u4e5f\u60f3\u5230\u4e86\u7684\u3002\u6240\u4ee5\u95ee\u9898\u53ef\u80fd\u662f\u4f60\u60f3\u8ba9\u8fd9\u4e2a\u8fc7\u7a0b\u53d8\u6210\u81ea\u52a8\u7684\uff0c\u4e0d\u9700\u8981\u4eba\u5de5\u53c2\u4e0e\uff1f<\/p>\n

    \u6211\u4eec\u7684\u4f7f\u7528\u573a\u666f\u91cc\u9762\uff0c\u6709\u6d4b\u8bd5\u8fd0\u7ef4\u5f00\u53d1\uff0c\u5f00\u53d1\u53ea\u5bf9\u5f00\u53d1\u73af\u5883\u6709\u64cd\u4f5c\u6743\u9650\uff08 db\uff0c\u670d\u52a1\u5668\uff09\uff0c\u6d4b\u8bd5\u53ea\u5bf9\u6d4b\u8bd5\u73af\u5883\u6709\u64cd\u4f5c\u6743\u9650\uff0c\u8fd0\u7ef4\u5bf9\u7ebf\u4e0a\u6709\u6743\u9650\u3002\u5f00\u53d1\u60f3\u8981\u53d1\u5e03\uff0c\u5148\u7ecf\u8fc7\u6d4b\u8bd5\u6d4b\u8bd5\uff0c\u6d4b\u8bd5\u5b8c\u6bd5\u4e4b\u540e\u4f1a\u63d0\u4ea4\u7ed9\u8fd0\u7ef4\u53d1\u5e03\u3002\u4e0d\u77e5\u9053\u4f60\u4eec\u662f\u4e0d\u662f\u4e5f\u6709\u8fd9\u51e0\u4e2a\u89d2\u8272\uff1f\u6211\u89c9\u5f97\u5206\u89d2\u8272\u662f\u5b89\u5168\u7684\u3002<\/p>\n

    \u8fd9\u6837\u53d1\u5e03\u7684\u65f6\u5019\uff0c\u4e0d\u7ba1\u662f\u4ee3\u7801\u53d1\u5e03\uff0c\u8fd8\u662f\u6570\u636e\u5e93\u53d8\u66f4\uff0c\u90fd\u662f\u6709\u4e13\u4e1a\u4eba\u5458\u505a\u7684\u3002\u4ed6\u4eec\u4f1a\u518d\u6b21 review \u53d1\u5e03\u8fc7\u7a0b\u3002\u8fd9\u6837\u5c31\u662f\u6309\u7167\u6211\u8bf4\u7684\u6d41\u7a0b\uff0c\u5148\u53d1\u5e03\u6570\u636e\u5e93\u53d8\u66f4\uff08\u4f1a\u4fdd\u8bc1\u6570\u636e\u5e93\u53d8\u66f4\u4e0d\u4f1a\u5f71\u54cd\u73b0\u6709\u7a0b\u5e8f\uff09\uff0c\u7136\u540e\u53d1\u5e03\u7a0b\u5e8f\u4ee3\u7801\u3002\u8fd9\u6837\u6ca1\u6709\u505c\u673a\u65f6\u95f4\u3002\u4f46\u662f\u8fd9\u6837\u786e\u5b9e\u662f\u4f1a\u5bfc\u81f4\u4e0d\u80fd\u517c\u5bb9\u73b0\u6709\u6b63\u5728\u8fd0\u884c\u7684\u7a0b\u5e8f\u7684\u4e8b\u60c5\u4e0d\u80fd\u505a\uff0c\u6bd4\u5982\u5220\u9664\u5b57\u6bb5\u3002<\/p>\n

    \u53e6\u5916\u8fd9\u91cc\u9762\u4e5f\u53ea\u662f\u591a\u4e2a\u89d2\u8272\u7684\u4eba\u53c2\u4e0e\u8fdb\u6765 review \u4ee3\u7801\uff0c\u53d1\u5e03\u8fc7\u7a0b\u53ef\u4ee5\u901a\u8fc7\u70b9\u4e00\u4e2a\u6309\u94ae\u4ec0\u4e48\u7684\u81ea\u52a8\u6267\u884c\uff0c\u4e0d\u77e5\u9053\u662f\u5426\u4e0d\u7b26\u5408\u4f60\u8bf4\u7684\u4eba\u5de5\u53c2\u4e0e\u592a\u591a\u3002\u5ba1\u8ba1\u7684\u7406\u5ff5\u5e94\u8be5\u662f\u591a\u89d2\u8272\u53c2\u4e0e\u4e92\u76f8\u5ba1\u6838\u4f1a\u662f\u4e00\u4e2a\u6bd4\u8f83\u5b89\u5168\u7684\u64cd\u4f5c\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : KentY <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @UnknownR \u6211\u4eec\u4e5f\u6709\u4e0d\u540c stages, \u6709 fallback database, \u4f46\u662f\u8fd9\u4e2a\u4e0d\u53c2\u4e0e\u5e73\u65f6\u6b63\u5e38\u7684\u8fd0\u884c, \u53ea\u6709\u6b63\u5e38\u7684\u51fa\u95ee\u9898\u4e86, \u624d\u4f1a\u5207\u8fc7\u53bb, \u800c\u4e14\u6570\u636e\u4e0d\u662f\u5b9e\u65f6\u540c\u6b65\u7684.
    \u4e00\u822c\u80fd\u5230 production deployment \u7684\u9636\u6bb5\u90fd\u662f\u7ecf\u8fc7\u4e86\u6d4b\u8bd5\u7684, \u6211\u4eec\u6709 dev, test and prod three stages.
    @wd
    \u6211\u4eec\u6ca1\u6709\u4e13\u95e8\u7684\u90e8\u95e8 \/\u56e2\u961f\u8d1f\u8d23 release. \u6b63\u5982\u6211\u524d\u9762\u6240\u8bb2, \u6211\u4eec\u6709 100 \u591a\u4e2a apps, \u4f46\u662f\u9879\u76ee\u4f1a\u6309\u7167\u4e1a\u52a1\u7684\u4e0d\u540c, \u5206\u4e3a\u591a\u4e2a squads, \u6bd4\u5982\u54b1\u4eec\u7684 squad \u8d1f\u8d23\u67d0\u9879\u4e1a\u52a1, \u63d0\u4f9b\u4e86 1-10, 10 \u4e2a apps. \u90a3\u4e48\u54b1\u4eec\u8fd9\u4e2a\u5c0f\u56e2\u961f\u5c31\u8981\u8d1f\u8d23\u5f00\u53d1, \u6d4b\u8bd5,\u4ee5\u53ca\u54b1\u4eec\u81ea\u5df1 apps \u7684 release. \u81f3\u4e8e release \u7684\u5468\u671f\u4e5f\u662f\u54b1\u4eec\u81ea\u5df1\u51b3\u5b9a. \u6211\u4eec\u4e0d\u53ef\u80fd\u6709\u4e00\u4e2a\u4e13\u95e8\u7684\u56e2\u961f\u8d1f\u8d23\u6240\u6709 release. \u5927\u90e8\u5206 squads \u91c7\u7528 scrum, kanban or “scrumban”\u6765\u5f00\u53d1, release \u53ef\u80fd\u968f\u65f6\u8981\u6c42, \u4e5f\u53ef\u80fd\u96c6\u4e2d\u8981\u6c42, \u5404\u4e2a apps \u7684 release \u9700\u6c42\u8fd8\u4e0d\u540c, \u8ba9\u4e00\u4e2a\u4e13\u95e8\u56e2\u961f\u8d1f\u8d23 release \u6709\u70b9\u56f0\u96be. \u6211\u4eec\u53ea\u6709\u4e00\u4e9b\u91cd\u8981\u7684 apps \u5728 prod stage \u8fd0\u884c\u671f\u95f4, \u7531\u53e6\u4e00\u4e2a\u516c\u53f8\u8d1f\u8d23\u76d1\u63a7, \u4f46\u76f8\u5173\u7684 squad \u662f\u53ef\u4ee5\u76f4\u63a5 prod release \u7684. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ps1aniuge <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4f1a\u6709 alert, \u8fd9\u4e9b\u7ba1\u7406\u4e0d\u7531\u5f00\u53d1\u56e2\u961f\u8d1f\u8d23, \u751a\u81f3\u662f\u53e6\u4e00\u4e2a\u516c\u53f8\u6765\u76d1\u63a7, \u6bcf\u6b21\u8fd9\u79cd\u90fd\u662f\u8981\u4ed8\u8d39. ———-\u8bf7\u5141\u8bb8\u6211\u63d2\u64ad\u5e7f\u544a\uff0c\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002
    \u300a\u5361\u6b7b\u4f60 3000 \u300b\uff0c\u5f00\u6e90\u514d\u8d39\u7684\u6279\u91cf\u8fd0\u7ef4\u5de5\u5177\u3002https:\/\/gitee.com\/chuanjiao10\/kasini3000
    \u6b22\u8fce\u4e86\u89e3\u4e0b\u3002
    \u8fd9\u4e2a\u8f6f\u4ef6\u8fd1\u671f\uff08 10 \u5929\u5185\uff09\u5c06\u66f4\u65b0\uff0c\u65b0\u589e\u4efb\u52a1\u8ba1\u5212\u529f\u80fd\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u5173\u4e8e\u5e94\u7528\u7a0b\u5e8f\u7684 Deploymen…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/96848"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=96848"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/96848\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=96848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=96848"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=96848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}