{"id":8134,"date":"2017-05-23T15:08:02","date_gmt":"2017-05-23T07:08:02","guid":{"rendered":"http:\/\/jpuyy.com\/?p=8134"},"modified":"2019-09-09T11:56:49","modified_gmt":"2019-09-09T03:56:49","slug":"cassandra-%e6%93%8d%e4%bd%9c%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=8134","title":{"rendered":"cassandra \u64cd\u4f5c\u8bb0\u5f55"},"content":{"rendered":"<p>\u67e5\u770b\u72b6\u6001<\/p>\n<pre>bin\/nodetool status<\/pre>\n<p>\u67e5\u770b\u6240\u6709\u7684 keyspaces<\/p>\n<pre>DESCRIBE KEYSPACES\n<\/pre>\n<p>\u67e5\u770b\u7f51\u7edc\u72b6\u6001<\/p>\n<pre>bin\/nodetool netstats<\/pre>\n<p>\u67e5\u770b gossipinfo<\/p>\n<pre>bin\/nodetool gossipinfo<\/pre>\n<p>\u4fee\u6539 replication factor \u4e4b\u540e\u8fdb\u884c repair<\/p>\n<pre>bin\/nodetool repair<\/pre>\n<p>\u8e22\u9664\u4e00\u4e2a\u6d3b\u7684\u8282\u70b9<\/p>\n<pre>bin\/nodetool decommision<\/pre>\n<p>\u5bfc\u51fa\u4e00\u4e2a keyspace \u7684\u7ed3\u6784<\/p>\n<pre>cqlsh -e \"DESC KEYSPACE test\" &gt; db_schema_test.cql;<\/pre>\n<p>\u5bfc\u51fa\u6240\u6709 keyspace \u7684\u7ed3\u6784<\/p>\n<pre>cqlsh -e \"DESC SCHEMA\" &gt; db_schema.cql<\/pre>\n<p>\u5bfc\u51fa\u8868\u81f3 csv \u6587\u4ef6<\/p>\n<pre>COPY table_name ( column , ... )\nTO  'file_name' | STDOUT \nWITH option = 'value' AND ...<\/pre>\n<p>\u5f53\u9700\u8981\u7ef4\u62a4\u4e00\u4e2a\u7ed3\u70b9\u65f6<\/p>\n<p>cd \/opt\/platform\/cassandra\/<br \/>\nbin\/nodetool drain<br \/>\n# stop<br \/>\npgrep -u ops -f cassandra | xargs kill -9<\/p>\n<p># start<br \/>\nnohup .\/bin\/cassandra &amp;<\/p>\n<p>\u53d8\u66f4\u540e Check<br \/>\n\/opt\/platform\/cassandra\/bin\/nodetool status<br \/>\n\u5173\u6ce8<\/p>\n<p>Status &#8211; U (up) or D (down)<br \/>\nIndicates whether the node is functioning or not.<\/p>\n<p>State &#8211; N (normal), L (leaving), J (joining), M (moving)<br \/>\nThe state of the node in relation to the cluster.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u72b6\u6001 bin\/nodetool status \u67e5\u770b\u6240\u6709\u7684 keyspaces DESCRIBE KEYSPACES \u67e5\u770b\u7f51\u7edc\u72b6\u6001 bin\/nodetool netstats \u67e5\u770b gossipinfo bin\/nodetool gossipinfo \u4fee\u6539 replication factor \u4e4b\u540e\u8fdb\u884c repair bin\/nodetool repair \u8e22\u9664\u4e00\u4e2a\u6d3b\u7684\u8282\u70b9 bin\/nodetool decommision \u5bfc\u51fa\u4e00\u4e2a keyspace \u7684\u7ed3\u6784 cqlsh -e &#8220;DESC KEYSPACE test&#8221; &gt; db_schema_test.cql; \u5bfc\u51fa\u6240\u6709 keyspace \u7684\u7ed3\u6784 cqlsh -e &#8220;DESC SCHEMA&#8221; &gt; db_schema.cql \u5bfc\u51fa\u8868\u81f3 csv \u6587\u4ef6 COPY table_name ( column , &#8230; ) TO &#8216;file_name&#8217; [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-8134","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8134"}],"version-history":[{"count":6,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8134\/revisions"}],"predecessor-version":[{"id":8585,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8134\/revisions\/8585"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}