{"id":3603,"date":"2020-07-24T10:17:48","date_gmt":"2020-07-24T02:17:48","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=3603"},"modified":"2020-07-24T13:58:37","modified_gmt":"2020-07-24T05:58:37","slug":"txsql%e4%bf%ae%e6%94%b9data-dir","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=3603","title":{"rendered":"Txsql\u4fee\u6539data.dir"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u672c\u6587\u65e8\u5728\u6d4b\u8bd5\u66f4\u6362 txsql \u7684 data.dir \u9700\u8981\u7684\u4e00\u7cfb\u5217\u64cd\u4f5c<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<h4>1. txsql\u5143\u6570\u636e\u5907\u4efd<\/h4>\n<p>\u53c2\u8003\u6587\u6863\uff1a<a href=\"https:\/\/nj.transwarp.cn:8180\/?p=528\">https:\/\/nj.transwarp.cn:8180\/?p=528<\/a><\/p>\n<h4>2. \u540e\u53f0\u4fee\u6539\u8def\u5f84<\/h4>\n<ul>\n<li>\n<p>2.1 \u505c\u6b62txsql<br \/>\n<strong>\u4ee5\u4e0b\u64cd\u4f5c\u8fc7\u7a0b\u4e2d\u786e\u4fdd txsql \u670d\u52a1\u5fc5\u987b\u662f\u505c\u6b62\u72b6\u6001<\/strong><\/p>\n<\/li>\n<li>\n<p>2.2 \u540e\u53f0\u5148\u628a\u539f\u59cb data.dir\u8def\u5f84\u91cc\u7684\u6587\u4ef6\u90fd\u590d\u5236\u5230\u65b0\u8def\u5f84\u4e0b\uff0c\u65b0\u8def\u5f84\u662f \/mnt\/disk2\/jane\/\uff08txsql\u8282\u70b9\u90fd\u9700\u8981\u64cd\u4f5c\uff09<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595487257796.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p>2.3 \u4fee\u6539\u6240\u6709 txsql \u8282\u70b9\u4fee\u6539\u65b0\u8def\u5f84\u7684\u5c5e\u7ec4\uff1a<\/p>\n<pre><code class=\"language-shell\">chown -R 1000:1000 \/mnt\/disk2\/jane\/percona.workspace<\/code><\/pre>\n<\/li>\n<li>\n<p>2.4 \u4fee\u6539\uff08\u6240\u6709txsql\u8282\u70b9\uff09<strong><code>\/etc\/txsql1\/conf\/my.cnf \u548c \/etc\/txsql1\/conf\/phxbinlogsvr.conf<\/code><\/strong> \u8fd9\u4e24\u4e2a\u6587\u4ef6\uff0c\u628a\u91cc\u9762\u7684\u539f\u59cb\u8def\u5f84\u90fd\u6539\u6210\u65b0\u8def\u5f84\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595570145830.png\" alt=\"file\" \/><\/p>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595570260004.png\" alt=\"file\" \/><\/p>\n<ul>\n<li>\n<p>2.5 \u4fee\u6539\uff08\u6240\u6709txsql\u8282\u70b9\uff09\/mnt\/disk2\/jane\/percona.workspace\/binlog \u4e0b\u7684<strong><code>mysql-bin.index \u548c relay-log.index<\/code><\/strong> \u91cc\u9762\u7684\u539f\u59cb\u8def\u5f84\u4e5f\u90fd\u6539\u6210\u65b0\u8def\u5f84\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595487673278.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595487761735.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p>2.6 \u6b64\u65f6\u518d\u53bb8180\u9875\u9762\u4fee\u6539txsql\u7684data.dir\u8def\u5f84\uff08\u786e\u4fdd txsql\u662f\u505c\u6b62\u72b6\u6001\uff09\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595488578036.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p>2.7 \u6539\u5b8c\u8def\u5f84\u540e\uff0ctxsql \u70b9\u51fb\u914d\u7f6e\u670d\u52a1\uff0c\u542f\u52a8<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595488653651.png\" alt=\"file\" \/><\/p>\n<\/li>\n<\/ul>\n<p><strong>PS\uff1a\u5982\u679c\u4ee5\u4e0a\u64cd\u4f5c\u5b8c\u6210\u4e4b\u540e\uff0ctxsql \u670d\u52a1\u4e0d\u6b63\u5e38\uff0c\u4e14 \/var\/log\/txsql1\/my.err \u91cc\u770b\u5230\u5982\u4e0b\u62a5\u9519\uff1a<\/strong><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595487833383.png\" alt=\"file\" \/><br \/>\n\u5219\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u4fee\u590d\uff1a<\/p>\n<pre><code class=\"language-shell\">kubectl get pod -owide|grep txsql\nkubectl exec -it txsql-server-txsql1-784df89c7d-k2s9k bash\n.\/usr\/bin\/txsql\/tools\/txsql.sh shell\nmysql> stop slave IO_THREAD;\nQuery OK, 0 rows affected (0.01 sec)\n\nmysql> reset slave;\nQuery OK, 0 rows affected (0.10 sec)\n\nmysql> start slave;\nQuery OK, 0 rows affected (0.20 sec)<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595488208182.png\" alt=\"file\" \/><\/p>\n<h4>3. \u9a8c\u8bc1\u6570\u636e<\/h4>\n<p>\u5728txsql pod\u5185show databases\u770b\u4e0b\u4e4b\u524d\u7684\u5143\u6570\u636e\u662f\u5426\u90fd\u5bfc\u8fc7\u6765\u4e86<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/07\/image-1595488297374.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u672c\u6587\u65e8\u5728\u6d4b\u8bd5\u66f4\u6362 txsql \u7684 data.dir \u9700\u8981\u7684\u4e00\u7cfb\u5217\u64cd\u4f5c \u8be6\u7ec6\u8bf4\u660e 1. txsql\u5143\u6570 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=3603\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3603","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\/3603","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3603"}],"version-history":[{"count":2,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/3603\/revisions"}],"predecessor-version":[{"id":3645,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/3603\/revisions\/3645"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}