{"id":12427,"date":"2024-04-08T09:34:02","date_gmt":"2024-04-08T01:34:02","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=12427"},"modified":"2025-11-13T14:38:30","modified_gmt":"2025-11-13T06:38:30","slug":"kundb-%e6%9b%bf%e6%8d%a2-metastore-txsql","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=12427","title":{"rendered":"kundb \u66ff\u6362 metastore-txsql"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<p>Manager 9.3.0\uff0cTDH 6.2.2 \u4f9d\u8d56\u7684\u662f txsql \uff0c\u73b0\u5728\u9700\u8981\u5c06\u5143\u6570\u636e\u653e\u5230 kundb \u4e2d\uff0c\u672c\u6587\u8bb0\u5f55\u4e00\u4e0b\u64cd\u4f5c\u65b9\u6cd5\u3002<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<ol>\n<li>\u51c6\u5907\u6587\u4ef6<\/li>\n<li>\u5b89\u88c5 kundb<\/li>\n<li>\u8fc1\u79fb txsql \u6570\u636e\u5230 kundb<\/li>\n<li>\u5347\u7ea7 inceptor \u81f3 inceptor-kunmeta<\/li>\n<li>\u4fee\u6539\u4f9d\u8d56\u81f3 kundb<\/li>\n<\/ol>\n<p>\u4ece inceptor \u5347\u7ea7\u81f3 inceptor-kunmeta \u65f6\uff0c\u811a\u672c\u81ea\u52a8\u5b8c\u6210\u4e86\u5f88\u591a\u64cd\u4f5c<\/p>\n<h4>\u51c6\u5907\u6587\u4ef6<\/h4>\n<p>1\u3001MetaInfo\u548c\u811a\u672c\u5de5\u5177\u83b7\u53d6<\/p>\n<p>inceptor-kunmeta \u7684 metainfo \u6587\u4ef6\u66ff\u6362<\/p>\n<p><a href=\"https:\/\/fs.transwarp.cn\/?download&weblink=c9e6f00062eba1fe502990a4306f9d30&realfilename=tools-master.zip\" title=\"metainfo-inceptor-kunmeta\">metainfo-inceptor-kunmeta<\/a><\/p>\n<pre><code class=\"language-shell\"># \u65b0\u589e\u52a0\u4e00\u4e2ainceptor-6.2.2-kunmeta \u7684 metainfo\n[root@test-app-10~\/tools-master\/metainfo\/INCEPTOR]# cp -r transwarp-6.2.2-kunmeta \/var\/lib\/transwarp-manager\/master\/content\/meta\/services\/INCEPTOR\/\n\n# \u91cd\u542f manager \u751f\u6548\n[root@test-app-10~\/tools-master\/metainfo\/INCEPTOR]# systemctl  restart transwarp-manager\n<\/code><\/pre>\n<h4>\u5b89\u88c5 kundb\uff08\u8df3\u8fc7\uff09<\/h4>\n<h4>\u6570\u636e\u8fc1\u79fb\u81f3 kundb<\/h4>\n<p>\u6267\u884c\u811a\u672c\u4e4b\u524d\uff0c\u9700\u8981\u5148\u4fee\u6539\u57fa\u7840\u914d\u7f6e\u6587\u4ef6 metalist \u548c metaconfig\uff1b<br \/>\n\u5176\u4e2d metalist \u662f\u9700\u8981\u8fc1\u79fb\u5143\u6570\u636e\u7684\u670d\u52a1 id\uff0c\u672c\u6848\u4f8b\u4e2d\u662f inceptor1.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1712019345201.png\" alt=\"file\" \/><\/p>\n<p>metaconfig \u662f\u6e90\u6570\u636e\u5e93\u7684\u914d\u7f6e\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1712019562362.png\" alt=\"file\" \/><\/p>\n<p>TXSQL\u7684\u5bc6\u7801\uff0c\u53ef\u8fdb\u5165txsql pod\u4e2d\u6267\u884c\u5982\u4e0b\u6307\u4ee4\u83b7\u53d6root\u7528\u6237\u5bc6\u7801<\/p>\n<pre><code class=\"language-shell\">echo $TXSQL_DB_PASSWORD<\/code><\/pre>\n<p>\u8fc1\u79fb\u8fc7\u7a0b\u4f9d\u6b21\u6267\u884c\u4ee5\u4e0b4\u4e2a\u811a\u672c\uff0c\u786e\u4fdd\u6bcf\u4e2a\u811a\u672c\u8f93\u51fa\u90fd\u662f\u6210\u529f\u7684\uff0c\u624d\u53ef\u4ee5\u7ee7\u7eed\u6267\u884c\u4e0b\u4e00\u4e2a\uff1a<\/p>\n<pre><code class=\"language-shell\">.\/TestMetaConfig.sh\n.\/DumpMetaDB.sh -s txsql\n.\/CreateInceptorUser.sh -t kundb\n.\/RecoverMetaDB.sh -s txsql -t kundb<\/code><\/pre>\n<pre><code class=\"language-shell\">[root@test-app-10~\/tools-master\/MigrateDB\/MigrateMetaDB]# .\/TestMetaConfig.sh\n*******************************************************************************\n****                    0.Test Connection based on config                   ***\n*******************************************************************************\n2024-04-02 08:40:35.947 Info: Test Connection txsql succeed\n2024-04-02 08:40:35.975 Info: Test Connection kundb succeed\n\n[root@test-app-10~\/tools-master\/MigrateDB\/MigrateMetaDB]# .\/DumpMetaDB.sh -s txsql\n*******************************************************************************\n****                    1.Dump DB data                                      ***\n*******************************************************************************\n2024-04-02 08:40:35.988 Info: Dump database metastore_inceptor1\n2024-04-02 08:40:36.028 Info: Dump database metastore_inceptor1 succeed\n\n[root@test-app-10~\/tools-master\/MigrateDB\/MigrateMetaDB]# .\/CreateInceptorUser.sh -t kundb\n*******************************************************************************\n****                    2.Create inceptoruser in target DB                  ***\n*******************************************************************************\n2024-04-02 08:40:36.040 Info: Create inceptor user\n2024-04-02 08:40:36.070 Info: Create inceptor user succeed\n\n[root@test-app-10~\/tools-master\/MigrateDB\/MigrateMetaDB]# .\/RecoverMetaDB.sh -s txsql -t kundb\n*******************************************************************************\n****                    3.Recover source DB to target DB                    ***\n*******************************************************************************\n2024-04-02 08:40:36.107 Info: Recover metastore_inceptor1.sql\n2024-04-02 08:40:36.110 Info: Recover metastore_inceptor1.sql succeed\n<\/code><\/pre>\n<h4>\u5347\u7ea7 inceptor \u81f3 inceptor-kunmeta<\/h4>\n<p>\u5e94\u7528\u5e02\u573a &#8211; \u5df2\u5b89\u88c5\u670d\u52a1 &#8211; \u96c6\u7fa4 &#8211; inceptor<\/p>\n<p>\u53ef\u4ee5\u770b\u5230\u6709\u4e00\u4e2a inceptor-kunmeta<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1711967122348.png\" alt=\"file\" \/><\/p>\n<p>\u7136\u540e\u70b9\u51fb\u5347\u7ea7\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1711967236682.png\" alt=\"file\" \/><\/p>\n<p>\u5feb\u901f\u5347\u7ea7 &#8211; \u4e0b\u4e00\u6b65<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1711967374438.png\" alt=\"file\" \/><\/p>\n<p>\u5347\u7ea7\u5b8c\u6210<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1711967751698.png\" alt=\"file\" \/><\/p>\n<h4>\u4fee\u6539\u4f9d\u8d56kundb<\/h4>\n<p>\u5347\u7ea7\u5b8c\u6210\u4e4b\u540e\uff0c\u4fee\u6539 inceptor \u4f9d\u8d56\uff0c\u5c06 txsql \u53d6\u6d88\uff0c\u5e76\u6dfb\u52a0 kundb \u4f9d\u8d56\uff0c\u7136\u540e\u914d\u7f6e\u670d\u52a1\uff0c\u91cd\u542finceptor \u5373\u53ef\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/04\/image-1711967843911.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 Manager 9.3.0\uff0cTDH 6.2.2 \u4f9d\u8d56\u7684\u662f txsql \uff0c\u73b0\u5728\u9700\u8981\u5c06\u5143\u6570\u636e\u653e\u5230 kun ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=12427\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-12427","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\/12427","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12427"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/12427\/revisions"}],"predecessor-version":[{"id":17678,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/12427\/revisions\/17678"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}