{"id":17797,"date":"2025-12-16T15:10:44","date_gmt":"2025-12-16T07:10:44","guid":{"rendered":"https:\/\/kbwp.transwarp.cn\/?p=17797"},"modified":"2025-12-16T15:10:44","modified_gmt":"2025-12-16T07:10:44","slug":"txsql-%e4%bf%ae%e6%94%b9%e5%a4%8d%e5%88%b6%e7%94%a8%e6%88%b7-replica-%e7%9a%84%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=17797","title":{"rendered":"txsql \u4fee\u6539\u590d\u5236\u7528\u6237 replica \u7684\u5bc6\u7801"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<p>mysql \u5f31\u5bc6\u7801\u53e3\u4ee4\u4fee\u590d\u65f6\uff0c\u53ef\u80fd\u9700\u8981\u4fee\u6539txsql \u4e2d\u590d\u5236\u7528\u6237 replica \u7684\u5bc6\u7801\u3002<br \/>\n\u590d\u5236\u7528\u6237 replica \u7684\u5bc6\u7801\u4e0d\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528 update  mysql.user \u7684\u65b9\u5f0f\uff0c\u9700\u8981\u6309\u7167\u5982\u4e0b\u8981\u6c42\u64cd\u4f5c\u3002<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<ol>\n<li>\u8fdb\u5165 pods\uff0c\u83b7\u53d6 host \u548c port \u4fe1\u606f<\/li>\n<li>\u6267\u884c\u547d\u4ee4\u4fee\u6539\u5bc6\u7801<\/li>\n<\/ol>\n<h4>\u8fdb\u5165 pod \u83b7\u53d6 host \u548c port \u4fe1\u606f<\/h4>\n<pre><code class=\"language-shell\">kubectl get pods -owide|grep txsql<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/kbwp.transwarp.cn\/wp-content\/uploads\/2025\/12\/image-1765868557199.png\" alt=\"file\" \/><\/p>\n<pre><code class=\"language-shell\">kubectl exec -ti txsql-server-txsql1-391918047-4xl5x bash\nbash -x \/usr\/bin\/txsql\/tools\/txsql.sh list<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/kbwp.transwarp.cn\/wp-content\/uploads\/2025\/12\/image-1765868659562.png\" alt=\"file\" \/><\/p>\n<p>\u5982\u4e0a\u56fe\uff0c\u53ef\u4ee5\u770b\u5230 -h \u548c -p \u7684\u4fe1\u606f\uff0c\u8bb0\u5f55\u4e0b\u6765\u3002<\/p>\n<p>\u7136\u540e cat \u83b7\u5f97 root \u7528\u6237\u548c root \u5bc6\u7801\u3002<\/p>\n<pre><code class=\"language-shell\">cat \/etc\/txsql1\/conf\/db.properties<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/kbwp.transwarp.cn\/wp-content\/uploads\/2025\/12\/image-1765868777957.png\" alt=\"file\" \/><\/p>\n<h4>\u6267\u884c\u547d\u4ee4\u4fee\u6539\u5bc6\u7801<\/h4>\n<pre><code class=\"language-shell\">\/usr\/bin\/txsql\/sbin\/phxbinlogsvr_tools_phxrpc -f SetMySqlReplicaInfo -h <host> -p <port> -u <admin username> -d <admin pwd> -U <new replica username> -D <new replica pwd><\/code><\/pre>\n<p>-h \u548c -p \u662f\u4e0a\u4e00\u6b65\u6267\u884c <code>bash -x \/usr\/bin\/txsql\/tools\/txsql.sh list<\/code> \u770b\u5230\u7684\u4fe1\u606f<br \/>\n-u \u548c -d \u662f\u6267\u884c <code>cat \/etc\/txsql1\/conf\/db.properties<\/code> \u770b\u5230\u7684\u4fe1\u606f<br \/>\n-U \u662f replica<br \/>\n-D \u662f\u4fee\u6539\u540e\u7684 replica \u7684\u5bc6\u7801\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kbwp.transwarp.cn\/wp-content\/uploads\/2025\/12\/image-1765868984215.png\" alt=\"file\" \/><\/p>\n<p>\u4f7f\u7528\u65b0\u5bc6\u7801\uff0c\u94fe\u63a5\u4e09\u4e2atxsql \u8282\u70b9\u7684ip\uff0c\u8fdb\u884c\u767b\u5f55\u9a8c\u8bc1\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kbwp.transwarp.cn\/wp-content\/uploads\/2025\/12\/image-1765869085197.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 mysql \u5f31\u5bc6\u7801\u53e3\u4ee4\u4fee\u590d\u65f6\uff0c\u53ef\u80fd\u9700\u8981\u4fee\u6539txsql \u4e2d\u590d\u5236\u7528\u6237 replica \u7684\u5bc6\u7801\u3002 \u590d\u5236\u7528\u6237 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=17797\" 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-17797","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\/17797","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=17797"}],"version-history":[{"count":1,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/17797\/revisions"}],"predecessor-version":[{"id":17807,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/17797\/revisions\/17807"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}