cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Allsopp <dnalls...@gmail.com>
Subject Re: Cassandra x MySQL Sharded - Insert Comparison
Date Sun, 22 Jan 2012 21:12:34 GMT
When I did some performance testing on Cassandra 0.7.6, I was getting
10,000 - 20,000 inserts per second on a *single *Cassandra node, on real
hardware (a consumer desktop PC with 4 GB RAM). Cassandra has got
substantially faster since then. I was inserting 1KB columns each on a new
row, if I remember right, using multiple clients on localhost (each in its
own process).

So unless your values are much larger than 1KB, you should be able to get *much
*greater write throughput out of your 4-node cluster.

Several folks have pointed out issues - you need a physical machine per
node, and you need multiple clients in order to exploit the concurrency in
Cassandra (even when testing a single node). Ideally more RAM per node
would be good too.

On 22 January 2012 13:10, Gustavo Gustavo <dotnetdev.javadev@gmail.com>wrote:

>
>
> Cassandra x 4
> 2012-01-21 11:45:38,044 #6         [Logger.Log] INFO  - >> Inserted 10000
> positions for 1000 vehicles (10000000 inserts):
> 2012-01-21 11:45:38,082 #6         [Logger.Log] INFO  - >> Total Time:
> 2:37:03,359
> 2012-01-21 11:45:38,085 #6         [Logger.Log] INFO  - >> Throughput:
> 1061 inserts/s
>
> And for MySQL x 2
> 2012-01-21 14:26:25,197 #6         [Logger.Log] INFO  - >> Inserted 10000
> positions for 1000 vehicles (10000000 inserts):
> 2012-01-21 14:26:25,250 #6         [Logger.Log] INFO  - >> Total Time:
> 2:06:25,914
> 2012-01-21 14:26:25,263 #6         [Logger.Log] INFO  - >> Throughput:
> 1318 inserts/s
>
> Is there something that I'm missing here? Is this excepted? Or the problem
> is somewhere else and that's hard to say looking at this description?
>
> Cheers,
> Gustavo
>
>

Mime
View raw message