cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kurt Greaves <k...@instaclustr.com>
Subject Re: Cassandra cluster performance
Date Thu, 05 Jan 2017 22:57:01 GMT
you should try switching to async writes and then perform the test. sync
writes won't make much difference from a single node but multiple nodes
there should be a massive difference.

On 4 Jan 2017 10:05, "Branislav Janosik -T (bjanosik - AAP3 INC at Cisco)" <
bjanosik@cisco.com> wrote:

> Hi,
>
>
>
> Our column family definition is
>
>
>
> *"CREATE TABLE onem2m.cse(" *+
>         *"name TEXT PRIMARY KEY," *+
>         *"resourceId TEXT," *+
>         *")"*;
>
> *"CREATE TABLE IF NOT EXISTS onem2m.AeIdToResourceIdMapping(" *+
>         *"cseBaseCseId TEXT," *+
>         *"aeId TEXT," *+
>         *"resourceId TEXT," *+
>         *"PRIMARY KEY ((cseBaseCseId), aeId)" *+
>         *")"*;
>
>
>
> *"CREATE TABLE IF NOT EXISTS onem2m.Resources_" *+ i + *"(" *+
>         *"CONTENT_INSTANCE_OldestId TEXT," *+
>         *"CONTENT_INSTANCE_LatestId TEXT," *+
>         *"SUBSCRIPTION_OldestId TEXT," *+
>         *"SUBSCRIPTION_LatestId TEXT," *+
>         *"resourceId TEXT PRIMARY KEY," *+
>         *"resourceType TEXT," *+
>         *"resourceName TEXT," *+
>         *"jsonContent TEXT," *+
>         *"parentId TEXT," *+
>         *")"*;
>
> *"CREATE TABLE IF NOT EXISTS onem2m.Children_" *+ i + *"(" *+
>         *"parentResourceId TEXT," *+
>         *"childName TEXT," *+
>         *"childResourceId TEXT," *+
>         *"nextId TEXT," *+
>         *"prevId TEXT," *+
>         *"PRIMARY KEY ((parentResourceId), childName)" *+
>         *")"*;
>
>
>
>
>
>
>
> *From: *Abhishek Kumar Maheshwari <Abhishek.Maheshwari@timesinternet.in>
> *Date: *Sunday, December 25, 2016 at 8:54 PM
> *To: *"Branislav Janosik -T (bjanosik - AAP3 INC at Cisco)" <
> bjanosik@cisco.com>
> *Cc: *"user@cassandra.apache.org" <user@cassandra.apache.org>
> *Subject: *RE: Cassandra cluster performance
>
>
>
> Hi Branislav,
>
>
>
>
>
> What is your column family definition?
>
>
>
>
>
> *Thanks & Regards,*
> *Abhishek Kumar Maheshwari*
> *+91- 9999805591 <+91%2099998%2005591> (Mobile)*
>
> Times Internet Ltd. | A Times of India Group Company
>
> FC - 6, Sector 16A, Film City,  Noida,  U.P. 201301 | INDIA
>
> *P** Please do not print this email unless it is absolutely necessary.
> Spread environmental awareness.*
>
>
>
> *From:* Branislav Janosik -T (bjanosik - AAP3 INC at Cisco) [mailto:
> bjanosik@cisco.com]
> *Sent:* Thursday, December 22, 2016 6:18 AM
> *To:* user@cassandra.apache.org
> *Subject:* Re: Cassandra cluster performance
>
>
>
> Hi,
>
>
>
> - Consistency level is set to ONE
>
> -  Keyspace definition:
>
>                     *"CREATE KEYSPACE  IF NOT EXISTS  onem2m " *+
>         *"WITH replication = " *+
>         *"{ 'class' : 'SimpleStrategy', 'replication_factor' : 1}"*;
>
>
>
> - yes, the client is on separate VM
>
> - In our project we use Cassandra API version 3.0.2 but the database (cluster) is version
3.9
>
> - for 2node cluster:
>
>          first VM: 25 GB RAM, 16 CPUs
>
>          second VM: 16 GB RAM, 16 CPUs
>
>
>
>
>
>
>
> *From: *Ben Slater <ben.slater@instaclustr.com>
> *Reply-To: *"user@cassandra.apache.org" <user@cassandra.apache.org>
> *Date: *Wednesday, December 21, 2016 at 2:32 PM
> *To: *"user@cassandra.apache.org" <user@cassandra.apache.org>
> *Subject: *Re: Cassandra cluster performance
>
>
>
> You would expect some drop when moving to single multiple nodes but on the
> face of it that feels extreme to me (although I’ve never personally tested
> the difference). Some questions that might help provide an answer:
>
> - what consistency level are you using for the test?
>
> - what is your keyspace definition (replication factor most importantly)?
>
> - where are you running your test client (is it a separate box to
> cassandra)?
>
> - what C* version?
>
> - what are specs (CPU, RAM) of the test servers?
>
>
>
> Cheers
>
> Ben
>
>
>
> On Thu, 22 Dec 2016 at 09:26 Branislav Janosik -T (bjanosik - AAP3 INC at
> Cisco) <bjanosik@cisco.com> wrote:
>
> Hi all,
>
>
>
> I’m working on a project and we have Java benchmark test for testing the
> performance when using Cassandra database. Create operation on a single
> node Cassandra cluster is about 15K operations per second. Problem we have
> is when I set up cluster with 2 or more nodes (each of them are on separate
> virtual machines and servers), the performance goes down to 1K ops/sec. I
> follow the official instructions on how to set up a multinode cluster – the
> only things I change in Cassandra.yaml file are: change seeds to IP address
> of one node, change listen and rpc address to IP address of the node and
> finally change endpoint snitch to GossipingPropertyFileSnitch. The
> replication factor is set to 1 when having 2-node cluster. I use only one
> datacenter. The cluster seems to be doing fine (I can see nodes
> communicating) and so is the CPU, RAM usage on the machines.
>
>
>
> Does anybody have any ideas? Any help would be very appreciated.
>
>
>
> Thanks!
>
>
>
> A must visit exhibition for all Fitness and Sports Freaks. TOI Global
> Sports Business Show from 21 to 23 December 2016 Bombay Exhibition Centre,
> Mumbai. Meet the legends Kaizzad Capadia, Bhaichung Bhutia and more. Join
> the workshops on Boxing & Football and more. www.TOI-GSBS.com
>

Mime
View raw message