{"id":2864,"date":"2020-06-03T17:31:13","date_gmt":"2020-06-03T09:31:13","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=2864"},"modified":"2022-01-29T11:44:25","modified_gmt":"2022-01-29T03:44:25","slug":"workflow%e6%95%b0%e6%8d%ae%e5%ba%93%e7%ae%80%e4%bb%8b%e5%8f%8a%e7%99%bb%e5%bd%95","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=2864","title":{"rendered":"workflow\u6570\u636e\u5e93\u7b80\u4ecb\u53ca\u767b\u5f55"},"content":{"rendered":"

\u6982\u8981\u63cf\u8ff0<\/h3>\n
\n

\u672c\u6587\u65e8\u5728\u89e3\u91ca\u5982\u4f55\u8fde\u63a5workflow\u6570\u636e\u5e93<\/p>\n

\u8be6\u7ec6\u8bf4\u660e<\/h3>\n
\n

workflow\u7684\u5143\u6570\u636e\u5b58\u5728\u4e8etxsql\u4e2d\uff08\u6b64txsql\u662f\u7ec4\u4ef6txsql\uff09\u3002<\/p>\n

\u4e00\u3001\u8fde\u63a5txsql\u65b9\u5f0f<\/h4>\n

\u65b9\u5f0f\u4e00\uff1a\u76f4\u63a5\u8fde\u63a5<\/strong><\/p>\n

    \n
  1. \n

    \u7528\u6237\u540d\/\u5bc6\u7801 \u5b58\u653e\u4e8e \/etc\/txsql{No.}\/conf\/db.properties<\/code>\u4e2d\u3002
    \n\u4f8b\u5982\u672c\u4f8b\u4e2d\uff0c\u7528\u6237\u540d\uff1aroot<\/code>\uff0c\u5bc6\u780125207325<\/code>\u3002\u7aef\u53e3\u53f73316<\/code>
    \n\"file\"<\/p>\n<\/li>\n

  2. \n

    \u8fde\u63a5\uff1a<\/p>\n

    mysql -uroot -p25207325 -P3316 -h172.22.27.7<\/code><\/pre>\n
    \"file\"<\/p>\n<\/li>\n<\/ol>\n
    \u65b9\u5f0f\u4e8c\uff1a \u901a\u8fc7txsql pod \u8fdb\u5165<\/strong><\/p>\n
      \n
    1. \u83b7\u53d6txsql\u7684podname\n
      kubectl get po -owide|grep txsql1<\/code><\/pre>\n<\/li>\n
    2. \u8fdb\u5165\u4efb\u610ftxsql\u7684pod\n
      kubectl exec -it <\u4e0a\u4e00\u6b65\u83b7\u53d6\u7684podname> bash<\/code><\/pre>\n<\/li>\n
    3. \u8fdb\u5165\u6570\u636e\u5e93\n
      \/usr\/bin\/txsql\/tools\/txsql.sh shell<\/code><\/pre>\n
      \u4f8b\u5982\uff1a
      \n\"file\"<\/p>\n<\/li>\n<\/ol>\n
      \u4e8c\u3001\u8fdb\u5165workflow\u6570\u636e\u5e93<\/h4>\n
        \n
      1. \n
        show databases;<\/code> \/\/\u67e5\u770b\u5f53\u524d\u7684\u6570\u636e\u5e93
        \n\"file\"
        \n\u53ef\u4ee5\u770b\u5230\uff0c\u6b64\u5904\u6709workflow\u7684\u6570\u636e\u5e93\uff0c\u5e93\u540dworkflow_workflow1\u3002<\/p>\n<\/li>\n
      2. \n
        use workflow_workflow1;<\/code> \/\/\u6307\u5b9a\u5f53\u524d\u4f7f\u7528\u7684\u6570\u636e\u5e93\uff0c\u4f7f\u5f97\u6307\u5b9a\u6570\u636e\u5e93\u4e2d\u7684\u8868\u3001\u89c6\u56fe\u548c\u6d41\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528<\/p>\n<\/li>\n
      3. \n
        show tables; <\/code>\/\/\u67e5\u770bworkflow\u5171\u6709\u54ea\u4e9b\u8868
        \n\"file\"<\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
        \u6982\u8981\u63cf\u8ff0 \u672c\u6587\u65e8\u5728\u89e3\u91ca\u5982\u4f55\u8fde\u63a5workflow\u6570\u636e\u5e93 \u8be6\u7ec6\u8bf4\u660e workflow\u7684\u5143\u6570\u636e\u5b58\u5728\u4e8etxsql\u4e2d\uff08\u6b64 ..<\/p>\n
        <\/div>\n
        Read more<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2864","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2864"}],"version-history":[{"count":1,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2864\/revisions"}],"predecessor-version":[{"id":7665,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2864\/revisions\/7665"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}