{"id":683,"date":"2016-01-19T01:47:20","date_gmt":"2016-01-18T23:47:20","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=683"},"modified":"2016-03-31T21:09:42","modified_gmt":"2016-03-31T19:09:42","slug":"cassandra-for-wincc-oa-performance","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=683","title":{"rendered":"Cassandra for WinCC OA &#038; Performance&#8230;"},"content":{"rendered":"<p>Did a first test with Cassandra as\u00a0NoSQL database store for WinCC OA event logging.<\/p>\n<p>Cassandra was easy to install, pretty\u00a0good write performance and very good read performance. Compared to e.g. OpenTSDB the CPU load on client and server are\u00a0higher.<\/p>\n<p>Test-Setup: 5000 values\/second, 24h, 392 Mil.Records, One Hyper-V server on an i7 3.1Ghz with 4 Cassandra nodes, each node with\u00a0two cores, disks on a shared storage space device with 4 disks and raid 0 (i know that&#8217;s not a real life scenario for a NoSQL cluster). WinCC OA and the Java-Historian-DB-Logger running\u00a0on another Hyper-V server on an old i5 CPU 750 @ 2.67 Ghz.<\/p>\n<p><a href=\"http:\/\/rocworks.no-ip.org\/grafana\/dashboard\/snapshot\/i1AJArot73eofX1iVnPvjpRXTytjanXe\" target=\"_blank\">Cassandra Performance Stats<\/a><\/p>\n<p><a href=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2016\/01\/Bildschirmfoto-2016-01-19-um-00.42.57.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-684\" src=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2016\/01\/Bildschirmfoto-2016-01-19-um-00.42.57.png\" alt=\"Cassandra Workload\" width=\"852\" height=\"826\" srcset=\"https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2016\/01\/Bildschirmfoto-2016-01-19-um-00.42.57.png 852w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2016\/01\/Bildschirmfoto-2016-01-19-um-00.42.57-300x291.png 300w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Did a first test with Cassandra as\u00a0NoSQL database store for WinCC OA event logging. Cassandra was easy to install, pretty\u00a0good write performance and very good read performance. Compared to e.g. OpenTSDB the CPU load on client and server are\u00a0higher. Test-Setup: &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=683\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,3],"tags":[25,28,26],"class_list":["post-683","post","type-post","status-publish","format-standard","hentry","category-bigdatanosql","category-wincc-oa","tag-bigdata","tag-cassandra","tag-wincc-oa"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=683"}],"version-history":[{"count":1,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions"}],"predecessor-version":[{"id":685,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions\/685"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}