Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-24 Thread Maxim Potekhin
a) I hate to break it to you, but 6GB x 4 cores != 'high-end machine'. It's pretty much middle of the road consumer level these days. b) Hosting the client and Cassandra on the same node is a Bad Idea. It will depend on what exactly the client will do, but in my experience it won't work too

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-24 Thread Gustavo Gustavo
I was able to make Cassandra beat MySQL MyISAM (~10k inserts/s against 6k inserts/s) using two physical machines (laptops) - one the client, and the other one the server, with 50 inserting threads. I don't know exactly why yet, but the high-level client that I was using to C# (Aquiles) was taking

Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread Gustavo Gustavo
Hello, I've set up a testing evironment for Cassandra and MySQL, to compare both, regarding *performance only*. And I must admit that I was expecting Cassandra to beat MySQL. But I've not seen this happening up to now. My application/use case is INSERT intensive, since I'm not updating anything,

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread Chris Gerken
Howdy Gustavo, One thing that jumped out at me is your having put two cassandra images on the same box. There may be enough CPU and memory for the two images combined but you may be seeing some other resource not being shared so nicely - network card bandwidth, for example. More generally,

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread Edward Capriolo
In some sense 1 for one performance almost does not matter. Thou I bet you can get Cassandra better (I remember old school ycsb white paper benches against a sharded mysql). One of the main bullet points of Cassandra is if you want to grow from 4 nodes, to 8 nodes, to 14 nodes, and so on,

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread Maxim Potekhin
Hello, I have some experience in benchmarking Cassandra against Oracle and in running on a VM cluster. While the VM solution will work for many applications, it simply won't cut it for all. In particular, I observed a large difference in insert performance when I moved from VM to real

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread Chris Gerken
Edward (and Maxim), I agree. I was just recalling previous performance bake-offs (for other technologies, long time ago, galaxy far far away) in which the customer had put together a mockup of the high throughput expected in production and wanted to make a decision against that one set of

Re: Cassandra x MySQL Sharded - Insert Comparison

2012-01-22 Thread David Allsopp
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