{"id":19602,"date":"2017-06-18T06:58:47","date_gmt":"2017-06-17T22:58:47","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/18\/opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-centos\/"},"modified":"2021-03-18T17:25:04","modified_gmt":"2021-03-18T09:25:04","slug":"opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-centos","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/18\/opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-centos\/","title":{"rendered":"OpenNMS &#8211; Apache Cassandra \u5b89\u88dd\u8207 Newts \u8a2d\u5b9a &#8211; CentOS"},"content":{"rendered":"<p>\u53c3\u8003\u7db2\u9801\uff1a <br \/><a href=\"https:\/\/docs.opennms.org\/opennms\/releases\/latest\/guide-install\/guide-install.html\" target=\"_blank\" rel=\"noopener noreferrer\">OpenNMS Installation Guide<\/a> <\/p>\n<p>\u6839\u64da\u5b98\u65b9\u7db2\u7ad9\u4e0a\u7684\u89e3\u91cb\uff1a <br \/>Newts \u662f\u57fa\u65bc Apache Cassandra \u7684\u6642\u9593\u5e8f\u5217\u8cc7\u6599\u5132\u5b58\uff0c\u662f\u4e00\u500b\u6301\u4e45\u6027\u7684\u7b56\u7565\uff0c\u53ef\u4ee5\u7528\u4f86\u53d6\u4ee3 JRobin \u6216\u662f RRDtool\u3002 <\/p>\n<p>\u5728 CentOS 7.x \u4e0b\u5b89\u88dd <br \/>1. \u65b0\u589e DataStax \u5957\u4ef6\u5eab\u8a2d\u5b9a\u6a94 <br \/># <span style=\"color: #ff0000\">vim \/etc\/yum.repos.d\/datastax.repo<\/span> <br \/><span style=\"color: #0000ff\">[datastax] <\/span><br \/><span style=\"color: #0000ff\">name = &#8220;DataStax Repo for Apache Cassandra&#8221; <\/span><br \/><span style=\"color: #0000ff\">baseurl = https:\/\/rpm.datastax.com\/community <\/span><br \/><span style=\"color: #0000ff\">enabled = 1 <\/span><br \/><span style=\"color: #0000ff\">gpgcheck = 1<\/span> <\/p>\n<p>2. \u5b89\u88dd GPG Key <br \/># <span style=\"color: #ff0000\">rpm &#8211;import https:\/\/rpm.datastax.com\/rpm\/repo_key<\/span> <\/p>\n<p>3. \u66f4\u65b0\u5957\u4ef6\u5eab <br \/># <span style=\"color: #ff0000\">yum update<\/span>[@more@]4. \u5b89\u88dd Cassandra 3.0.x package <br \/># <span style=\"color: #ff0000\">yum install dsc30<\/span> <\/p>\n<p>5. \u555f\u52d5 Cassandra \u670d\u52d9<br \/># <span style=\"color: #ff0000\">systemctl enable cassandra<\/span> <br \/><span style=\"color: #0000ff\">cassandra.service is not a native service, redirecting to \/sbin\/chkconfig. <\/span><br \/><span style=\"color: #0000ff\">Executing \/sbin\/chkconfig cassandra on<\/span> <br \/># <span style=\"color: #ff0000\">systemctl start cassandra<\/span> <\/p>\n<p>6. \u8a2d\u5b9a OpenNMS Horizon <br \/># <span style=\"color: #ff0000\">cp \/opt\/opennms\/etc\/opennms.properties \/opt\/opennms\/etc\/opennms.properties.$(date +%F)<\/span> <br \/>\u5c07 false \u6539\u70ba true <br \/># <span style=\"color: #ff0000\">sed -i &#8216;\/rrd.storeByForeignSource\/s\/false\/true\/&#8217; \/opt\/opennms\/etc\/opennms.properties<\/span> <br \/>\u53d6\u6d88\u524d\u9762\u7684\u8a3b\u89e3\uff0c\u4e26\u5c07 rrd \u6539\u70ba newts <br \/># <span style=\"color: #ff0000\">sed -i &#8216;\/^#org.opennms.timeseries\/s\/#org.opennms.timeseries.strategy=rrd\/org.opennms.timeseries.strategy=newts\/&#8217; \/opt\/opennms\/etc\/opennms.properties<\/span> <br \/>\u53d6\u6d88\u524d\u9762\u7684\u8a3b\u89e3 <br \/># <span style=\"color: #ff0000\">sed -i &#8216;\/newts.config.hostname\/s\/^#org\/org\/&#8217; \/opt\/opennms\/etc\/opennms.properties<\/span> <br \/># <span style=\"color: #ff0000\">sed -i &#8216;\/keyspace\/s\/^#org\/org\/&#8217; \/opt\/opennms\/etc\/opennms.properties<\/span> <br \/># <span style=\"color: #ff0000\">sed -i &#8216;\/9042\/s\/^#org\/org\/&#8217; \/opt\/opennms\/etc\/opennms.properties<\/span> <\/p>\n<p>7. \u521d\u59cb\u5316 newts <br \/># <span style=\"color: #ff0000\">\/opt\/opennms\/bin\/newts init<\/span> <\/p>\n<p>8. \u9032\u884c\u9a57\u8b49 <br \/># <span style=\"color: #ff0000\">cqlsh 127.0.0.1 9042<\/span> <br \/><span style=\"color: #0000ff\">Connected to Test Cluster at 127.0.0.1:9042.<br \/>[cqlsh 5.0.1 | Cassandra 3.0.9 | CQL spec 3.4.0 | Native protocol v4]<br \/>Use HELP for help<\/span><span style=\"color: #0000ff\">.<\/span> <br \/>cqlsh&gt; <span style=\"color: #ff0000\">use newts;<\/span> <br \/>cqlsh:newts&gt; <span style=\"color: #ff0000\">describe table terms;<\/span> <\/p>\n<p><span style=\"color: #0000ff\">CREATE TABLE newts.terms (<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 context text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 field text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 value text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 resource text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 PRIMARY KEY ((context, field, value), resource)<\/span> <br \/><span style=\"color: #0000ff\">) WITH CLUSTERING ORDER BY (resource ASC)<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND bloom_filter_fp_chance = 0.01<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND caching = {&#8216;keys&#8217;: &#8216;ALL&#8217;, &#8216;rows_per_partition&#8217;: &#8216;NONE&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND comment = &#8221;<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND compaction = {&#8216;class&#8217;: &#8216;org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy&#8217;, &#8216;max_threshold&#8217;: &#8217;32&#8217;, &#8216;min_threshold&#8217;: &#8216;4&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND compression = {&#8216;chunk_length_in_kb&#8217;: &#8217;64&#8217;, &#8216;class&#8217;: &#8216;org.apache.cassandra.io.compress.LZ4Compressor&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND crc_check_chance = 1.0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND dclocal_read_repair_chance = 0.1<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND default_time_to_live = 0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND gc_grace_seconds = 864000<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND max_index_interval = 2048<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND memtable_flush_period_in_ms = 0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND min_index_interval = 128<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND read_repair_chance = 0.0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND speculative_retry = &#8217;99PERCENTILE&#8217;;<\/span> <\/p>\n<p>cqlsh:newts&gt; <span style=\"color: #ff0000\">describe table samples;<\/span> <\/p>\n<p><span style=\"color: #0000ff\">CREATE TABLE newts.samples (<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 context text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 partition int,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 resource text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 collected_at timestamp,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 metric_name text,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 attributes map&lt;text, text&gt;,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 value blob,<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 PRIMARY KEY ((context, partition, resource), collected_at, metric_name)<\/span> <br \/><span style=\"color: #0000ff\">) WITH CLUSTERING ORDER BY (collected_at ASC, metric_name ASC)<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND bloom_filter_fp_chance = 0.01<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND caching = {&#8216;keys&#8217;: &#8216;ALL&#8217;, &#8216;rows_per_partition&#8217;: &#8216;NONE&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND comment = &#8221;<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND compaction = {&#8216;class&#8217;: &#8216;org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy&#8217;, &#8216;max_threshold&#8217;: &#8217;32&#8217;, &#8216;min_threshold&#8217;: &#8216;4&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND compression = {&#8216;chunk_length_in_kb&#8217;: &#8217;64&#8217;, &#8216;class&#8217;: &#8216;org.apache.cassandra.io.compress.LZ4Compressor&#8217;}<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND crc_check_chance = 1.0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND dclocal_read_repair_chance = 0.1<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND default_time_to_live = 0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND gc_grace_seconds = 864000<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND max_index_interval = 2048<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND memtable_flush_period_in_ms = 0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND min_index_interval = 128<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND read_repair_chance = 0.0<\/span> <br \/><span style=\"color: #0000ff\">\u00a0\u00a0\u00a0 AND speculative_retry = &#8217;99PERCENTILE&#8217;;<\/span> <\/p>\n<p>cqlsh:newts&gt; <span style=\"color: #ff0000\">quit<\/p>\n<p><span style=\"color: #000000\">9<\/span><\/span>. \u91cd\u65b0\u555f\u52d5 OpenNMS<br \/># <span style=\"color: #ff0000\">systemctl restart opennms<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c3\u8003\u7db2\u9801\uff1a OpenNMS Installation Guide \u6839\u64da\u5b98\u65b9\u7db2\u7ad9\u4e0a\u7684\u89e3\u91cb\uff1a Newts \u662f\u57fa\u65bc &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/18\/opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-centos\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008OpenNMS &#8211; Apache Cassandra \u5b89\u88dd\u8207 Newts \u8a2d\u5b9a &#8211; CentOS\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,151],"tags":[],"class_list":["post-19602","post","type-post","status-publish","format-standard","hentry","category-c-78462","category-c-78534"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["689039"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19602"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=19602"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19602\/revisions"}],"predecessor-version":[{"id":21107,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19602\/revisions\/21107"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=19602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=19602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=19602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}