Cassandra Continued

So, I've delved more into using Cassandra as a database and it's still been interesting in learning about how it works.

Unfortunately, there really isn't much in the way of a user community who can help out when there are any issues. Additionally, there is not a lot in the way of documentation for setting up Cassandra, using thrift, or anything like that.

Right now, Cassandra is setup in a VM with 1 gig of ram and 1 processor dedicated to it. I've tested inserting data into the datastore. We ran a loop that inserted 10,000 records into the database, and it took about 1 second to insert all the records.

The record included a key, username, timestamp, age, and another timestamp. All records were inserted with a while loop in php. Now, the issues seems to be with reading the data out. We've been attempting to make a php page that will read a specified number of records and print it out to the web page. At the moment, the read is failing at reading anything above 2000 records.

I've talked it over with another individual that is working on this project, and we believe it might be with the "hardware" given to the virtual machine. At the moment, it only has 1 gig of ram available to it, and after reading, it seems that 1 gig is the minimum amount of ram that is recommended when using Cassandra.

Unfortunately, I am rebuilding my raid array at the moment, and will not be able to test out running the VM on my personal computer. Once the array is done being rebuilt, I can start testing it out with higher amounts of memory, and any other resources, and can see if I can get the read going with that.

Looks like it might be a project for the weekend. If anyone else knows about Cassandra, or have tried setting it up, definitely hit me up with how you have your rig configured. I'd be interested in it.