Re: Cassandra Multi DC (Active-Active) Setup - Measuring latency & throughput performance

2016-02-27 Thread chandrasekar.krc
Thanks Bryan for the inputs. One of the tests that I'm trying to do is fire write requests in one DC and simultaneously do read requests from other DC using cassandra-stress (custom schema option). While reading from the other DC, I'm expecting cassandra-stress to throw some error for no data

Cassandra Multi DC (Active-Active) Setup - Measuring latency & throughput performance

2016-02-26 Thread chandrasekar.krc
Hi, Are there any links/resources which describe performance measurement (latency & throughput) for a Cassandra Multi DC Active-Active setup across a WAN network (20Gbps bandwidth) with 5 nodes in each DC. Basically, I would like to know how to measure latency of writes when data is

Re: Compatability, performance & portability of Cassandra data types (MAP, UDT & JSON) in DSE Search & Analytics

2016-02-19 Thread chandrasekar.krc
Please find below the graph plotted out of cassandra-stress test output log. While the columnar data took 36 mins to insert 20m records, the JSON format data was loaded in under 10 mins. The tests were carried on bare-metal 4 node cluster with 16-core CPU and 120GB memory (8GB Heap) backed by

Cassandra Data Model with Narrow partition

2015-10-30 Thread chandrasekar.krc
Hi, Could you please suggest if Narrow partition is a good choice for the below use case. 1) Write heavy event log table with 50m inserts per day with a peak load of 20K transaction per sec. There aren't any updates/deletes to records inserted. Records are inserted with a TTL of 60

RE: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread chandrasekar.krc
Hi Doan, Is the timeBased() method available in Java driver similar to now() function in cqlsh. Does both provide identical results. Also, the preference is to generate values during record insertion from database side, rather than client side. Something similar to SYSTIMESTAMP in Oracle.

Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread chandrasekar.krc
Hi, Oracle Timestamp data type supports fractional seconds (upto 9 digits, 6 is default). What is the Cassandra equivalent data type for Oracle TimeStamp nanosecond precision. This is required for determining the order of insertion of record where the number of records inserted per sec is