{"id":13974,"date":"2025-09-17T17:17:48","date_gmt":"2025-09-17T09:17:48","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=13974"},"modified":"2025-09-17T17:17:48","modified_gmt":"2025-09-17T09:17:48","slug":"kundb-%e7%81%be%e9%9a%be%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=13974","title":{"rendered":"KunDB \u707e\u96be\u5907\u4efd"},"content":{"rendered":"<h2>\u9002\u7528\u573a\u666f<\/h2>\n<p>\u672c\u6587\u9002\u7528\u4e8e\u5728\u6781\u7aef\u73af\u5883\u4e0b\uff0cKunDB \u65e0\u6cd5\u542f\u52a8\uff0c\u4e14\u591a\u79cd\u65b9\u6848\u5747\u65e0\u6cd5\u6062\u590d\u7684\u573a\u666f\uff0c\u5305\u62ec raft \u91cd\u7ec4\uff0crelay-log \u6e05\u7406\u7b49<\/p>\n<p>Raft KunDB-CE\u5747\u9002\u7528\uff08 \u7248\u672c &gt;= KunDB 2.1.4 \uff09\uff0c\u5176\u4ed6\u7248\u672c\u5f85\u9a8c\u8bc1<\/p>\n<p>\u81f3\u5c11\u9700\u8981\u6ee1\u8db3\u5982\u56fe\u7684\u60c5\u51b5\uff0cpod \u5185\u6267\u884c <\/p>\n<p><code>ps -ef | cat | grep socket <\/code><\/p>\n<p>\u5e95\u5c42 mysqld \u670d\u52a1\u53ef\u4ee5\u6b63\u5e38\u542f\u52a8<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/08\/image-1724036941860.png\" alt=\"file\" \/><\/p>\n<h2>\u64cd\u4f5c\u6b65\u9aa4<\/h2>\n<ol>\n<li>\u786e\u8ba4\u6545\u969c\u7684 KunDB\uff0c\u4e00\u822c\u8868\u73b0\u4e3a 0\/1 Running<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/08\/image-1724037310540.png\" alt=\"file\" \/><\/p>\n<ol start=\"2\">\n<li>\n<p><strong>\u6bcf\u4e2aKunDB\u7684pod\uff0c\u90fd\u9700\u8981\u91cd\u590d\u4ee5\u4e0b\u6b65\u9aa4\uff1a<\/strong><\/p>\n<ul>\n<li>\u8fdb\u5165 pod \u5185\u90e8\uff0c\u6839\u636e socket \u8fde\u63a5\u5e95\u5c42<\/li>\n<\/ul>\n<p><code>mysql --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock<\/code><\/p>\n<ul>\n<li>\u5982\u679c\u662f 2.1.6 \u53ca\u4ee5\u4e0a\u7684\u7248\u672c\uff0c\u8fd8\u9700\u8981\u52a0\u4e0a socket \u5bc6\u7801<\/li>\n<\/ul>\n<p><code>-p&#039;TEwD8*9#Qm!Pd&amp;AG&#039;<\/code><\/p>\n<ul>\n<li>\u67e5\u8be2\u5f53\u524d\u8282\u70b9\u6d41\u6c34<\/li>\n<\/ul>\n<p><code>show master status \\G;<\/code><\/p>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/08\/image-1724037822268.png\" alt=\"file\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2024\/08\/image-1724038824856.png\" alt=\"file\" \/><\/p>\n<ol start=\"3\">\n<li>\u9009\u62e9<strong>\u6d41\u6c34\u6700\u5927<\/strong>\u7684\u8282\u70b9\uff0c\u5e76\u5907\u4efd\u6570\u636e<\/li>\n<\/ol>\n<p><code>nohup mysql -N -e &quot;show databases;&quot; --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock 2&gt;\/dev\/null| grep -Evx &quot;information_schema|mysql|_vt|performance_schema|sys&quot;|xargs mysqldump --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock --single-transaction --source-data=2 --set-gtid-purged=off --skip-add-drop-table --hex-blob --triggers --routines --databases &gt; alldata.sql &amp;<\/code><\/p>\n<ol start=\"4\">\n<li>\u5907\u4efd\u6743\u9650\u548c\u7528\u6237\uff08Manager-KunDB \u53ef\u4ee5\u5ffd\u7565\u6b64\u6b65\uff09<\/li>\n<\/ol>\n<p><code>mysql -N -e &quot;select distinct user from mysql.user&quot; --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock -p&#039;TEwD8*9#Qm!Pd&amp;AG&#039;| grep -Evx &quot;clone_user|vt_app|orc_client_user|root|vt_repl|mysql.infoschema|mysql.session|mysql.sys|vt_allprivs|vt_appdebug|vt_dba|vt_filtered|kundb_dba|vt_meta_user|kun_monitor&quot;|xargs -I {} mysql -N --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock -p&#039;TEwD8*9#Qm!Pd&amp;AG&#039; -e &#039;show create user {}&#039; |awk &#039;{print $0&quot;;&quot;}&#039;  &gt; createuser.sql<\/code><\/p>\n<p><code>mysql -N -e &quot;select distinct user from mysql.user&quot; --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock -p&#039;TEwD8*9#Qm!Pd&amp;AG&#039;| grep -Evx &quot;clone_user|vt_app|orc_client_user|root|vt_repl|mysql.infoschema|mysql.session|mysql.sys|vt_allprivs|vt_appdebug|vt_dba|vt_filtered|kundb_dba|vt_meta_user|kun_monitor&quot;|xargs -I {} mysql -N --socket=\/vdir\/mnt\/disk1\/kundb1\/kundbdata\/mysql.sock -p&#039;TEwD8*9#Qm!Pd&amp;AG&#039; -e &#039;show grants for {}&#039; |awk &#039;{print $0&quot;;&quot;}&#039; &gt; grants.sql<\/code><\/p>\n<ol start=\"5\">\n<li>\n<p>\u5c06\u5907\u4efd\u7684sql\u6587\u4ef6\u79fb\u52a8\u5230\u6301\u4e45\u5316\u76ee\u5f55<\/p>\n<\/li>\n<li>\n<p>\u5728\u65b0\u88c5\u7684 KunDB \u4e2d source \u5907\u4efd\u7684 sql \u6587\u4ef6\u5373\u53ef\u6062\u590d\u6570\u636e<\/p>\n<\/li>\n<\/ol>\n<h2>\u5b8c\u6574\u6027\u68c0\u67e5<\/h2>\n<p>\u4f7f\u7528 tail \u547d\u4ee4\u68c0\u67e5\u5907\u4efd\u7684 alldata.sql \u6587\u4ef6\uff0c\u6b63\u786e\u5907\u4efd\u7684\u6587\u4ef6\u4f1a\u5728\u672b\u5c3e\u8f93\u51fa<\/p>\n<p><code>\u201cDump completed on XXXXXXX\u201d<\/code><\/p>\n<p>\u5982\u679c\u6ca1\u6709\u76f8\u5173\u5185\u5bb9\uff0c\u5219\u4ee3\u8868\u5907\u4efd\u8fdb\u7a0b\u4ecd\u5728\u8fdb\u884c\u4e2d\uff0c\u6216\u8005\u56e0\u67d0\u4e9b\u6545\u969c\u800c\u4e2d\u65ad\uff0c\u4f8b\u5982\u5bc6\u7801\u9519\u8bef\u3001socket \u6307\u5b9a\u8def\u5f84\u9519\u8bef\u7b49\uff0c\u8bf7\u68c0\u67e5\u76f8\u5173\u547d\u4ee4<\/p>\n<p>\u540c\u6837\u4f7f\u7528 tail \u547d\u4ee4\u68c0\u67e5\u5907\u4efd\u7684 createuser.sql \u4e0e grants.sql \u6587\u4ef6\uff0c\u91cc\u9762\u6709\u5b8c\u6574\u7684 sql \u8bed\u53e5\u5373\u53ef<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9002\u7528\u573a\u666f \u672c\u6587\u9002\u7528\u4e8e\u5728\u6781\u7aef\u73af\u5883\u4e0b\uff0cKunDB \u65e0\u6cd5\u542f\u52a8\uff0c\u4e14\u591a\u79cd\u65b9\u6848\u5747\u65e0\u6cd5\u6062\u590d\u7684\u573a\u666f\uff0c\u5305\u62ec raft \u91cd\u7ec4\uff0cre ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=13974\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":199,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-13974","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\/13974","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\/199"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13974"}],"version-history":[{"count":2,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/13974\/revisions"}],"predecessor-version":[{"id":13981,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/13974\/revisions\/13981"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}